Skip to main content

I need help creating a formula that will create a link that will show property details, access codes, checklists, photo uploads (for a cleaning business) thank you in advance!

Hey ​@BuenaVista,

 

What you are making reference to is usually called a “dynamic URL” which uses URL parameters :D

 

I guess your data is living in Airtable right? Would you mind sharing root URL, and field names that should be included? Or even better an example of a full URL?

 

Mike, Consultant @ Automatic Nation

 


Hello Mike! thank you so much for the response i’ve been trying to fix it all week, how could i share it to you?


@BuenaVista 

You can't do that in Airtable, unless your users create Airtable accounts for themselves, and then you give them read-only access to an interface where they can see the records that you have assigned to them.

This is 100% free, as long as you keep them read-only.

However, another 100% free way of doing this — which would probably be much much easier for you — is to simply use Fillout’s advanced forms for Airtable, which lets you update Airtable records with a form.

But instead of letting users UPDATE the record, you would simply let them VIEW the record by hiding the submit button, and by displaying your fields in a read-only state.

This would be much easier for you, and you also wouldn't need to create any complicated URL formulas, because Fillout gives you the very simple formula to use.

I show how to use a few of the advanced features of these “update forms” on this Airtable podcast episode:

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


ohh okayy, thank you ScottWorld, do you think there is a way to do it through make.com instead of fillout? since i will be using make.com for other functions as well!

 


@BuenaVista 

That is a fantastic idea that I hadn’t thought about! I love Make, and I always recommend that everybody use it for all of their automations and integrations!

Normally, Make does not have a user interface that you can use to show Airtable records to your employees.

But there is one exception to this rule:

You can use custom webhook responses to display information to your users in their web browser.

If you setup a scenario in Make that starts with a custom webhook, Make will give you the URL that you would give to your employees. You would just need to create a formula in Airtable that attaches the Airtable Record ID as a URL parameter to the end of the URL.

Then, you can use Make to display all the record information to your employees in their web browser by using Make’s webhook response module.

Your scenario would be as simple as my screenshot below.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld