I was setting a "Happy Christmas" automation. I could have set the automation time trigger to "YEAR-12-31", but using the last working day as a trigger is better. Firstly I searched on the community for this kind of formula. I could not find. So, I w...
Hi,
I love these kind of icons used in table names and fields.
How can I find icons like these, especially with this style? Is there a page for icons which Airtable supports?
Hello,
In my base, the records are records of different meetings. These meetings are recurring.
When I set the Google calendar automation, Airtable sends an email for each meeting. I do not want to send too many emails.
For example there are 10 meeti...
Thank you for your comment. We do not send emails for each holiday or special day for now, but if we would, your method is the best. Some rows in your table can be formulized. For example, if 29th of October is a national special day, YEAR(TODAY()) ...
Yes, standardizing words with a formula column ( UPPER() or LOWER() ) makes your life easy. Then you can set an automation which gets the standardized value of a new record and pastes it into the linked record field.So, a user types YeLLOw in column1...
Hello, you can create a column with type "Linked Record to Table 2" in Table 1. Let's call it "newColumn". Then you can set an automation which pastes the value of Portes Fabriques to newColumn. By this way you build the link with tables. Since the s...
Thanks for your attention. Of course one of the today() functions should be replaced by the date field. Again thanks for explaining the difference between today and now functions. I did not know it.