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

Forum Posts

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 6 - Interface Innovator
  • 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

Resolved! Number range in IF formulas

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

Airradiator by 4 - Data Explorer
  • 1 replies
  • 1 kudos

How to view/sort by frequency?

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

Convert currency with decimals into minor units number

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

Ellis by 4 - Data Explorer
  • 2 replies
  • 2 kudos

Resolved! Prefill Linked field with multiple records not working

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

Philalethes_0-1676515022938.png Philalethes_1-1676515057308.png Philalethes_3-1676515314046.png Philalethes_4-1676515326150.png
Philalethes by 5 - Automation Enthusiast
  • 5 replies
  • 2 kudos

Resolved! product ingredient analysis

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

martincilio by 4 - Data Explorer
  • 6 replies
  • 1 kudos

Resolved! Working hours

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

Screenshot 2023-02-06 at 11.46.57.png
Nahkan by 4 - Data Explorer
  • 1 replies
  • 1 kudos