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

Forum Posts

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
  • 1753 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
  • 647 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
  • 630 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