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...
Hourly pay is dependent on age as shown below. I have 2 fields setup in my table: 'Age' and 'Hourly Pay'.I've tried all combos of IF, nested IFs and <= symbols but can't get the formula for all 3 age/pay combos to display correctly. Your help is need...
Hi, sorry if this is in the wrong thread. New to airtable and would appreciate help on:- How to view/sort by frequency (i.e. Field A has single-lined text that varies for each record, i.e. GreenMarbles)- I'd like to view/sort it to look something lik...
Hi, struggling with a formula for converting a currency field into minor units.Example: Formula field adding two currency values (£50.45 & £40.20) gives value £90.65. I need a formula that returns this value as 9065 - but I cannot work it out.In Exce...
Hello. I have found several posts that deal with this issue but it doesn't seem to work for me. Problem: I have a form that I want prefilled, but for columns pulling in data from linked columns, it will only pull in the first data entry even if there...
Hi,I am new to Airtable, but hopefully it makes sense what I am trying to achieve. I am creating a product database that will include product name and it´s ingredients. I want to be able to tell if a product is vegan friendly, not vegan, or unknown b...
Hi everyone!I want to get Cell values with ID from multi select field by field id of a table using php.https://prnt.sc/HasxED_1cZTbI have a table named "Cand", and there is Irish_Affinity field in Cand table.I know the field ID of Irish_Affinity.So, ...
Hi there,I would like to calculate the extra hours I've worked each day by implementing a formula field. I've currently listed records with "Date", "Start" (date, time, timezone), "End" (date, time, timezone).How do I make sure the formula only lists...
Hi everyone, I am trying to simplify the record ID function output as I don't need a complex unique ID. 2 solutions:- Is it possible to limit the record ID function to 4 maximum digits ? - Is there any other function that will generate a unique ID co...
HelloI need help with creating a Laundry Booking systemLooking to create a calendar view with the ability to let people book a time slot to use one of the Washing or Drying machines in my Building.The booking info can then be displayed on another tab...
