This has probably been answered before, but I'm not sure how formulas work or how to maniuplate them to fit my use case.My base has multiple tables, one of which is a Members table. This includes the person's name as the primary field and other info,...
I am using a Formula field as my Primary Field for a schedule table (each record is a time slot).Among my formula for naming each time slot, I would like to add a number (ie. 001, 002) which is generated based on the Date field.ie. Record X: March 5,...
In the theatre world our "fiscal years" are actually seasons that start in the fall and end in the spring. And specifically, there are two big "quarters" = a fall/spring season, and a summer season. More complex than just "quarter 1" plus "year." an...
How can i create a field that reads, for example, "Friday March 17, 2023" ?
Hi everyone,I need assistance with getting the proper year in an ISO week start date so that I can get a valid week start date. I have the following formula: DATETIME_PARSE(DATETIME_FORMAT({Date Field}, "W"), "W") Month and day outputs from this meth...
Hi,We create forms to capture registrations for workshops. The dates and times of these workshops are set as Singapore time, but our participants register from all around the world, so we need these dates and times in the form to show up in their loc...
Hi Airtable Community!I'm not sure what I'm doing wrong with this formula. We are changing our pay rates on April 1st and I want to program my payment field to reflect this change. My table has a date field called "Fecha !!!" and a lookup field for o...
Hello there,I have been using Airtable for a month and I absolutely love it.I am creating a basic HR system. I want to create a formula for the employees’ paid leaves.How do I automatically make it add up in Airtable, using the Hours off (8 hours/day...
I’m building the process using a tally form and airtable.1. User fills in a form that includes a question as follows - when do you want to start the challenge?2. The answer which is a date is feed into airtable (formatted as friendly date, time and t...
Can anyone see what I am doing wrong here.Two fields, one date (as text type) one time (as text type) - The formulae field SHOULD make these into a single date/time field - This is the formulae I have, but I get errors on any dates with two character...
