Help

Welcome to the Airtable Community!

51506members
121995posts
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Activity

Formula to create yearly calendar of dates

Hello,I'm really new to Airtable and completely inexperienced with formula options.I'm looking to set up a formula so I can easily create a list of dates for the calendar year. Right now I used # option but I think a formula is more in line with what...

Estelle_0-1679583596558.png
  • 0 Views
  • 0 replies
  • 0 kudos

When criteria is not met, leave field blank (help)

Hello everyone! I have this formula:  IF(AND(DATETIME_FORMAT({Trækdato (FarPay)}, "D")<10, DATETIME_FORMAT({Dato for udløb}, "D")<10), IF(WEEKDAY(DATETIME_PARSE(DATETIME_FORMAT({Dato for udløb}, "YYYY-MM-10"),"YYYY-MM-DD"))=3, DATEADD(DATETIME_PARSE...

  • 5 Views
  • 0 replies
  • 0 kudos

linking 3 tables

I've got 3 tables - 1) Athlete, 2) Athlete Races and 3) Athlete Weekly Training Score. 1 is linked to 2 and 3, but 2 and 3 aren't linked. 3 is updated every week, with a new entry (score) per athlete each week.For any relevant entries in 2) (i.e. whe...

  • 4 Views
  • 0 replies
  • 0 kudos
andyh by 5 - Automation Enthusiast

UPGRADING FROM FREE TO PRO ACCOUNT - HELP

I designed a base and had someone I hired on Upwork make a base on my free account. Now I want to start my paid PRO ACCOUNT - However the dialog box says " Your paid account will start in 7 days"  I need it to start now because I need to add more ext...

  • 6 Views
  • 0 replies
  • 0 kudos

Airwalker beta (free) is now live!

Hey all, I'd like to share the beta release of my product Airwalker.Airwalker was created out of my desire for better tooling when creating Airtable API integrations. 離 FeaturesBase timeline - a timeline of your base schema changes Logging - history ...

Screenshot 2023-03-22 at 15.10.35.png goksan_1-1679571583471.png goksan_2-1679572336492.gif Untitled.gif
  • 40 Views
  • 0 replies
  • 0 kudos

Passwordless Login

I've been using passwordless login through the Wized v2 beta, and today the magic links stopped getting emailed. The requests are successful (New users still created in Airtable, status code 200 etc), but no email. Is this a known issue at the moment...

  • 9 Views
  • 0 replies
  • 0 kudos

"Data" vs "Interface"

HelloAssessing airtable for some internal operations work that has some custom process flows, part of which sometimes require filling data to move to the next step in the flow.We're looking at both the "data" option and the "interface" option.The "Da...

  • 24 Views
  • 2 replies
  • 0 kudos

Character counting with conditions

I am using the LEN(string) function but I want it to exclude commas, is there a way to do that? I have a list of items with commas in between, I would like a character count of the letters but not the commas.

  • 17 Views
  • 2 replies
  • 0 kudos
IIAL by 5 - Automation Enthusiast

Calculate birthdate with given years and months

Hello!I'm hoping you guys can help. I'm a total newb with formulas.I'm trying to build a animal shelter manager and usually we don't have the exact date of birth. Just an approximate age (ie, 2 years, 5 months, 4 days, etc.). Is there a formula that ...

  • 14 Views
  • 1 replies
  • 0 kudos

How to create a button to call and mail?

I am trying to create a button to make calls and mail using URL "mailto:xyz@abc.com" but I am not able to use that. Can you suggest me something?  The email address and phone number are stored in different columns.

  • 27 Views
  • 0 replies
  • 0 kudos

Help With Rollup (SUM) linking Formula (datetime_diff)

Looking for some help. I have a table were I utilize "last modified time" to be inputed based on the Specific field ("Checkbox").This sequence works well for what I am doing, which is; creating time logs for when we "Start" and "Stop" work on a speci...

  • 28 Views
  • 0 replies
  • 0 kudos

Automation help for updates from forms

I am working on a base that will help automate onboarding and offboarding of agents and staff, along with their encrypted computers. Information for onboarding is collected via the ALC onboarding form.I have an automation set up to create a record in...

  • 22 Views
  • 0 replies
  • 0 kudos

Disable a form for a specified schedule or date range

This feature would be useful for businesses and organizations that need to temporarily disable form submissions for maintenance, during periods of high traffic or when responses can not be accepted due to a specific workfloy/company necessity.Here's ...

  • 14 Views
  • 0 replies
  • 0 kudos

Enabling or disabling of column visibility

One potential Airtable product idea could be the addition of a feature that allows for the enabling or disabling of column visibility for individual users or groups of users. This would be especially useful for teams or organizations that work with s...

  • 15 Views
  • 0 replies
  • 0 kudos

Lookup a field from a rollup formula

What is the proposed idea/solution?In the rollup field settings, we will be able to pull another field as value, rather the rolled up field.How does is solve the user problems?Let's say you have Tasks and Projects tables which are linked. I want to s...

  • 178 Views
  • 0 replies
  • 1 kudos

Creating a table by importing excel with single select options

I'd like to create a new table by importing from an excel worksheet. There will be 30+ fields and i want the single select options to be True and False.When i've tried to add the single select options manually as answers and then convert the field to...

  • 17 Views
  • 1 replies
  • 0 kudos

Announcements

Question of the Week!

Hope everyone is having a great week! It was fun reading through best practices from last week's question. Special shout out to @Tobias_LGKR for sharing an innovative idea around a "change log functio...

Announcements

Heart-Centered Apps Episode two Video Release!

HEART-CENTERED APPS! Using Airtable and #nocode to build solutions to change the world! TODAY FEATURING:SPEAKER ONE:Ezekiel Dallas, Founder, https://queerspeeddating.pory.app/, Queer Speed DatingSPEAK...

Announcements

Question of the Week!

Today marks Airtable's second Question of the Week  Special shout out to @Ben_Young1 for kicking us off last week with his insightful response. This week's question is What's your best tip on how to ...

Announcements

Community Change Maker: Justin Barrett

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

Announcements