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

Forum Posts

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
  • 447 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
  • 509 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
  • 933 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...

Updating Airtable IF something new exists in Podio

Hi everyone, Thank you in advance for any suggestions you may have I'm working on creating an always up-to-date Airtable that consists of records being updated in Podio. So within Podio, I have an app with a sheet consisting of people; my colleagues...

Dhiresh by 6 - Interface Innovator
  • 1233 Views
  • 2 replies
  • 0 kudos

Calculate GPA

Inside this URL, I need to create a formula if PHYS is 100 or above and ASTR is 200 and above then divide the column of quality points by the column of credits. I also need to not include P, NE and add 4 credits if there is an F. Any ideas?

areising_0-1676560232045.png
areising by 4 - Data Explorer
  • 419 Views
  • 0 replies
  • 0 kudos

Importing Signup Genius Custom Question Field

Hello all, I have linked a SignUp Genius signup to populate a student table in my Airtable database automatically.  I have 3 custom questions, and Signup Genius exports those ALL in one custom questions field separated by commas.  I need to separate ...

MaxG by 4 - Data Explorer
  • 391 Views
  • 0 replies
  • 0 kudos

What datetime format is this?

I'm attempting to prep a table for import and need to recreate a concatenated formula field that includes a date field formatted like this:Can anyone identify this format for me?  Thanks!

Screen Shot 2023-01-19 at 7.50.14 PM.png