Hello! I am trying to create a PDF-generating script using Scripting extension. When I run a script, I get an error message, "Can't set cell values: Field 'XXXX' is computed and cannot be set." Any idea how I can fix it?
+31That error means the script is trying to write into a computed field (formula / lookup / rollup / autonumber, etc), which isn’t possible I’m afraid
To fix it, go through the list of fields you’re updating in the script and make sure they’re all ‘editable’ field types (single line text, number, date, etc)
+28Hey
For further reference on which field that reference is making to exactly, you will want to check the page below (replacing “YOUR_BASE_ID” with your actual base id). Then you can control search/find for the actual field id that the error is showng, and you’ll get exactly the name of the field you are having an issue with.
https://airtable.com/YOUR_BASE_ID/api/docs
FYI, your base id is that which reads like “apppGLr77rYe4yzXT” within your base url.
Completely different matter, but would love to have you join our Airtable Hackathon! Make sure to sign up!!
Mike, Consultant @ Automatic Nation
YouTube Channel
+28Also, if the issue persists just let me know and we can hop on a 5 min call and debug together.
Best,
Mike
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.