Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Forum Posts

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
  • 843 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
  • 2168 Views
  • 3 replies
  • 2 kudos

Resolved! Is it possible to use a image saved in bases URL in page designer?

In my base I got some images saved which I want to use in page designer.I believe I used to be able to use the Image URL in the page designers Image element. It seems still to work for about 24 hours and then the URL becomes invalid (which believe ha...

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
  • 801 Views
  • 1 replies
  • 0 kudos