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

Forum Posts

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
  • 269 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
  • 184 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
  • 537 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
  • 586 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
  • 1103 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>...

Resolved! JS API ignore lookup fields

Hi,I'm working with the NPM package to get data from tables which have lookup fields and I'm wondering if there's a way to ignore these lookup fields in the initial API call either by using some parameter or `filterByFormula`. I've checked the API do...