I am struggling to get a Formula that would return my age, where the number after the decimal point indicates the number of months in duodecimal format. For example, my current age is 34 years and 3 months, therefore I want to see 34.03 as the return...
The funny part is that when I change the data type in field in question from a formula to a plain decimal number - it all works! Does Airtable not support this kind of calculation when the primary field is a formula deriving data from another formul...
Hello, dear Airtable community.
I want to generate a unique payment ID, based on the sum, date, cashier, and the type of transaction.
Everything has been good by far, until I decided that I want to try using emojis. So, I assumed it should be a mix o...
Thanks, that worked! The & operator is indeed more friendly.
My current forfmula looks as follows:
{date field} & IF({Type} = “Cash”,“ :money_with_wings: ”,IF({Type} = “Card”,“ :credit_card: ”)) &{Cashier} & {amount}
I know, that is a whole differ...
Thanks for your reply and the IF statement!
I’m using a CONCATENATE function.
A separate IF function works well to produce a separate field translating words to emojis, as shown on the screenshot. But is there a way I can include the IF statement to ...
I’m very new to airtable, but this is almost the first feature I wanted to use once I started setting up my CRM-style base… genuinely surprised it’s missing and eagerly anticipating the update!
