Hi,I am trying to create an automation where:If "Adviser 1 ranking" column has been updated as "Outstanding", then the "Adviser 1 rating" column will automatically have 5 stars appearing. Same goes to any update on "Adviser 2 Ranking" will update the...
Hi, I am trying to add on more function to the existing auto set date script I found on Airtable extension (please see below). I am hoping to incorporate into the code below that if there is a task that has been marked it should start 20 days before ...
Hi, My script below functions to auto generate meeting time slot dates for my team. However, the time generated does not reflect the time zone I hoped for, i.e., Australia/Perth, UTC+8. In my data view, my "Time Slot" column is a "Date" set up as bel...
Hi, I am trying to automate the process of creating available timeslot (15mins duration) for clients to book in appointments via an online form on Airtable. Could someone help out with a script that I can use to automate creating timeslot records for...
Hi, I am trying to design two bases on Airtable for my team:Base 1: Instruction ManualInformation: This base should consists of all tasks our team need to do throughout the year, which instruction and attachment.Base 2: To-do tasksInformation: The ta...
Omg it worked! Thank you so much!1 final question, if I were to allow the formula to be a bit more flexible (i.e., if only 2 advisers had time to rank it, could it take the average of 2 instead of 3)?
Hi Sho, Thank you for the information. Yes, we would need the "Rating" field as we have another formula column that will auto average the three adviser's rating into one final rating. Or could you please kindly suggest any set up that will be more ef...
Hi @kuovonne Yes it is long! I would like the script to run on button press. Currently trying to set up as a base where we have got template task linked to a template project. The coding that I am trying to customise is for the "Task" table where ea...
//PART 3: Main Program//This array will store any record with multiple antecedents after the initial pass over.let completeMulti = [];//Get the launch date for the project.let userDateStr = await input.textAsync("Enter project launch date (mm/dd/yyyy...
