
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 02:10 PM
Hello all,
I hoped to close a project that I worked on for a few weeks today just to realize that synched tables do not behave as I expected. Using synched tables, records get a new Record ID in the destination.
My workflow works a lot based on (pre-filled) forms. Now how can I pre-fill a form with a record from a synched table?
Cheers
Christoph

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 02:34 PM
Just use the formula RECORD_ID()
in your source table, and then sync that field to your destination table.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 02:43 PM
That does not seem to work because records get a new Record ID in the destination.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 02:51 PM
You can see the record ID from the source table in your destination table. But no, that doesn’t represent the record ID of that record in the destination table. It lets you pinpoint that record in the source table, though.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 02:54 PM
In my case, the Record ID is dynamic. The record contains a button, prefilling another form referencing to the record that was selected in the first place.
The Button looks like this:
“https://airtable.com/vgvbjhbjgvryfhgbjhb?prefill_Creator=recIU7t6ggygTTFH&prefill_Status=Review&pref...”&{Record ID}
The dynamic {Record ID} references to the source but should refer to the destination. I am sure there are good reasons why record ids change in synched tables… for this case it sucks.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 02:55 PM
The form I want to fill “lives” in the destination table, not the source table. If that makes sense.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 03:13 PM
Not sure I understand what you’re trying to do. You have access to both record ID’s in your destination sync table, so you can do whatever you want to do based on either record ID that you desire.
Also, destination sync tables are read-only, so you can’t change any records there (unless you add new fields on the destination side).
If you’re having trouble with creating your prefill link, I would check out @kuovonne’s Prefilled Forms extension:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 03:35 PM
Thanks for taking the time to help. Let me try to explain better.
EDIT: While I was writing everything down, I noticed my mistake. The form must live in the destination base. Now it works. Thank you for your help!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 03:45 PM
Just to clarify, your form can likely live in either base, but I’m glad that you got it working for your needs! :grinning_face_with_big_eyes:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 24, 2022 05:49 PM
I don’t think the form with the button containing the formula below can live in either base:
“https://airtable.com/vgvbjhbjgvryfhgbjhb?prefill_Creator=recIU7t6ggygTTFH&prefill_Status=Review&pref...{Record ID}
Only within one base the “dynamic” {Record ID} is known and refers to a record in that base.
If you are interested I am happy to explain it in more detail.
