We recently added features to filter and limit the records that show in connection inputs.
You can now add filters to any connection input to filter which records will display.
For example, let’s say you have a form to add a new Rental. Each Rental is assigned to a Product, which has an “available” field. You can now add a filter to only show those Products where “available = true”.
Showing records connected to another form input
Multiple connection inputs can be added to a form so that the records of a child connection input will display depending on which parent connection record is selected.
For example, if you have connections to both companies and employees, you can edit employees so that only records connected to the currently selected company will display. When the user selects a different company the employee records will automatically update.
Limiting child records connected to the same parent
You can also limit connection records that have a parent that has been selected in the app or connected to the logged-in user.
For example, let’s say you select a Company from a table and then have a form to add a Project to that Company. Projects can also be assigned to an Employee. When selecting Employees, you’ll only want to show the Employee records that are connected to the selected Company.
You can now edit that Employee input in the form and have
Please note: these features are in beta
Please note that these features are in beta. Please contact us immediately if you notice any issues with these features.