We’re excited to see so many of you testing out the scripting block! We’re hoping lots of you will be open to sharing the scripts you write with the rest of the community, too. In that spirit, the platform team wanted to share a few best practices fo...
Setup
Create a table called “To watch”. Keep the default fields (Name, Notes and Attachments)Get an OMDB API key: http://www.omdbapi.com/apikey.aspx
Script
Add a scripting block with the following script:
// Get an API key from OMDB here: http://www...
Ah I see, thanks for the details. The reason you can’t insert “JOBS” into the filter for the second Find Records is that it’s coming from the output of the previous Find Records action, which outputs a list of records. So if the Find Records action o...
Hi Rebecca – do you mind sharing more details about when the find records dynamic input didn’t work? Specifically, in “find records in the X table where Y field = Z field” what are Y and Z?
Yeah you might be running into a rate limit. Though when that happens, your script should show an error message and stop running. If it finishes silently, there might be a different issue.
In both cases, I would guess that the most likely problem is ...
Nice work! Yeah the update to any field value always overwrites the previous value. What you can do is keep track of the original linked record ids and add to them. Something like this should work:
// Call out the tables we are will look in for match...
Note: if(destValue !== null && originalValue) should probably be if(destValue === null && originalValue) and you should add an await before table.updateRecordAsync.
