Formulas | Airtable Community

Zip Files as separate files

Is there a script/formula I can use to extract zip files as separate files and have them saved in another field?

23 Views
0 replies
0 kudos

Formula to identify diacritics

Hello,I am working on a base that includes artists' names and a lot of them have diacritics in their first and last name. Is there a formula that I can use that could identify if there are diacritics used? It can be a simple True or False formula tha...

30 Views
0 replies
0 kudos

Combining Two Formulas To Test New Functionality While Not Breaking The Old

We have an intake form to generate URLs with UTMs parameters. I have created a new form with additional functionality. During testing, I need both the old and new forms to work.My current Formula field concatenates the URL (Root Link) with the UTM pa...

99 Views
7 replies
0 kudos

Autonumbering Formula Problem

Hello everyone,Me and my team are working on a database for my business, to be frank we're new to Airtable, and there's something we can't quite figure out. There's this one table that is for recapping all of our clients' consultation sessions. After...

47 Views
2 replies
0 kudos

Single Select Outputs for Formula fields

bonjour la communauté, la nouvelle mise à jour des champs de formule permet des sorties à sélection unique pour les champs de formule. J'ai un champs ou est concaténé plusieurs informations incluant une sélection unique. J'ai testé cette nouvelle fon...

74 Views
4 replies
0 kudos

Create a Time Tracker using a formula to count how many times a record appears. Please help!!

I am setting up a new system for our company to track our projects and record how many days each designer has worked on a project and, equally, how many days a project has been worked on. The calendar view doesn't work for us, as date ranges don't wo...

95 Views
2 replies
0 kudos

Resolved! Using nested IF test with AND tests stacked for multiple criteria in one column

Hello!I am trying to create a formula that categorises ships by type, then size category, and if they meet both of those criteria they are assigned a value that is annual fuel consumption appropriate for the vessel's size category. If not, the IF tes...

55 Views
2 replies
0 kudos

Resolved! Formula field set to currency with 2 decimal places but getting up to 14 in token

I'm experiencing something weird - I have a formula field ("Cheque 2 amount") set up to subtract different currency fields. All fields, including Cheque 2 amount are set to currency format with 2 decimal places. Everything looks normal in Airtable:H...

93 Views
3 replies
0 kudos

#ERROR when dividing a linked record that is currency + setting up reference table

Hi Folks,I am essentially trying to automate quota calculations for the sales team in Airtable. As I explore setting up the tables, I'm running into constant brainfogs.1. Im dividing the "record" (quarterly target) by "3" (to break this into a monthl...

119 Views
5 replies
0 kudos

Recreate If statement from excel

Hello everyoneI'm NawafI have a long nested if statement that i used to use in excel but I can't figure out how to use it in airtable the idea is i have 3 columns first ( permit status ) second is ( remark ) when the conditions meet, I want the third...

72 Views
1 replies
0 kudos