I have a base with about 40,000 records spread over 20 tables. Base has been around for over a year.
About 1-2 months ago I noticed that some of the table names reverted to names from months ago. Keep in mind this is not the default “Table 1” names b...
Imagine I have 2 tables: STORE and ITEMS
STORES are linked to the items table so that multiple items can show up in each store.
The ITEMS table has a column called “Last Updated”, which is a bunch of dates
I created a lookup field on the STORE tab th...
I have a multi-select field with 10 options
I have a single select with the same 10 options
I want to run a script to take the value in single select and update the multi-select with it.
For example, if the values in a record before running the scrip...
Hi everyone, I’m trying to write my first automation and could use your help with some basics.
I need to use an automated script to modify multiple fields of the record and then I also need to take values to manipulate. The script below throws me the...
I’m trying to send data to Zapier’s webhook but it doesn’t seem to go through every single time. I’m a coding newbie, is there some sort of naive mistake I’m making below?
let result = new XMLHttpRequest();
let webhookURL = "https://hooks.zapier.com/...
Thank you, you’ve written me my first script and I’ll be able to adapt to a few more cases!
Quick question before you go: My Viewers table has 20,000 entries so it takes a long time to run. Is there a way to speed this up, especially since the linked...
Apologies, it is my entire script, I edited my answer above. More clarification below
2 tables: Movies, Viewers.
Movies is linked to Viewers under the column “Viewers”
Viewers has a single select called “Status”
My “Status” column in the Viewers table is a single select and my linked record field is “Viewers”. I’m getting this error now
viewer.getCellValueAsString is not a function
Is it possible that I’m not pulling the linked record properly? I am tryin...