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

Forum Posts

Guidance for my formulas using Airtable as an ATS

Hello,I am very new to Airtable, and would love some advice or guidance bringing a few ideas to life. I am using Airtable for an applicant/candidate tracking system, interview scheduling, and job tracking for a recruitment firm.The current set-up is ...

Claire1 by 4 - Data Explorer
  • 529 Views
  • 1 replies
  • 0 kudos

Resolved! Field with DATEADD function not matching value in other Date field

I have a Date field (Date Asset Added) whose value is entered manually formatted like this:12/8/2023Another field (Date RM) contains this formula: DATEADD({Date Asset Added}, 0, 'day')  which outputs this: 12/8/2023.  12:00am I want to execute an aut...

CharlieMullin by 6 - Interface Innovator
Solved
  • 1150 Views
  • 2 replies
  • 0 kudos

Multi likes help me

I'm using a no-code tool and I want to have a multi-like with Airtable.On the no-code side, we've set up GET, POST and PATCH to make the like work, but the problem is that it's not attached to a single user. In other words, let's say user A posts a l...

Sarahhh1 by 4 - Data Explorer
  • 290 Views
  • 0 replies
  • 0 kudos

creating a link to form with prefill from another table

Hi,I have two tables I work with:1. table of employees,2. Table of events3. table of enrollment to each event.I want people to enroll to events each time an event is created.I created an enrollment form in the enrollment table to insert the data ther...

NitaiLS by 6 - Interface Innovator
  • 310 Views
  • 1 replies
  • 0 kudos

Randomize meetings

Hi everyone! I'm trying to tackle an issue that I'm not sure I can solve with Airtable, but hoping to alongside Zapier integrations. I want to randomize monthly meetings across our staff, volunteers, and board. Not everyone is willing to use Slack, w...

Fill in date cells empty in month

Colleagues top up holidays and travel expenses in Airtable. We would like to account for the empty dates 13 three random days in a given month. Is there any way to automate this?

Remove date/time from field

I just started using Airtable and I'm trying to remove the date/time from a column or create a new column that has the date/time removed with just the remaining text. The column is linked to another airtable and it is using the primary field, so I do...

JJJ by 4 - Data Explorer
  • 387 Views
  • 1 replies
  • 0 kudos

duplicating a recored and its linked filed.

I’m trying to use automation to copy a record and create duplicates of all the linked records in the original record. Here’s what I’m trying to do:Create a new record and update it with all the fields.Search the other table for all the records that a...

Ingredient stock rollup

Hello,We are a vitamin supplement company and we buy ingredients from all over the world. We have 178 different ingredients which are used to create 17 products.  Sometime the same ingredients will be used for five different products.We want to creat...

MoniK by 4 - Data Explorer
  • 647 Views
  • 3 replies
  • 0 kudos