I have four Airtable fields {Total Cost}, {Event Date & Time}, {Equipment Charge}, {Event Duration}, and {Number Of Techs}If the {Event Date & Time} happens during the Day time, the rate is $69.If {Event Date & Time} happens during the Evening the ra...
I am a new user and would like some help figuring out how to write this Airtable Js script. I am trying to change the status of a record base on two conditions in the Maintenance Tracking Table:
Date: Older date or Time stampStatus: Upcoming Service ...
kuovonne:
Are you trying to update a record that is not the triggering record? Are you trying to update multiple records?
That is correct, I am trying to find the previously created record for that specific location which I was able to do with...
Hello kuovonne
I just know a little bit about JS that why reason I am trying to customize the Find “Duplicates Script” to accomplish this task. What I would like to happen is that each time a tech does a service check at a location, a new record is c...
Below is the script that I started. Any help will be appreciated.
//script to conditionally update single select field in Airtable base
//script to conditionally update single select field to Past seervice Check
//when a new record is created for the...
