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

Formulas Activity

Formula If or Switch Help

Hey I am trying to set up a formula for the below problem. I am provided with a list of names in the 'home' column and certain entries I need to change to end up like the 'bot name'. I have tried switch/If functions and I just get errors.  

Sarah1_0-1718754695037.png
  • 37 Views
  • 1 replies
  • 0 kudos

How to sum values and sort by another field?

Hi all,I have a base table with the transaction history which lists each profile's contribution amount, date, and the fund invested. Each profile is allowed to invest in many funds and can also invest in the same fund multiple times. How do I create ...

Picture1.png Picture2.png
  • 52 Views
  • 1 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}', ...

  • 52 Views
  • 1 replies
  • 0 kudos

Getting the current ID from the form and removing it

I would like to create a script that checks if my employee has already taken an advance on the same day. If it has already been taken, the new record should be deleted. I do this in the form. How can I get the current record ID from the form and dele...

sample1.png sample2.png
  • 53 Views
  • 2 replies
  • 0 kudos

Resolved! Static Aging of Status

I am trying to create a formula to calculate the number of days a specific status is active. For example, how many days the ticket is "On Hold". The need is to calculate the number of days the ticket was actually active, in other words the difference...

  • 52 Views
  • 2 replies
  • 0 kudos

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?

  • 89 Views
  • 2 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...

  • 117 Views
  • 2 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...

RizaldyRivai_0-1718348172591.png
  • 106 Views
  • 2 replies
  • 0 kudos