Purpose:
In a table where the field is a “LINKED to record” field.
Many times the value for the LINKED field is a value in another text or formula field.
A script that can take the value of a string field, and insert that value to the LINKED To field...
Attempting to test the sample Project design tasks block - get the following. Any ideas why?
The field is a string
Error: Can’t create records: invalid cell value for field ‘Design project’.
Cell value has invalid format: must be a string
at Mutat...
Yes this can be done - there is a design consideration since Google sheets functions as a form in your example and Airtable is a database.
For your Airtable question - we would need to determine what the output would look like, what you want to accom...
Thanks for the response. The script is the example from Fri’s webinar. All of the examples worked except for this one.
// pick tables from your base here
let projects = base.getTable('Design projects');
let tasks = base.getTable('Tasks');
// promp...
