Button URL - Airtable FIeld Value

Ask the community
1

Hi all

New to Softr but have a pretty detailed Airtable base in place that I’m building a Client Portal off.

In Airtable, I have a formula field against each Contact with a custom pre-filled link if they wish to book in my calendar, simply to prevent them re-entering their information, and to instantly automate events and actions back to that specific person.

I was hoping when I created a button in Softr that I could set the value = the field value in Airtable but I don’t see this option.

The final URL should look like this.

https://cal.com/abcdef/consult?name={logged in username}&email={logged in email}&AirtableID={Airtable Contact ID}

Is there a magical way for me to either reference my Airtable field to dynamically populate the button URL, or alternatively, any other way at all to provide a dynamic link in this manner, please?

Thanks, Brendan

2

Hey nocode,

That depends a little on what block you are using. If you use a list details block you can create an action button “open URL” which can refer to the URL you posted. Currently there is no dynamic tokens available for external URL’s if it is not a details list block. However, there are workarounds :stuck_out_tongue:

3

Thank you for the reply Marc.

I was using a static block, and your response mentioning dynamic block gave me that slap on the forehead moment… of course I can’t use a static block for this.

So solved this thank you, simply by using a dynamic list. What an idiot!

Thanks so much for your prompt response.

4

Happens to the best of us! Glad you can continue.

1 Like
5

Hey Marc, can you tell me about workaround options?

6

Hi Soulfoodz

Workaround if your button is on the home page (VERY IMPORTANT that its homepage and your user is logged in) :

  • add a action button that opens an external url.
  • use make or zapier to create a webhook and use the following for the url:
    my.webhook.com/Name={LOGGED_IN_USER:NAME)
  • make an automation with the following modules , receive webhook → Search records in Airtable (based on the logged in user name) → webhook response, with status 307, advanced settings, custom header key: location - Value : your stored url from the airtable

If it doesn’t come from the homepage the action or your users are not logged in, you will have to do some janky form magic… which I would just from a UX perspective recommend against. Is this helpfull?

7

Yep! I was hoping there would be a more straight forward solution with a custom code block, but I guess I’ll have to figure out a different route. Thank you!