Create a selected list of items from airtable

Ask the community
1

Hi, newbie here and wonder if it is possible to do the following

I created a table block from my airtable database. This table block has a number of selectable tags so my customers can narrow down the database based on the tags (conditions) he chose.

What I hope to have is to create a view list on my airtable which will be unique to his account, based on the tags he has chosen. And on the softr portal, he can then a checkbox to decide the items he wants. The checklist should then push back to his unique airtable database so we know what item he selected, and we can download that list as CSV file. In other words both airtable and softr needs to dynamically talk to each other with read/write capability, but doing it on a separate view rather than directly affecting the main database.

2

Hi @Ivan.

Apologies for the late reply. Here is a workaround that I can suggest for such a use-case.

  1. In my base, I have a table where users submit their preferences. In this table, I have fields for user email and the topic they select. I also have a formula field, which we will address later.



  1. On my app side, I have a form block that gathers the logged-in user’s preferences.

I grab also the name and the email address of the form submitter via a hidden field.



  1. On your app, you need to create a page with the list block you want and take the URL of that page.



  1. In your base, in the formula field, use a concatenate formula which will dynamically prefill the inline filters on that page based on the form selections. In my case, the formula is this:

CONCATENATE("https://brainboost.softr.app/listurl?filter-by-Project=", ENCODE_URL_COMPONENT({Options}))

Please change the page URL with your page URL and the inline filters with your desired inline filters.

I am dynamically creating the pre-filled URL described in this article using the concatenate formula. How to filter list data from the URL? – Softr Help Docs

  1. Create a list details block on your app with a conditional filter so that each user sees only the data with their preferences, and have an Open URL button on the list details block which will redirect them to this page.





  1. Set the page after form submission to be this list details page.



So, the users will set their preferences with a form submission. When the form is submitted, the prefill URL will be generated. Then, after form sign-up, the users will be redirected to the list details page, click on the button, and be redirected to the prefilled list page according to their preferences.

Here is a recording too. Brainboost

Please let us know if you have more questions.

For form prefill, please refer to this video tutorial too: https://www.youtube.com/watch?v=43IgzlRI2CQ&ab_channel=NomoCodes-Buildappswithno-code%26AI