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

Welcome to the Airtable Community!

49452members
118176posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Using QR codes to streamline concert check-in process

Hello there! I work with an organization that produces a 50-concert summer festival. We have about 120 Season Pass Holders, about half of whom show up to any given concert. We would like to check them in at each concert and track their overall attend...

  • 11 Views
  • 0 replies
  • 0 kudos

Database for Web App

Hi all, it's my first time using no-code tools and I am trying to add airtable as a database tool to collect sign-up information as well as customer queries and any other related data. Where do I start? 

  • 22 Views
  • 2 replies
  • 0 kudos

Updating existing base

Hello,  I am new to airtable and handling our base.  The person who built our base left out a column of data that is critical.  I need to know how I can import data from an excel file that adds the data needed instead of making all new entries. Thank...

  • 24 Views
  • 4 replies
  • 0 kudos

How to center image in email automation

I need to center the logo image of my client in the body of an email. How do I do that?  (Don't worry - I'm not using an image in an attachment field. )This is what I currently have, but the image is not actually centered. Can anyone help?<div style=...

  • 11 Views
  • 0 replies
  • 0 kudos

Resolved! Prevent line breaks when empty lines

Hi everybody!I'm trying to modify the formula below so that the empty lines don't show up and don't make a line break with empty lines.For each of the 18 lines I have {FormatX EANX Concatenated} from an other field where {FormatX EANX Concatenated} c...

  • 50 Views
  • 3 replies
  • 0 kudos

How to add a filter script to running total script

Hello, I'd like to add a filter to my running total script. I have a checkbox field and would like the script to only calculate the running total if the checkbox is checked. Any help appreciated.   let table = base.getTable('Resource Capacity Plannin...

  • 26 Views
  • 3 replies
  • 0 kudos

Calculating Funding Year

Hi everyone, I am trying to create a formula that will output what funding year a record falls within. I have a field with the dateStart of the funding and another with the dateEnd of the funding. I also have a program start date which is a static fi...

NeptuneDev_0-1675182138206.png
  • 40 Views
  • 3 replies
  • 0 kudos

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...

  • 15 Views
  • 0 replies
  • 0 kudos

Today() Formula

I want to use formula TODAY() BUT I Don't want that it will automatically change with each passing day. I need that the original date that was created, will stay the same. Is there another formula that can do it? 

  • 44 Views
  • 5 replies
  • 0 kudos

How to avoid having to edit URLs when I copy a base.

Hi,We have three main tables.  Client table records have one or many Interaction Table records, which have one or many Outcome records.To make the process smooth for collaborators and to reduce errors, I have a button on the Client record which launc...

Margaret_Picker_0-1675072496010.png
  • 38 Views
  • 1 replies
  • 0 kudos

How to add price ranges?

Sorry if I'm not expressing well what I intend to do.Let's say I want to list several virtual pc's services but most of them offer their services per hour and price ranges changes between pc tiers. Let's say basic £2 per hour, medium £3 per hour and ...

  • 77 Views
  • 3 replies
  • 1 kudos

Cannot add password due to Gmail Login

Hi all,I'm having trouble to add a password to my Airtable account. I've ever used login throught Gmail but now I need to add a Password. I click to the field "Add a Password" in my Account page but I never receive the email to set it up. I've tried ...

  • 20 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
  • 31 Views
  • 3 replies
  • 0 kudos

Make filter element wider on page

On interface designer, is there a way to make the filter element wider? It is pretty truncated left<->right and cuts off the filter conditions. Ideally I would be able to stretch this out left<->right and then stack the filters top to bottom.

  • 26 Views
  • 0 replies
  • 0 kudos
corb by 6 - Interface Innovator

I need help on a date conversion formula

Hello, I need help on an airtable formula. I have a date conversion formula: but I would like if the table is empty it says "Enter your birthday date" To avoid the error message please my formula : DATETIME_FORMAT(Dateofbirth, 'DD MMMM YYYY')thank yo...

  • 54 Views
  • 4 replies
  • 0 kudos

Resolved! clearing fields with scripting

Hi all,This seems pretty basic but I can't get it to work after a day of researching and patching together example code I've found. I have no Javascript experience.I simply want to run a script that entirely clears the contents of a column. Here's wh...

  • 42 Views
  • 4 replies
  • 0 kudos

Announcements

🤷🏼 New Community, who dis?

Hello Airtable Community !!Chris Dancy here, proud Airtable user, no-code fan, and organizer for the yearly "DareTable -Unofficial user conference." I've always strived to use Airtable to connect pe...

Announcements

Share your favorite Airtable learnings & unlocks!

The best part of this Community is the endless exchange of innovative ideas and helpful solutions between our 50,000 members. To celebrate the launch of the new platform, we’d love for you to share yo...

Announcements

Community Change Maker: Souleimane Konate

The Airtable Community Change Maker Spotlights are a new ongoing series where we will be highlighting inspirational creators across the Airtable Community. We are thrilled to be able to highlight Soul...

Announcements