Filtered Lookup in Coda Forms

Explore

Filtered Lookup in Coda Forms

Filtered Lookup in Coda Forms

Filtered Lookup in Coda Forms

Todd Cranston-Cuebas

Approved Job Titles

Filtered Lookup Table

Form with filtered lookup

Live Preview

What is a filtered lookup?

Filtered selection lists in forms is harder to explain than to demonstrate. Look at the video below for a quick example.

⁠

As you can see, the choices presented for Job Title change based on the selection made for Department.

This has two major advantages. First, it’s far easier for your user to make an appropriate selection (i.e., does not have to look through ALL jobs to find one appropriate for the department). Also, for the doc maker it provides a level of validation and control where users can only make correct choices.

How does this work?

Primary & Secondary Category Table

Start off by making a simple table with primary category and secondary categories of information that will be used in the filtered lookup. In this case, the primary category is Departmentand secondary category is Job Title). They can be found in the table

Approved Job Titles⁠

⁠

Filtered Lookup Table

Next, create a table that will be used to store all responses to your form. This table will receive all of the choices and data entered by your form user. In this case, I simplified the form to only show the two columns necessary to demonstrate a filtered lookup. Refer to the table

Filtered Lookup Table⁠

Here’s a video showing the lookup, selection list and formulas to set up the connection between the

Approved Job Titles⁠

table and

Filtered Lookup Table⁠

⁠

Creating the Form

Creating the form is very straightforward however, because you are looking up information from another table, you have to make an update to the privacy settings for the lookup to work as expected. See the video below for how to change these settings.

⁠

Copy this doc

Remember, if you want to play with this doc and look at the tables and formulas, here’s a button to

Copy this doc

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.