Hello, I have one formula field {Ball 1 ?} in the table A . The formula checks another table {Ball 1} via a linked record to see if it contains an attachment. If it does, the computed field writes "Yes", if it is empty, it writes "No". This part work...
Hello, On an airtable registration form that has a required field for DOB, some users have made error on their years of birth (for example 2023 instead of 2003) . Then they submit it and it fills the table with wrong data without them being aware of ...
Hello,
I have formatted the date but the hour displayed shows 1 hour less.
How can I display the exact time in hours and minutes in the field {date formatted} ?
The formula I use is :
DATETIME_FORMAT({Time slots},‘DD-MM-YYYY à HH:mm’)
How can we so...
Hi!
I created a field that concatenates the last name and full name in a table.
I am trying to write a function that takes the 2 letters first letter of the first name and 2 last letters of the last name.
But it only returns the 2 first letters of th...
Hi!
I would like to write a script that automatically creates time slots one week in advance.
These time slots are every Tuesday and Wednesday from 9am to 2pm (6 time slots/day).
For now, I type them manually but there is certainly a better way… Let ...
Thanks @Sho, I can't believe I missed that lol.In the meantime, I went on to use nested IF's , like so :IF(
{Ball 1},
"Yes",
IF({Balloon 1},
"Yes",
"No"
)
)I'm glad I can now use the OR() you have corrected, as it was my fir...
Hi @Tom_David , Are you saying that there is a duplicate record in your field and that you want to find it ?If your table is not too big, a quick method is to sort your data from the specific field. This will arrange your records in order.Then group ...
Hi @siliceous ,Awesome, since it is not possible I will go with the formula + trigger method you have shared then, as I have another formula field that calculates ages based on DOB. That way it can trigger an email automation if the age is lower than...
Previous post deleted and corrected :You're right, it's an error on my part. Thanks for the precision @Miguel1. If I understand you correctly you want each service to have the 3 tier prices so they can be filtered based on their price ranges.To do ac...
Hello @Melanie_Lemnios ,The formula you may use for your employee counter {Employee Count} is : IF(AND({Start Date} < {Given Day}, {End Date} >= {Given Day}), 1, 0) It puts 1 if the employee is present and 0 if he was absent that day, based on the st...
