Hello! I want to add something to the formula below. I want to add the condition that IF the column 'Fixed exchange rate' is not empty (there is a number filled in) THAN that number should be used BEFORE using the Forecasted exchange rate. IF the Col...
The cell gives an error (NaN) when the linked table does not contain any linked records. I want to create a formula that will fill-in the cell as '1' if the 'average (values)' is not possible. Thank you.
Hi all, I’m trying to link my a “parent” record to new created records in a script following this source. But I keep on getting the error “TypeError: newRecordId.getCellValue is not a function”.
The code can be found under " /Link the new record (...
Hi all, I’m new to scripting in Airtable and I got a bit confused about my error.
I’m using two variables for the script
projectID which is the ID of the project that is linked to the test record
linkedIndicatorIDs which are the IDs of all the indic...
Thank you very much. This is already very useful.Now I want the empty cells to be filled with the number 1, because it is used for a calcalution of another cell. Could that be added to the formula? Thank you!
Wow, thanks a lot Alexey! I got to learn a lot from your reply, and it made the script work indeed as I wanted. Gotta love the Airtable community :slightly_smiling_face: . Issue solved! Thanks again!
Thanks for the help! I made it work like this now
/*Script is written by Pello Mugica Gonzalez. Email: mugicagonzalez.pello@gmail.com*/
let inputConfig = input.config();
let table = base.getTable('Progress General Indicator ');
let query = await t...
Further optimized the script but the error is now "TypeError: parent[0].getCellValue is not a function or its return value is not iterable
** at main on line 57"**
/*Script is written by Pello Mugica Gonzalez. Email: mugicagonzalez.pello@gmail.com...
