The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hello,
This is more like How to make a ‘single field from a synced record permanent’. But I thought that may be a confusing subject title.
I am trying to use synced data and make a field permanent regardless of what happens to the initial data.
Examp...
@Adam_TheTimeSavingCo ,
Thank you for your solution. It worked perfectly for me.
It took me a few days to get around to testing but I finally did it this evening and it is working fine.
Thanks again for your generosity
Ok,
I see what you are doing.
You have created an additional column that is just single text and then the automation copies the JobID# to that column so that when the lookup is broken (or the synced record deleted), the JobID# in the single text colu...
Thank you @Adam_TheTimeSavingCo,
It is setup similar to this right now, except is a manual process (not an automation).
I have a lookup field in the Other Table that pulls in the JobID# and then I have a formula in the first column that combines the ...
Thank you for the detailed response, however your answer is a bit complex for what I am trying to do right now. I am relatively new to airtable and have not yet worked with webhooks and scripts. Still learning the ropes and this is the first sync I h...
Thank you for you response.
This is for a Job Tracking system (Base 1) which creates a unique JobID# for every job created.
The second base is a CRM (Base2) which will sometimes link to a JobID# from Base 1 but not always.
I can manually type in the ...