Thanks for the input. Here’s some more detail around the use case. I have many forms for a multi-table base. I don’t necessarily have complete data when filling out a form, so I generate a table of incomplete forms for review at the end of the day (rather than searching table by table). Since the records in the “LOG” table of incomplete forms has the record URL, I just click on the record URL to complete each record.
I do this with a Zapier formula (actually, I have one formula for EACH table in the base).
Step 1. Trigger on a new record and grab the RECORD_URL
Step 2. Find the record RECORD_URL
Step 3. Append the RECORD_URL to a field in the record (for future reference only)
Step 4. Create a record in “LOG” table with the name of the record and the record URL
This multistep zap is performing reliably but it really eats up my allotted zap total each month. I can do some of the job with IFTTT, which is free, but IFTTT can’t update an existing record.
What I was looking for, I suppose, is a formula or function or special field (like CREATED DATE). Before I made a feature request, I thought I’d check in with the users to see if there was already such as formula/function/field.