Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Markdown code showing in email body for some recipients

Hi all,I'm sending out emails via Airtable and some (but not all) recipients are noticing a very weird problem. The URL code shows the markdown text instead of the URL link, ie., it shows [TEXT](url) instead of TEXT.I thought it might just be a probl...

Resolved! Formula or automation to add one image to an attachment field

HelloWondering if someone can help me with something I am struggling with - but thought would be easy!I have an attachment field in one of my tables, and most records have upwards of 10 images.  I'd like to set up a sync'd base which only shows the f...

Resolved! Adding formula fields for recurring dates, including SET_TIMEZONE

Hi, I'm sure the answer to this is really simple and I'm just missing it, but could someone please take a look at this formula and let me know why some records would be throwing an ERROR, but others are working? I'm thinking I've got something in the...

Meagan_Caesar by 6 - Interface Innovator
  • 6 replies
  • 0 kudos

Automate tick box and Your result type is not a number or a date.

Hello,So currently, we do have a tick box on this view and manually tick it once it is the latest valuation.Do you have any ideas on how can I automate this? without doing the manual ticking?Another issue, I created this formula : IF({latestVal Date}...

Screenshot 2023-06-01 at 12.45.00 PM.png Screenshot 2023-06-01 at 12.47.30 PM.png Screenshot 2023-06-01 at 12.49.51 PM.png
Imee_Lee by 5 - Automation Enthusiast
  • 5 replies
  • 1 kudos

Multi-Variable Formula for Calculating Attribution of a Sale

Hello Airtable friends.I have a somewhat simple formulaic excel sheet that becomes very complicated when breaking it up to be used in Airtable.The goal:Based on the type of sale, each of 6 static 'sale stages' should have defaul percentage (out of 10...

Jack_Skinner by 5 - Automation Enthusiast
  • 5 replies
  • 3 kudos

Making a single selection from within a multiselect field range

Hi, I have a field of clothing sizes which varies for each garment record. Ideally I'd like to be able to set up a single select field with options that vary depending clothing sizes held in the multiselect or linked field for that particular record....

jedstrom by 5 - Automation Enthusiast
  • 4 replies
  • 2 kudos

Unique filter

I have read a few discussions on Unique filter - lookup then roll up. But i really can't seem to figure it out. I have my calendar synced - then I have a column of attendees, which is linked to companies. So each row has the different company in the ...

Selimafifi by 4 - Data Explorer
  • 2 replies
  • 0 kudos

Resume Parsing

Hi All,Is there any option if I upload a resume in My Airtable base and with the help of any extension,  parse the basic information like Name/Email ID/Contact No./Current Company in respective field.I agree that I am expecting too much from Airtable...

compare URLs

HITrying to compare URLs in a Search records module in MAKE.Want to find the 1 record where the URL in the table equals a URL passed from a previous module in MAKE.Can't get it to work.... the formula in AT directly does work, but within MAKE, it sim...

arruga by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Help splitting multiple select field into individual records

Hi! I am working on maintaining student learning records. I have two multiple select fields: one with "Student" names and one with demonstrated "Competency". I would love to create new rows for each combination of Student and Competency, and copy ove...

tdstarkey by 4 - Data Explorer
  • 3 replies
  • 0 kudos

Resolved! Create a formula for a view that only shows specific dates

Hello! I need some help from this community because I lack the knowledge to develop formulas.  I really appreciate your help.I'm trying to create a view for a database where I only see records where the answer for "Dates Available" is exactly between...

Joy_Reed by 5 - Automation Enthusiast
  • 2 replies
  • 1 kudos

Automating reoccurring tasks on specific days of the week

Hello Airtable Community. I created a Base to track my to-do list using several formulas and automation to reoccur each "done" task based on the set frequency of the task. For example: if the task frequency from the drop-down list is "weekly", then I...

Resolved! Leave Blank instead of #ERROR

Hello,  I'm current working with this formula: WORKDAY({Start Date},{SLA Test})   ---which is the formula in the 'due date' column.I would like for the Due Date to be left blank instead of #Error if there is no start date or SLA.Can someone help with...

JaclynB by 5 - Automation Enthusiast
  • 4 replies
  • 1 kudos

Circular Reference Error in Primary Field

I'm sharing a solution to a problem I had; hopefully this will help others. Note: you will need to be on a plan that includes Automations.When you try to reference information from a linked field in a primary field, Airtable will warn you of a circul...

Rollup concatenate formula help

I have a rollup formula that returns a bullet pointed listed, which works beautifully (supplied by this incredible community - thanks!). I need to concatenate that with additional information though and am at a total loss.  This is my current output....

Screen Shot 2023-05-01 at 9.56.33 AM.png

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
  • 6 replies
  • 2 kudos

Resolved! Time to Formula Help

I've got an events calendar and an automation set up so that event registrants will get an email 6 hours prior to an event, using a formula field and the TONOW formula:TONOW({Start})The automation sends an email when the formula field reads "6 hours"...