Skip to main content
Solved

Publishing Filtered Results on Interface

  • January 1, 2024
  • 3 replies
  • 64 views
C
Forum|alt.badge.img+12

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.

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?

Best answer by joshsorenson

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

cshenoy

3 replies

joshsorenson
Forum|alt.badge.img+9
  • joshsorenson
  • Participating Frequently
  • Answer
  • January 2, 2024

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

C
C
Forum|alt.badge.img+12
  • cshenoy86
  • Author
  • Inspiring
  • January 2, 2024

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


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:

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)

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
C
Forum|alt.badge.img+12
  • cshenoy86
  • Author
  • Inspiring
  • January 4, 2024

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:

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)

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?

 


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
Terms & ConditionsAccessibility statement