I think when updating a linked record field via a script, you have to specify a list of the records you'd like to link to, with each one's record id specified. Try reformatting your code like this: const outputTable = base.getTable('Work Weeks');
fo...
Hey Jason! It looks like I didn't have notifications turned on for replies on here. Sure I can totally share some sample code: let newStatusToPost = 'Hello World!'
let response = await fetch('https://mastodon.social/api/v1/statuses', {
method: '...
I don't think this is possible without an automation or extension of some kind. It does look like the Record List extension would be a good fit for what you're looking for, though!
I have an idea that doesn't require an automation. In the registrations table, you'll need to add 2 fields: A lookup field that points to the customer's start dateA formula field that computes if the order date/registration date is on or after the Cu...
I don't think it is possible to automatically keep them sorted, but it is possible to use the Batch Update extension to sort the linked records. I believe the linked records are what control the order of the rollup data.