SeekWell Forms allow you to expose SQL statements as Forms to non-technical teammates. Team members are able to execute pre-defined SQL statements without any SQL experience! Simply set upParameters for a query and share the link to the form with your team.
<aside> 💡 SeekWell does no manipulation on your SQL statements to prevent SQL injection. Do not expose blocks or forms to untrusted users. You should prefer Selects over Value parameter types and use Approval Queues and Lookups where appropriate.
</aside>
Create a new block and add at least one Parameters
Test the SQL statement and ensure results are as expected
To view the block as a form, hit command / ctrl + k → "Create Form"
Test the Form again with new inputs
Note: Only admin's see the SQL preview and ability to edit the block
To share the form with your team, copy the URL
You can also set defaults in the URL with URL parameters
You can require Form submissions to be approved by an admin on your team. When creating the Form, select "Requires approval" from the drop down on the left. Admins can approve submission from the queue by changing the status to "Approved".
If you use a "lookup" field in the form, the user will be first prompted for that value before being able to submit. Once the user provides a value for the lookup field, the "Lookup Block" will run and populate any matching values in the Forms parameters.
Click "Add Lookup" under Parameters
