This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
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...
Welcome to the Airtable community @DanzTruong!For this, I recommend you to contact the Airtable support team directly via this link .As they will have the necessary tools to troubleshoot what you encounter, so that you can set up this authentication ...
