Lookup record

Use a lookup query when a form needs to check whether a record exists before the user continues.

Build the query

1. Open the relevant datasource
2. Create a query that looks up the row you need
3. Add a binding for the lookup value
4. Save and test the query

Build the form

1. Add a Form
2. Add the input field you want to check
3. Add a button to run the lookup query

Add the actions

1. Run the lookup query
2. Save the returned row ID to app state
3. Stop the action chain when the query returns no rows
4. Show a warning notification when the record is not found

Show the result

1. Add a Repeater or Form block
2. Filter the data by the saved row ID
3. Hide the component when no record was found

Try it out