How to generate a URL that only the user can see via airtable?

[Rose_Haft1]

I am wanting to submit a form and redirect the user to some digested results. Is this possible?

There is an example here: https://support.airtable.com/hc/en-us/articles/206058268-Guide-to-forms#redirect

but I cannot figure out how to configure this for redirect for the script-digested information post submit.

Best,
Rose

[Nick_Dennis]

I believe there should be one more set of parameters, identifying the Base’s table, before {record_id}.

You can get the table url by expanding a record from the table this form adds to. The url will look something like: https://airtable.com/xxx/xxx/recRwoPIVFQlf0ICB?blocks=hide

Remove everything starting at “rec…” and replace with {record_id}. So the final url looks something like: https://airtable.com/xxx/xxx/{record_id}

[Rose_Haft1]

Hi - Do you have an example? I’m not sure what to put in the xxxs. I’ve tried a view link, table link and form link but none are working…

[Rose_Haft1]

Also, how do I filter it so they can only have access to their own…?

[Nick_Dennis]

While viewing Airtable in a browser, The /xxx/xxx/ I’m talking about is simply the url that will display when you are viewing the table in question. You can expand a record with space bar or clicking the arrow next to its number to get the specific record_id, but you don’t really need to in this case.

Another way to describe the format of the url is: airtable.com/base_id/table_id/rec_id/

You really just need the unique base and table id’s, which you can get from the url, and then you’ll use {record_id} to append the new record_id to the end.

So the format will end up as https://airtable.com/base_id/table_id/{record_id}

And as far as I know, you can’t filter like that. They will redirect to a popup with their unique information, but I believe they can just close it and see the whole table as well.

[ScottWorld]

@Rose_Haft1 No, you can’t create unique formulas as a redirect URL after a form is submitted. The URL must be static.

You could automatically email the person their unique URL after the form is submitted. However, you wouldn’t want to do that, because it would reveal all of the records in your entire view if you shared a view. So it would only be appropriate for collaborators. Unless you manually created a different view for each person.

You’d likely have to pay for external tools to do what you want, such as the tools offered by MiniExtensions.com.

p.s. If you have a budget for this project and you’d like to hire an expert Airtable developer to help you setup any of this, please feel free to contact me through my website at ScottWorld.com.

[Rose_Haft1]

Hi Scott - At the moment, I think I will see if I can just make it work with gravity forms and run a custom script on my website… but I will let you know if I do need an airtable developer :grinning_face_with_big_eyes:

[ScottWorld]

Great! Yes, writing a custom script that taps into Airtable’s API should work.