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

Formulas Activity

Replacing \n with carriage returns

Hi all, I am importing JSON into Airtable and parsing it into fields using REG_EXTRACT.Some of the JSON data are blocks of text that have "\n" (without the quotes) in place of carriage returns. Airtable treats the \n as text rather than carriage retu...

  • 52 Views
  • 1 replies
  • 0 kudos

Find duplicates in a rollup

Hi there - I schedule shipments to be picked up on specific dates from specific sites at specific times, and I need a way to identify if I've scheduled any shipments to be picked up on the same date/site/time to make sure I'm not double booking a sit...

  • 162 Views
  • 5 replies
  • 0 kudos

Formula for date that cell was updated

Hi, is there a formula to pull the date that a specific cell was updated?For context; I use Airtable to confirm bookings for my business, and do weekly reports on these. The reporting is currently based on 'created date' as I only add them to the sys...

  • 287 Views
  • 10 replies
  • 0 kudos

Resolved! Query data from another table

I have two tables:Table one shows a list of tasks done on different computers and when the task has been marked as finished:TaskId, FinishDateTime, Computername.In table two I have information who was logged in when on on which computer:DateTimeStart...

  • 156 Views
  • 3 replies
  • 0 kudos

REGEX Combining multiple columns as comma separated

Hi community,I have a formula to combine emails from multiple columns, that generally contain multiple linked records (but not always).  This REGEX formula works really well for the first 3 columns, but is failing on the final.  Any help on what I'm ...

  • 108 Views
  • 2 replies
  • 0 kudos
KFIL by 5 - Automation Enthusiast

Resolved! Find and replace specific line and turn into UPPERcase

We have a load of addresses in a database. They are individually pasted into a Long Text field.The issue:Some addresses are in this format - 51A Wigton RoadCarlisleCA2 7AYAnd some addresses are in this format- 51A Wigton RoadCARLISLECA2 7AY So the di...

  • 115 Views
  • 2 replies
  • 0 kudos
DM115 by 5 - Automation Enthusiast
Solved

Forecasting Help

Hi Everyone,I am trying to create a forecasting table that will tell me how many months of cover I have based on current stock on hand. In the image you can see the fields Sock Holdings and Outbounds Forecast. What I need is to create a field where I...

lachlanmclean_0-1731018463597.png
  • 154 Views
  • 3 replies
  • 0 kudos

Resolved! Airtable App not working with prefilled forms

Hello!I'm using a prefilled form URL field. When a customer submits a button it opens the prefilled form in the corresponding URL field.The problem is that it works perfectly on desktop, but when using App, the prefilled form formula does not work.Is...

  • 133 Views
  • 1 replies
  • 0 kudos

Resolved! DATETIME_DIFF gives wrong number of months

I am trying to calculate the number of months between today's date and the "Test Date" field. When I use the DATETIME_DIFF formula it does not calculate it correctly for all values.  In the Test copy column I have this formula:DATETIME_DIFF({Test Dat...

Screenshot 2024-11-07 at 9.05.34 AM.png
  • 208 Views
  • 3 replies
  • 0 kudos