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

Forum Posts

Button wont pass data on mobile

I'm using a public airtable view with a button that passes data to a web form. Works on desktop but not on mobile.looks like this: "https://myurl.com/bid?bid=" & ENCODE_URL_COMPONENT({Deal Name}) & "&new=" & ENCODE_URL_COMPONENT({Current Bid Value}) ...

bself7 by 4 - Data Explorer
  • 356 Views
  • 1 replies
  • 0 kudos

Custom Formula for Accurate Direction Calculation in Airtable

Hello Airtable Community,I'm working on a project that involves calculating the Qibla direction using Airtable. I have latitude and longitude data for various locations stored in my Airtable base. I need to create a custom formula that can accurately...

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
  • 1007 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
  • 495 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
  • 603 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
  • 668 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
  • 437 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
  • 901 Views
  • 2 replies
  • 1 kudos