Help

Publishing Filtered Results on Interface

Solved
Jump to Solution
634 3
cancel
Showing results for 
Search instead for 
Did you mean: 
cshenoy86
7 - App Architect
7 - App Architect

Hi,

This is my interface page where I select investor from the dropdown. I have added a filter below and I want the filter to have the value selected from the dropdown.

cshenoy86_1-1704112898315.png

I understand that this kind of dynamic value setup is not possible in airtable interfaces as of today. So I am thinking of using airtable automation.

Now when the user clicks the Set Carrier button, a script runs saving the name of the selected carrier in a variable. I can add a 'Find Records' step in the automation to use the same variable and filter the results. Now is there a way to publish the output of Find Records back to the interface page? I am able to see the records while testing automation. However a feature that can publish these as a list on the interface page would really be helpful. Any thoughts/suggestions? Or is this kind of setup possible only through a third party tool?

cshenoy
1 Solution

Accepted Solutions
joshsorenson
6 - Interface Innovator
6 - Interface Innovator

You might check out this hack that Gap Consulting posted about a few weeks back https://youtu.be/PW3A2Vi1_fw?si=4-rJIdxibNdH1-7F

See Solution in Thread

One of the limitations of Airtable is that it does not have a solution for Dynamic Filtering of data inside linked relationships. But thanks to this workaround, you can build a hack that allows you to create dynamic filters. In this video, we'll showcase how to filter contacts based on linked ...
3 Replies 3
joshsorenson
6 - Interface Innovator
6 - Interface Innovator

You might check out this hack that Gap Consulting posted about a few weeks back https://youtu.be/PW3A2Vi1_fw?si=4-rJIdxibNdH1-7F

One of the limitations of Airtable is that it does not have a solution for Dynamic Filtering of data inside linked relationships. But thanks to this workaround, you can build a hack that allows you to create dynamic filters. In this video, we'll showcase how to filter contacts based on linked ...

Thank You! I checked this video and tried out something. When the button as shown in the interface above is clicked, an automation runs as shared below:

cshenoy86_0-1704173045108.png

I will be creating a dynamic view and use that view to show the results on the interface. However, in the automation I seem to have trouble with the last step 'Update Records'. I am selecting the records using ids from the previous step and then using those to update (see screenshot below)

cshenoy86_1-1704173167602.png

However it just gives me error without any detailed explanation of what the error is. I tried adding the record id statically and it works but whenever it dynamically selects ids from the previous step, see this error 'Received invalid inputs'. I also checked each record id one by one to see if they exist in my base and they do. I am not sure what invalid inputs mean. There is no detailed explanation in the Results as well. Any thoughts?

 

cshenoy

I figured out from airtable support that I wasn't using a repeating group after 'Find Records' which is why I was getting the error. Now the script works fine. Thanks for this response!!!

cshenoy