Hello! I'm trying to write a script that I can run to populate a field in one table with a value that lives in another table. There are key values in both tables that match. I have worked in SAS and a little in Python for data analysis, but I am new ...
Hello. I am trying to create an automation or a script that updates a cell in a given table based on a unique identifier that can be matched to a unique identifier in another table. In my mind, I'm basically wanting to do a left join, except that I w...
Update: So I could never get this automation to work, but I eventually figured out a script to do what I wanted it to do. Here's the script that eventually worked, apologies I didn't update the script headers yet. Links to posts that led me to the sc...
Found another (similar) script and a nice walk through, linked at the bottom of this post. Copy-pasting the script that worked for me directly below.//Substitute "Orders" for table name which contains values//on which you want to run the vlookuplet m...
Thanks for this, I get a "received invalid inputs" error when I try to enter list of airtable record ID instead of airtable record ID from current item. Changing the list of airtable record ID back to a single airtable record ID resolves that error, ...
Thanks, it sounds like our automations are the same, I don't see any differences in what you outlined versus what I outlined. Can you share what fields types your unique ID columns are? Mine are short text type, though the text itself is not that sho...
