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

Forum Posts

Compare Rollup to function

Hello.I am trying to find records where a rollup results is less than or equal to a function. Both are formatted as numbers, and both work when I search for records in each column independently. Is there a solution for this?

Resolved! Attachment Field

I need to evaluate whether or not an attachment field is blank with an IF statement. Variations of double quotes and the BLANK() function don't do the trick. Any ideas?

Darryl_Oliver by 6 - Interface Innovator
Solved
  • 428 Views
  • 2 replies
  • 1 kudos

Number of changes

HiIs it possible to count the number of changes or modifications that have been made to a specific record?Rgds

Mgomezv by 5 - Automation Enthusiast
  • 191 Views
  • 2 replies
  • 0 kudos

Resolved! using f-string with filterByFormula

Hi,i am using python-requests and trying to use f-string with filterByFormula here is a simple implementation:hard coding the name worked:   url=f"https://api.airtable.com/v0/{base_id}/{table_name}/" headers={'Authorization': f'Bearer {api_key}', ...

wesam by 4 - Data Explorer
Solved
  • 260 Views
  • 1 replies
  • 0 kudos

Resolved! 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...

AcDemas by 5 - Automation Enthusiast
Solved
  • 284 Views
  • 2 replies
  • 2 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...

Nawaf by 4 - Data Explorer
  • 193 Views
  • 1 replies
  • 0 kudos

Resolved! Insert a space before a capital letter

Hi I have a file name / string of texte.g. 'ThisIsTheFileName'I would like to insert a space before each capital letter. Is there a formula to do this?Thanks 

JM1234 by 6 - Interface Innovator
Solved
  • 403 Views
  • 2 replies
  • 1 kudos

Formula If client is married, primary field will show spouses name.

I have the primary field set as a formula right now as CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be ...

tahsinh by 4 - Data Explorer
  • 504 Views
  • 1 replies
  • 0 kudos

Need help regarding advanced formula usage

Hello there,I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. I have tried using nested IF statements; but I am running into so...

elija6266 by 4 - Data Explorer
  • 367 Views
  • 2 replies
  • 0 kudos

Resolved! Complicated lookup field's Type causes formula to fail

I have two tables Experiments and Readings.Each experiment is linked to two or more reading records. Each reading has a DateTime field, and some readings such as pH and temperature. The pH and temperature readings are number fields.I want to use the ...

jethroc by 5 - Automation Enthusiast
Solved
  • 827 Views
  • 6 replies
  • 2 kudos