...
- Open the SQL Server Configuration Manager and make sure that Named Pipes and TCP/IP are enabled for your SQL instance. If you have to make any changes here a restart of the SQL instance will be required.
- Ensure the SQL Server Browser service is running
Configuring Your Route
- Navigate to X:\GlobalForms\config and open default.json (X: is the drive in which GlobalForms is installed)
- Locate the section titled resequel which is where we will be configuring our server information. Populate the server information as shown below using your server information and the user you created.
- In the resquel section, configure the following:
- User: This is the SQL user you will use to establish your connection.
- Password: The password used for the user defined above.
- Server, defined as: SERVERNAME\\INSTANCENAME, if your SQL Server doesn't have an instance name, simply just put the server name.
- Database: The target database that the queries will originate from and be relative to.
- Request Timeout: How long (in milliseconds) requests will time out.
...
- Within the GlobalForms design surface drag over a select control.
- On the data tab change Data Source Type to URL and then in the Data Source URL put the route you created. In this example http://localhost:3001/vendorNames.
- Enter rows in Data Path and then the key that contains the value of your data in the Value Property.
- In this example it is Field21. This is going to be the value of the data that is passed when the form is submitted.
- In the Item Template box you will specify how you want the data to display in the select control. The format of this box will be <span>{{ item.[Key] }}</span>.
- In this example, <span>{{ item.Field21 }}</span>
- Save and test your form.
