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

Forum Posts

Orders & Subscriptions Question

Context:I have three tables. Customers, subscriptions, and orders. A customer can have multiple subscriptions, and a subscription can have multiple orders. Every time a customer fills out the order form, it is created in the order table. So a 1-month...

Awais by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Milestone Date

I am using the Gantt view. I have 50 tasks. Every 10 tasks has a milestone.  And each set of tasks is marked as dependencies for each milestone they come under. I would like the milestone dates to be updated automatically when the end dates for one o...

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

reagand by 5 - Automation Enthusiast
  • 4 replies
  • 3 kudos

Resolved! Count checkboxes of one column

Hey there,I'm new to Airtable and want to count all the checked boxes in one column. Anyone know how to do this? Please help! Thanks in advance.Dorus

Next Period/Month or Quarter

Not sure where the correct place to put this one is. I am trying to get a formula or automation to update the period field in the attached screenshot based on the cadence. I have tried using automations, but it essentially circular references itself ...

Unique Value in booking system - booking #

I import data into a table, and one of the fields is a booking number, which is unique.How can I make this field unique, that the import doesn't import the same ID including all the other data several times? Thank you,

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

Flag records created or update by the API?

Hi fellow Airtable enthusiasts!Does someone know if there's a way to flag records created or update by the API? Currently, we have a few integrations using the API, that are authorised by a certain user in Airtable. I'd like to flag those using a for...

Elvin_Roest by 5 - Automation Enthusiast
  • 0 replies
  • 0 kudos

any solution for a rental app?

Is there at the moment any formula, function, working script or any else working solution to deal with a rental activity? (we need do track what is available or not, when it is available or not, who rented what etc. not only checking calendar view, b...

Using Airtable search formulas in APIs

Hi there,I'm trying to get an Airtable and integration working with a basic 'if this pulse changes on a board, find the record in Airtable and update'.I'm doing this with My first step is a watch trigger that passes items which h...

aclayton by 4 - Data Explorer
  • 3 replies
  • 0 kudos

Automatically modify dynamic URL field based on logged-in user

I created this post a couple of years ago and we're still hitting a wall trying to figure out the best way to accomplish this: Dynamic formula to change output based on username viewing the tableI have started thinking about using an external no-code...

jord8on by 6 - Interface Innovator
  • 2 replies
  • 1 kudos

Comparing amount of common linked records

Let me describe my issue with a mock-up.I have a database with two tables: People and Projects. People are linked to Projects (people can be on multiple projects and vice-versa). I want to have an information how many People in common each pair of pr...

Grasiu by 4 - Data Explorer
  • 2 replies
  • 0 kudos

Airtable forms

How do I know if I submitted a form through Airtable? I received a copy of my responses, but I don’t know if this means my firm was submitted or not since I didn’t get a confirmation. Thank you!

Noel by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Attachment Deduping

Hi Community,I am pulling information from multiple records in a sync'd base into one record in a new base. By doing this I getting multiple images associated with this record, which I love. However some images are associated with multiple records in...

Mmingram by 4 - Data Explorer
  • 0 replies
  • 0 kudos

Replace a word and output with original sentence value

I have a column {Sentence with Plain Value}, whenever a value that is listed in column {Plain Value} exists, I want it replaced with the value in column {Value with R Ball} and outputted with other initial values in the sentence. For example:I love t...

Screen Shot 2023-03-07 at 2.06.12 AM.png
junaid2ali by 5 - Automation Enthusiast
  • 4 replies
  • 0 kudos

Resolved! Version count

Hi All,Hope someone can help!In our base we have multiple Proposals (in one table) linked to each single Sales Opportunity (in another table).I would like the proposal's naming convention to be "{Sales Opportunity} - Proposal 1", with any further Pro...

jwag by 5 - Automation Enthusiast
  • 1 replies
  • 0 kudos

Inventory Processed until Disposition

Hi Community,New to Airtable and trying to put together an inventory tracking system.  I followed some video's on YouTube and created 4 separate tables.  Equipment (i.e. models), Received, Issued, and Disposition.  I have a form that will intake when...

EBRPD_KS by 4 - Data Explorer
  • 3 replies
  • 0 kudos