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

Forum Posts

Resolved! Airtable button triggering webhook Twice

Hey guys, I have a button in my Airtable that triggers a Zap in Zapier. I'm using this code: { "https://hooks.zapier.com/hooks/catch/14888220/30r6035/?recordID=" & RECORD_ID() }, but it's triggering the Zap twice. I'm also using multiple buttons, and...

spishu21 by 4 - Data Explorer
Solved
  • 106 Views
  • 3 replies
  • 2 kudos

Lookups, Rollups, and Formulas producing comma after unique values

Hello,I'm pulling in purchase order data for my company, and have a "Vendor Management Team Partner" associated with each purchase order record.I'm also reconfiguring these POs in a separate table, such that the email address of the PO requester is t...

mtardiff_0-1709913200332.png
mtardiff by 5 - Automation Enthusiast
  • 180 Views
  • 5 replies
  • 2 kudos

Resolved! Extract email from User Field

Is there a way to extract a users email address from their account info?Context...I have a form built in "interfaces" and have toggled on "see who submitted response".Ideally I'm trying to extract the domains for the users as a method to sort with di...

chrisberry by 6 - Interface Innovator
Solved
  • 111 Views
  • 2 replies
  • 1 kudos

Dates "sheet"? Update records based on one date

I want to create a "sheet" timetable that creates new dates using a formula based on one date that is inputted. I know there's probably a better way to say that so please disregard my ignorance. Here's what I want to happen...I input the "Class Start...

malloryjax by 4 - Data Explorer
  • 122 Views
  • 2 replies
  • 0 kudos

Limit data submission by user

I would like to limit the number of rows created in a table. I am planning to have a limited data entry period with 100 users where each user can only put in 10 rows of data. How would I achieve this with Airtable?

lmac by 5 - Automation Enthusiast
  • 286 Views
  • 4 replies
  • 1 kudos

Resolved! Add Dates Automatically based on Word

If there are options in a drop down menu (example Quiz or Test), start dates are entered by user, can I add a new column with a formula that detects the word 'quiz' or 'test' in the previous column and add an end date automatically based on the word?...

JaclynB by 5 - Automation Enthusiast
Solved
  • 2301 Views
  • 7 replies
  • 2 kudos

Separating multiple data entries in field

Hey,I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

Screenshot 2024-02-26 164505.png

Resolved! Counting task completion

Hi all!I've been scratching my head and couldn't solve the problem quickly, so I'm asking for your help.I need to display a progress bar with the percentage of completion of a specific task, under which there are subtasks. In order to understand the ...

flavich by 4 - Data Explorer
Solved
  • 167 Views
  • 1 replies
  • 0 kudos

Does ANY value from Field A match ANY value from Field B?

Hi, everyone! It's my first post, and I'm relatively new to Airtable and to databases more broadly. Hoping for some help.I'm using a base to organize staff for a conference. Volunteers are attending some sessions and working other sessions. I have a ...

xtj by 4 - Data Explorer
  • 200 Views
  • 1 replies
  • 0 kudos

Resolved! How to collect data from a workweek??

Hi!I'm new to the Airtable community, I'm still finding my way around. I hope all is well!Sooooo, Im wanting to create a smoother process for sending out invoices to my sub-contractors for a work week (Mon- Sun). I have come across a bump!Let's prete...

Screenshot 2024-02-10 at 12.18.12 AM.png Screenshot 2024-02-10 at 12.19.25 AM.png
star_EF by 4 - Data Explorer
Solved
  • 455 Views
  • 3 replies
  • 0 kudos

How to set up percentage conversion view in the dashboard?

Hello Airtable community! Our team has recently transitioned our CRM system to Airtable and configured a dashboard for straightforward reporting to our leadership.In our setup, we have a "Status" column that includes several choices. I've arranged a ...

vlad_evst by 4 - Data Explorer
  • 396 Views
  • 3 replies
  • 0 kudos

Resolved! Formula to display most recent input based on multiple field

Hi there - I am looking to create a column that will essentially lookup the field values of columns Q1 - Q4 and output the latest number.We input quarterly projections and want to be able to identify the most recent number by looking at 1 field ("lat...

ta2530 by 5 - Automation Enthusiast
Solved
  • 258 Views
  • 2 replies
  • 0 kudos