Blog Elements

Half Sized Blog Element (Single Author Style)

Half Sized Blog Element (Multi Author Style)

General, Knowledge Base, PowerForms Siverlight

How file uploading works (for new and existing records)

Navigate to Attachments Tab. A user can add attachments in two different ways, by browsing for files or by dragging and dropping files on the Existing Attachments area. Browsing for Attachments: Select . The new Browse Feature allows multiple files selection from the same location or multiple browse actions to select files from multiple locations. Select the desired […]

August 15, 2017/by Konstantinos

General, Knowledge Base, PowerForms Siverlight

Set Default Values using the querystring

In the Querystring, you can define values that will be used as default values for a new record. The keyword “ID” is reserved and when used in the querystring, the form tries to load the record with the ID specified. All the other field names can be used to apply default values in the form […]

August 15, 2017/by Konstantinos

General, Knowledge Base, PowerForms Siverlight

How file uploading works (for new and existing records)

August 15, 2017/by Konstantinos

General, Knowledge Base, PowerForms Siverlight

Set Default Values using the querystring

August 15, 2017/by Konstantinos

How file uploading works (for new and existing records)

Navigate to Attachments Tab.

A user can add attachments in two different ways, by browsing for files or by dragging and dropping files on the Existing Attachments area.

Browsing for Attachments:

Select

. The new Browse Feature allows multiple files selection from the same location or multiple browse actions to select files from multiple locations. Select the desired files and press Open.

Note: The selected files are added to the list of pending files and are not uploaded yet.

At this stage, you can remove the selected files by pressing or finish uploading the files by pressing or Save Record. During Save, all pending files are uploaded.

Dragging and Dropping Files as Attachments

An easier way to handle attachments is to Drag-and-Drop the desired files on the Existing Attachmentsarea. The dragged files are added to the list and follow the same mechanism for uploading as described above.

Open Attachment

To view the contents of an attachment, select the desired file and press .

Deleting Attachments

Select the desired attachments and press . Multi-Selection works.

August 15, 2017/by Konstantinos

Set Default Values using the querystring

Code

http://<servername>/<site>/New.aspx?<FieldName1>=<Value1>&<FieldName2>=<Value2>…

For example :

We want to set the Category field (combobox lookup to another list) to 1, the Evaluation field (choise) to Negative, the PublishedDate field to the current date and the Priority field (popup lookup picker) to 3;#Medium.

The querystring should look like this :

Code

http://url_to_form/page.aspx?Category=1&Evaluation=Negative&PublishedDate=%3Dtoday()&Priority=3;%23Medium

Notice that in the DateField we are actually applying a formula to the default value (=today()) and we escape the ‘=‘ character with %3D. We also have to escape the # character with the %23 equivalent.

NOTE : The keywords : “Type”, “RootFolder”, “ID” and “Source” are reserved from SharePoint and cannot be used as querystring default values.

We have 2 lists :

1. Customers. Columns : ID, Title

2. Orders. Columns : ID, Title, Date, Customer (Lookup for Customers)

In order to add multiple orders for the same customer, we should add a hyperlink control in the customer form.

The value of the control should be the absolute url of the NEW ORDER item. For example :

http://ServerName/Lists/Orders/NewForm.aspx?Source=xxxxx

In order to apply default value for the customer field, we make the hyperlink control calculated and we apply the following formula :

Code

http://ServerName/Lists/Orders/NewForm.aspx?Source=xxxxx&Customer={c_ID};%23{c_Name}

We use the following format since the default value should be in the ID;#Title format.

This allows the users to navigate to the New Order form directly from the customer form and execute multiple SAVE (NOT Save and Exit) and NEW actions without having to set the Customer field.

August 15, 2017/by Konstantinos

Half Sized Blog Element (Single Author Style)

Half Sized Blog Element (Multi Author Style)

Full Sized Blog Element (Big Preview Pic)