Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Open URL to Anydesk doesnt work

Hi everyone, I have a base that keeps Anydesk ID's of our staff, and I want to open Anydesk automatically from Airtable, using the saved Anydesk ID. There is a URL Handler from Anydesk, the problem is, that the link doesnt open in Airtable.Thats the ...

Resolved! Rollup/ Formula to deduct # tickets claimed from tickets available

Hello Airtable Community,I have 2 tables: Attendance and Performances. People will fill out my ticket request form, submitting their preferred number of tickets for Performance Dates 1,2,3 etc.  This gets recorded in the Attendance table under their ...

Resolved! IF Formula assistance

Question on the following formula.  I have tried just about anything and everything to get this formula field to only calculate the score based on after the date.  The formula works perfectly fine without using any date fields. Form type (single choi...

Link to another record across multiple tables

Hello community! We use airtable as an ATS (applicant tracking system) and now would like to extend it to project management.I have 2 different tables: candidates and jobs. I now want to create a new task table (classical kanban project management) w...

Primary Field as a joint array

is there a way of adding a joint array, concatenate to my primary field (containing Email and Full Name), but still be able to link to that table using email only. in other words, my contacts have different emails, and currently primary field is thei...

Resolved! How to Format Dates in a Rollup field with multiple dates

Hi everyone,I've been searching airtable forums for hours yet I can't find a solution that clearly explains what I need to do to achieve my desired results. There are different answers talking about using MIN() or something other formula, but I can't...

Scribbles_ by 4 - Data Explorer
  • 2 replies
  • 1 kudos

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! IF contains nested formula help

We have a system for reviewing new tools where they are checked for meeting accessibility standards and security standards. These are two separate teams with different workflows. The integration team needs to know when a tool review is considered com...

Extract info from a Long Text field

Hi, I have a long text field with the info bellow and would like to extract the infos in bold to different field but cant find a formula to help me with. Thanks in advance for any help guys.This is the text I have in the long text field (its in portu...

tsallis by 5 - Automation Enthusiast
  • 1 replies
  • 0 kudos

Resolved! Add a Formula Field to See the Newest Item Added to a Rollup Field

My table has a Rollup field (let's call it 'Titles Field').I used the ARRAYJOIN(values, ', '), so the titles are separated by commas.However, I want to add a Formula Field that show only the Newest/Latest title added to the rollup field.Please advise...

Giora_Giora by 5 - Automation Enthusiast
  • 2 replies
  • 2 kudos

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

Resolved! Extract 0-1000 number from a url after a pattern

From the below URL, I am attempting to extract the number that comes after the pattern "page%5Bnumber%5D=" this case, the...

Brian_Moran by 5 - Automation Enthusiast
  • 2 replies
  • 0 kudos

Resolved! Formula that shows "Yes" if date is in the previous year

Hello everyone, I have currently the following formula in my table that shows "Yes" if the date in "Fin contrat" is in a future month. I am trying, but with no success, to adapt this formula to show "Yes" in another column if the same date is in the ...

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

Resolved! IF AND for Status Change

Hello, I'm trying to create a Formula that will change Status according to the fields "Start Date" & "End Date". If Today > End Date = "Delayed"If Today < End Date = "In Progress"If Today < Start Date = "Planning"I have written the following formula ...

lucas__mar by 4 - Data Explorer
  • 5 replies
  • 2 kudos

Setting Timezone without Time in Date Field

Hello!I'm having issues with Airtable's default GMT timezone. I have a Date field (which I do not want to have time displayed for) as well as a formula field using the DATEADD formula to calculate the next time a task is due, based on frequency. In t...

Screenshot 2023-02-20 at 2.10.04 PM.png Screenshot 2023-02-20 at 2.07.35 PM.png