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...
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...
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...
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}...
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...
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....
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 ...
Hello.The situation is as follow, I have two multiple select formatted fields in Airtable, namely "Placement(Planned)" where I'd like to insert placements to place my content and "Placemen (Used) are the placements where I already used the content. P...
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...
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...
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...
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...
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...
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...
Hi I have a prefill for, formula in my base which ends with ?prefill_STWorkshopReference=PA007130&hide_STWorkshopReference=trueand it works fine when clicked in the base But when included in an automated airtable email the _ and _ are omitted and the...
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...
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....
I have tried a ton of suggestions but I am not figuring this out. And I thought it would be a simple auto-parsing formula.I have an interface that allows our team to enter a new task/call record into our task tracking base (see pic below)I have a fi...
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?...
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"...
