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

Forum Posts

Trying to organize sales data

Hi everyone!I'm trying to organize my sales data in my Airtable base.I add the data through CSV upload. For every day of sales I add I add a new column to my sales data table.Now I want to run automatic calculations on the data. To give an example: i...

UrbnJ by 5 - Automation Enthusiast
  • 248 Views
  • 1 replies
  • 1 kudos

Google Drive Folders Synced to Record

I have a table that is creating a record for each client that completes a form. I have another table on the same base which is a synced google drive table with all client folders. Is there a formula/automation I can use to link the "open in google dr...

tahsinh by 4 - Data Explorer
  • 770 Views
  • 8 replies
  • 1 kudos

Resolved! Insert a space before a capital letter

Hi I have a file name / string of texte.g. 'ThisIsTheFileName'I would like to insert a space before each capital letter. Is there a formula to do this?Thanks 

JM1234 by 6 - Interface Innovator
Solved
  • 371 Views
  • 2 replies
  • 1 kudos

Help/Any Solutions?

Hello All,I need to migrate all of my records from an old base in to a new base.  The records in the old base have been assigned a number (through Auto ID plus a formula).  We are leaving the old base behind, importing all of the records in to the ne...

Rita_Spanu by 5 - Automation Enthusiast
  • 637 Views
  • 0 replies
  • 0 kudos

when copy formula values "HTML code"

I've HTML Code to use inside formula to insert virables inside the HTML code then export it as final HTML Code.. the problem is when i tried to copy the field it add some extra character (")...Here's the formula code:"<div style='position: fixed; top...

Karek_Rami by 5 - Automation Enthusiast
  • 697 Views
  • 1 replies
  • 0 kudos

Date / Time Import... Some Working, Some Not; Same Format

I have data that I am importing from a CSV. Sometimes it will import into my date field without issues, and other times it will simply be blank. In the screenshots I have attached, the left column is an Airtable date field (screenshot of settings att...

dannyh by 4 - Data Explorer
  • 1320 Views
  • 2 replies
  • 1 kudos

Turning <p> and </p> into line breaks in a field

Hello, all. I am importing a CSV file into Airtable. Some of the CSV data ends up as Long Text fields in Airtable, and consists of blocks of text with multiple paragraphs. It comes in with <p> and </p> indicating these paragraphs.In Airtable, the <p>...