❓
Knowledge Base
📋

Forms

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 up

for a query and share the link to the form with your team.

💡
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.

  1. Create a new block and add at least one
    ⚙
    Parameters
  2. Test the SQL statement and ensure results are as expected
  3. To view the block as a form, hit command / ctrl + k → "Create Form"
  4. Test the Form again with new inputs
    5. Note:
    Note: Only admin's see the SQL preview and ability to edit the block
  5. To share the form with your team, copy the URL
  6. You can also set defaults in the URL with URL parameters

Approval Queues

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".

image

image

Lookups

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.

  1. Click "Add Lookup" under Parameters
    2. image
  2. Select the field in the Form you want use to lookup values in the "Lookup Block"
    3. image
  3. Select the field in the "Lookup Block"
  4. Select the name of the field in the "Lookup Block" that matches the "Form Block"

For example if you create a Lookup Block of:

select column_one, column_two
from table_name
where column_three = '{{column_three}}'

And your form has the following parameters:

  • column_one
  • column_two
  • column_three (lookup field)

When the user submits a lookup on column_three, both column_one and column_two will be populated with current values from the Lookup Block

Navigation

Hit command / ctrl + k → "Forms" to see a list of all your Forms and quickly jump to one