Hello - I’m quite new to Airtable and trying to prototype out an invoicing application, but I’m running into an snag and could use some guidance. My base: Clients Table (name, id, project lead, etc)Items table - this is a granular list of the items f...
I have a field that includes a date and time. I want to create a new field that give a new date and time that is 24 hours later Please can anyone help?
I have a view with the condition group: When Primary Introducer Contains John Stamos or Secondary Introducer Contains John Stamos or Tertiary Introducer Contains John Stamos Then I have an IF statement determining whether John Stamos is the Primary, ...
I have tables named “Inventory” and “Customer”. What is the best way to create unique price list per inventory record for each customer? I want to have => inventory A is $10 for customer A and $5 for customer B etc
Hello! I am trying to troubleshoot a formula field. Currently I have this in the formula field: CONCATENATE({Part}," | “,{Objective},” ",{#}) to create the following: Looking at the first record, the result reads: Part 1: Competent Leader | Heart 1 ...
Hello, I’m new to Airtable. That’s why I’m asking for help with something I can’t solve. I have two tables. One is Class Attendance and one is Lesson List. The Class Attendance table includes student names, student ID rows and course dates columns. I...
Hi Everyone, I have been trying to accomplish an error check and I have syntax issue on the below formula. May I please know what is the issue with my formula? Thank you so much in advance. IF(AND({est_filing_date_range_start},{est_filing_date_range_...
Hi Airtable community! I’m looking for a formula which fetches collaborator IDs The reason is, I want to assign through another formulas a set of teams. So, if user 1 is true in the ID column, return text value “team 1” If that makes s3ense!
Hi! I’m trying to aggregate multilingual survey answers using a formula. I will eventually need this format of formula for more complex data, but I am stumped at the beginning part of getting at least three statements to all say ‘YES’ if there is a ...
Hi, I need help from your brain because mine is out for this problem ! Actually i have this formula : IF(IS_SAME({Date d’envoi}, TODAY(), ‘day’), ‘YES’) To this formule i want to add 2 things : if the date is after today add “AFTER” if the date is b...
