The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have a scripting block that, for each record R in a given table, pulls a bunch of data from a different table, calculates a number N, and updates a field F for that R.
The problem is some records are updated and others are not.
I know that records ...
Is there a sample code snippet to pass table records into a function? Do I also need to pass the table or field itself (because I need the field to get cell value, or the table to get the field, right?)
Hi - I have a table with a list of cash flows, dates. These are linked to another table which contains individual deals. I want to calculate, for each deal, the IRR - in Excel this is using the IRR function which takes a list of dates and a list of...
Fixed it.
The issue was somehow due to the async nature of updates. Needed to add an ‘await’ before the update. No point trying to debug why only old records updated and new ones didn’t…although it really really confused me.
await dtable.updateReco...
I second this - some of the information I was looking for was there but took too much scrolling to find.
There should be a short intro laying out the principles (API only for loading updating data, use Javascript for everything else including filters...
I might have hit the bug also - had some small discrepancies a few decimal points in on most of the sums. I assumed it was due to conversion between Airtable float and Javascript float or something like that.
The solutions to the root are usually in...