Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Forum Posts

How to calculate the difference between 2 numbers

Hello,Everyday I have a script that scrape IG accounts. I want to add "Followers Gain" which is the current number minus the previous number of followers on this account. I've played with automation without success due to the fact that there are diff...

CleanShot 2024-07-08 at 23.29.20@2x.png
pier_bdt by 5 - Automation Enthusiast
  • 510 Views
  • 2 replies
  • 0 kudos

Autofill a "link to" field

Hi all, apologies if this question has been asked and answered already. [EDIT: attached a screenshot since the embedding images don't seem to work.]I am creating a table of contacts for relationship management. For each person, I have the fields "Int...

Screenshot 2024-06-25 at 5.26.23 PM.png
MajorTom by 4 - Data Explorer
  • 450 Views
  • 1 replies
  • 0 kudos

Automation to notify status changes based on previous status

I want to know when an approved campaign goes back in to revisions so that I can review it again. I have multiple other reasons to want to know when a campaign status changes and what the previous status was; e.g., trigger subtasks for team members, ...

How to show most recent entry in group of numbers

Ok, I have been trying to do this for a while on my own with no luck.I have a list of serial numbers. These serial numbers have more than one entry. I group the view by serial number so I can see all entries for any particular serial number. What I w...

Rich_Nuzzi_0-1674682858384.png
Rich_Nuzzi by 5 - Automation Enthusiast
  • 1696 Views
  • 4 replies
  • 1 kudos

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
Sarah1 by 5 - Automation Enthusiast
  • 1119 Views
  • 5 replies
  • 2 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?

tahsinh by 4 - Data Explorer
  • 598 Views
  • 2 replies
  • 0 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
  • 762 Views
  • 3 replies
  • 2 kudos

Help with formula

Hello Everyone,I am wondering if there is a formula to replace these characters "&lt;"  and "&gt;" that take the place of the "<"  and ">" when I import a CSV from Webflow into Airtable. Mailchimp is not able to read it as is. Thanks very much! 

rmm by 5 - Automation Enthusiast
  • 406 Views
  • 1 replies
  • 0 kudos