Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Multiple amounts for Multi Select Field

So Im pretty new to Airtable and not sure if I am going about this the right way and wonder if someone can point me in the right direction if not. Basically I am trying to use a multi select option to calculate the Extra costs involved in a job with ...

Edit history of a field or formula

Is there a way to see/track who has made edits to a formula or field? This feature is very helpful for viewing individual records, but it'd be even better if I could view who is changing formulas.

e2laurel by 5 - Automation Enthusiast
  • 630 Views
  • 2 replies
  • 0 kudos

Resolved! Calculating Participation Rates

I want to store the total number of employees in the programs table to calculate the participation rate. Additionally, I'd like to break down the number of employees by position to calculate the participation rate for each position. I have three tabl...

Wendy_Yelsik by 6 - Interface Innovator
Solved
  • 2083 Views
  • 8 replies
  • 0 kudos

Resolved! Using Mapped Values in a Formula Field

I have a “Campaign Name” table that contains a “Product” field (which uses abbreviations).The “Campaign Name” table has a formula field which uses the “Product” values (along with other fields) to generate a campaign name.Our request form (on the “Ca...

dhigbee by 5 - Automation Enthusiast
Solved
  • 617 Views
  • 2 replies
  • 1 kudos

Resolved! Quota in form

Hi, I created a form where people can choose if they want 1 or 2 tickets. I have 40 tickets only available. I have no idea how to setup the form and the table so the form close when the 40 are reached.... Any ideas ?  Thank you !

JeremiBen by 5 - Automation Enthusiast
Solved
  • 1275 Views
  • 3 replies
  • 2 kudos

Resolved! Issues with formula - Attempting an on hold client button

Trying to create a condition via formula which will mean that a client won't be able to be quoted via airtable extension with the following:Formula:IF(Type="Client", IF({On Hold}="On Hold">"Good", " Good to Quote","On Hold - Do not Quote"))We are hop...

ahenry by 4 - Data Explorer
Solved
  • 1193 Views
  • 4 replies
  • 0 kudos

Hyperlinks

HelloIs there a way to include hyperlinks in a base? I am importing data from Excel, where I collected the profile of n individuals and for each profile I have general information (name, education, job title etc) and a link to their LinkedIn page. Wh...

federica by 4 - Data Explorer
  • 1716 Views
  • 2 replies
  • 1 kudos

Trying to organize sales data

Hi everyone!I'm trying to organize my sales data in my Airtable base.I add the data through CSV upload. For every day of sales I add I add a new column to my sales data table.Now I want to run automatic calculations on the data. To give an example: i...

UrbnJ by 5 - Automation Enthusiast
  • 580 Views
  • 1 replies
  • 1 kudos

Shiftplan with formula and counter

Hi there, im new to airtable and need some help. I would like to create a form in which people can register for a work shift. There are four shifts with a maximum number of participants. For example:Shift A = Max. 5 participantsShift B = Max. 2 parti...