I'm intending to create a simple AirTable script to record duration of a single status field. In my use case I'm tracking a large number of issues where the status frequently goes back and forth between the multiple status',For example there are mult...
I'm attempting to read the current status of a single select field, what I'd like my script to do is read the status of the button and simply return that status as a string. For example, if I manually set the button to "Doing" and run the script, my ...
Okay update on this, my duration formula seems to be working so the next step is to add up the duration of each record in the log that meets the given criteria. For example, I want to know how many days total my record had the status of 'open', in th...
Okay making more progress, this is what I have so far, I'm sure there's a way to clean this up, but right now it will check the current logs and update the last recorded bug log for that specific issue recording the end time for that status and then ...
Got it, since I'm dealing with multiple records, in this case a number of bug tickets, I'll need to filter the query first to make sure that I'm only looking at the log files for a single bug ticket. Looks like I found a filter right here that might ...
Update: Getting it working. Thanks to Alexey I was able to understand working with Input Variables. Here is my current code and it seems to be working to point as I'll explain:// OBJECTIVE: If STATUS field is updated, record the last modified time an...
Thanks for your help Alexey. I think this is a good first step but not what I'm looking for. When I ran this, I got the following:Input Variables: Name: Current StatusValue: Current StatusDisplay: Nameconst {status_name} = input.config()
console.log(...
