Hi all,
I have 2 tables in a base (Businesses & Users); I’m using the scripting block to upload a JSON file and add new records to the bases if they don’t already exist. Attached are the screenshots of the 2 tables and the script.
When the ‘Users’ & ...
I also believe it can be done. I’m just not able to figure it myself at the moment. I might come back to it later.
Noted, I un-marked it. Thanks for your assistance and suggestions. Greatly appreciated. If someone attempt to look into it, we will tak...
Thanks, @Justin_Barrett; you’ve assisted a lot. If I can’t get this to work, we’ll have to try something else.
The problem is that I’m not able to programmatically add a record to any of the 2 tables when they have a linked field. If I remove the ‘li...
It is still throwing the same error; the ‘id doesn’t correspond’ when it tries to create the new record. It’s a new record (existing ones filtered out before trying to add new ones); it doesn’t already have a linked record id.
I tried implementing the logic and I’m getting another error. It seems there is also a unique linked record id besides the unique ids for the records in each of the tables.
At this point, I’m a bit confused, and I think what I’m trying to do might ju...
