Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Forum Posts

Hyperlinks

HelloIs there a way to include hyperlinks in a base? I am importing data from Excel, where I collected the profile of n individuals and for each profile I have general information (name, education, job title etc) and a link to their LinkedIn page. Wh...

federica by 1 - Visitor
  • 24 Views
  • 1 replies
  • 0 kudos

Resolved! Issues with inaccuracies in my math

Howdy yall, I am trying to do a simple math setup for a client. calls per hour, demos per hour, calls per demo... The issue I am running into is the math seems to be coming back wrong. I have tried a few different ways and still having issues. Here y...

Screen Shot 2023-01-25 at 12.42.42 PM.png

Student Interactive Leaderboard

Hi all, I am looking to create an interactive leaderboard, where my students fill out a form which relays the results back into a board. I have a rough idea of how to do this, but was wondering if anyone has attempted this before or any leaderboard t...

CX2023 by 4 - Data Explorer
  • 25 Views
  • 0 replies
  • 0 kudos

Resolved! Handling "Infinity" errors and IF statement formatting

Hi,  I have an issue when using the formula fields in AirTable when using an IF statement.Context: I need the fields to be format as a percentage, or blank if there's an error/infinity.Here is the formula that I want to use in its simplified form, an...

Screen Shot 2023-01-31 at 12.48.43 PM.png Screen Shot 2023-01-31 at 12.50.33 PM.png Screen Shot 2023-01-31 at 12.53.09 PM.png Screen Shot 2023-01-31 at 12.54.50 PM.png
Dennis_Yu by 6 - Interface Innovator
Solved
  • 42 Views
  • 3 replies
  • 1 kudos

Formula to calculate debits and credits for personal finance

Hey guys, I've got a new challenge in my quest to create a base for tracking personal finances.  A quick review:TablesCategories (I call them buckets)TransactionsDesignationsTransactions are either entered manually or bulk imported via csv from my ba...

Screen Shot 2023-01-24 at 8.07.18 PM.png

Verify Facebook/Google Pixel Placement on Webpages

I have to regularly place Facebook/Google pixels on webpages and was wondering if there's a way to track via a formula, button, or script whether the pixel on that webpage is working or not. I have a field in the table for the URL the pixel would be ...

Rollup Fields with Dates & Average

Hi all,I am trying to extract the mean/average of a set of dates through roll-ups. I am able to calculate the min or max date through the use of MIN(values) or MAX(values), but AVERAGE(values) returns NaN.Any suggestions? (thanks in advance!) 

Raphael1 by 4 - Data Explorer
  • 105 Views
  • 1 replies
  • 0 kudos