[Anonymous]

Hello, I am trying to use quick Apps for SharePoint SIListForm.  I would like to accomplish using a field entered in the form to query a specific SQL database and table and return data that will then be populate four fields with the data returned by the query.  Is this a control that is possible in QuickApps? If so, would these be operation and parameter controls that require set up in the web.config file or would these need to be system controls that are then set up and then linked within the web.config file as specific Systems and Services?

[Anonymous]

Hi Steven,

n

In my understanding for your case, you can use two qSIListForm to accomplish that.

n

One qSIListForm is configured as “NewEntity” mode, set the “Set Session Name” in Catalog setting, then you can just save the Catalog setting. Add some Display Fields as the query criteria, for example, add the “id” as the display field. Then configure the “Actions” setting, add an action, the Action Type is “GoToURL”, the URL is the current page address, that for the page can be refreshed after click this command.

n

The other qSIListForm, configure the “Catalog” setting, add an operation, select the store procedure that need to provide the query parameter, in this sample, the query parameter is “id”, configure the “id” parameter, select the “Source” to “Session”, fill the same session name with the first qSIListForm, the “Source Name” to “id”, finish the Catalog setting; select some Display fields; please make sure that the “Form Type” is not the “DisplayEntity”, here set it to “DisplayEntity”. Save all.

n

After above, you can set the id field in the first qSIListForm, and then click the command in the tool bar, the second qSIListForm should be able to get the “id” parameter to query the DB and populate its form.

n

Hope that can help you.

n

–

[Author]

Posts