Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Zapier Find Base and Table ID for generating Record Links for other Software

cancel
Showing results for 
Search instead for 
Did you mean: 
Keegan_Walls
5 - Automation Enthusiast
5 - Automation Enthusiast

Is there a way we can pull in Base and Table ID so that we can build links to different records etc?

I would love to be able to when a record enters a view it starts a trigger and then sends an email with a link to that record view

3 Comments
Julian_Kirkness
10 - Mercury
10 - Mercury

Hi

This is possible, yes…

  1. First you need to find the URL of the Expanded view of a record in your table.
  2. Then create a formula field in the table consisting of the URL minus the record ID on the end.
  3. Add the RecordID() to the formula

Screen Shot 2017-12-09 at 12.58.18.png

This results in a field containing a link to the expanded view of the record - and it will be available in Zapier to send to other apps or include as a link in an email.

Keegan_Walls
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi

That doesn’t actually pull in the BASE or TABLE ID. I have to manually go find them.

That is what I am currently doing but it is far from ideal and would love to be able to work with it more dynamically!

Mathieu_Quiniou
6 - Interface Innovator
6 - Interface Innovator

Nobody found a solution ?