Help
Other questions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Sequential numbering - not autonumber

I've seen variations of this question, but can't seem to find the best solution for my use case. (FYI - I'm on the Free version) I need to create sequential numbers based on a linked record. Example: Our "Jobs" table has all our jobs and their corres...

EMSR by 4 - Data Explorer
  • 647 Views
  • 2 replies
  • 0 kudos

Airtable Changing Form Links + breaking prefills?

Did I miss the announcement where Airtable said that they were changing the format for share links for Forms?The change briefly broke access to my form and now my prefill formulas are no longer working. Is anyone else seeing this change / am I late t...

Christopher_Sc2_0-1690477896560.png

Update table 1 when a matching record shows up in table 2

I have two tables; my primary table is a listing of our inventory units that we are running promotions for; when an inventory item sells, we add it's stock number to table 2. I'm looking for a way to set the status of each record in table 1 so that i...

Log In help

Hi all,I am getting very frustrated. for some reason, when I tried to log in to discussion forms it automatically sent me to a sign up page. I couldn't get it back so i figured I would fill it out and see where it went. Suddenly I have a new account ...

ninjaben53 by 4 - Data Explorer
  • 466 Views
  • 1 replies
  • 0 kudos

Resolved! long URL isn't active from mail

Hi,I want to send forms to end users, using a link sent via mail.the link contains data that should be uploaded to the form with info relevant to specific users.I created the URL to the form successfully, but when I send the mail, the user receives i...

NitaiLS by 6 - Interface Innovator
Solved
  • 512 Views
  • 2 replies
  • 1 kudos

Multiple schedules of calculations per user

I'm trying to set-up some complex financial calculations, including amortisation schedules per new user record, based on data entered by the user as well as set annual figures from another table. I am struggling with the best way to set this up. Ther...

Conditional Formula (IF & AND)

I'm trying to set up a formula and could use some help. The first part is simple and is working: IF(Actuals <= {Approved/Expected Amount}," On Track"," Over Budget") However I would like it to provide a different result ("Profit") if the Type of reco...

Resolved! How to automatically generate a checklist

I am using a customized version of the Employee onboarding Template base. The template seems to be set up to duplicate the base for every new hire that is being onboarded. I would like to use one base that generates a checklist for the employer onboa...

brianna_eagen by 5 - Automation Enthusiast
Solved
  • 1885 Views
  • 7 replies
  • 2 kudos

Resolved! How to require a 10 digit phone number on an Airtable form?

Form question for you all. I need to capture phone number on an Airtable form however I can't figure out how to require it be entered as a 10 digit number so that area code is captured. The Phone number field type does not require the response to be ...

Data_Team by 5 - Automation Enthusiast
Solved
  • 571 Views
  • 2 replies
  • 2 kudos

Resolved! "Unsharing" past events

HiI am scheduling a festvial, and I need to create a way to "unshare" past events, so the beginning of the week doesn’t pop up on the last day.Is this possible?All the best, Uffe from KlaDa

KlaDa by 5 - Automation Enthusiast
Solved
  • 415 Views
  • 2 replies
  • 0 kudos

Resolved! Using IF/Concatenate for dimensions

I'm trying to represent dimensions using concatenate and IF statements but it's not working.This is what I'm going forIf HEIGHT and WIDTH then H x W in.If HEIGHT and WIDTH and LENGTH then H x W x L in.If DIAMETER then D dia.I managed to get the first...

Dgmknzgrl_0-1683130368821.png
Dgmknzgrl by 5 - Automation Enthusiast
Solved
  • 490 Views
  • 3 replies
  • 0 kudos

Resolved! Scripting: Creating backlog of records: Attendance tracker

We are moving student metrics to Airtable and I am trying to create a backlog of attendance records for our students since they started. (we have two campus's with seperate start dates). I have an automation working fine for populating records with e...

Resolved! Open url button opens a new tab

The open url button field you can create always opens a new tab, and i don't want it to do that, is there any way i can modify the formula so it doesn't open a new tab? I can make a script field instead that stops this but i really don't want to spen...