Help
Formulas
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Formula help

Small charity here thank you for reading!  I am trying to make a sign up sheet for volunteers to sign up to wrap Christmas presents for children - that bits sorted.  But I need to sort parking for them. On the main base theres a linked column that pu...

Copy and Paste multiple records from a table to just one cell

Hey there! I have a "Customers" table and a "Projects" table and what I'm trying to achieve is to link them. I wan't to know which customer were in each one of my projects, so a costumer may be in more than one project aswell a project will have more...

Resolved! Automatically adding URL to Attachment Field

Hi everyone,I was wondering if we would be able to automatically add an URL as an "URL-Attachment". This way I would be able to fetch a QR Code image and have it in my table.I could not find anything online. Unfortunately I can't install extensions t...

Eren1_0-1699016886174.png
Eren1 by 5 - Automation Enthusiast
Solved
  • 598 Views
  • 3 replies
  • 2 kudos

Resolved! Field to summarise records with shared column value?

To group records for planning purposes, I use a unique code for each record, then a custom text field to assign one of those codes to records that need to be grouped. This is for planning vegetable plantings with multiple vegetables in a plot. Here's...

oreocereus_0-1698786402729.png
oreocereus by 7 - App Architect
Solved
  • 486 Views
  • 3 replies
  • 2 kudos

calculation on pivot table

SpoilerI'm trying to calculate return rate (items received/ items delivered),  but aggregate them by day.  However, there are multiple receiving lines for each event, and only one input for items delivered.  I'd normally do a formula based off a pivo...

Resolved! Trouble with IF

What is wrong with this IF statement?  IF({Sonrise Home} = "CH", "Sonrise Children's Home"), IF({Sonrise Home} = "MIR", "Mirembe Cottage for Girls"))"Sorry, there was a problem saving this field. Invalid formula. Please check your formula text."  

Extract numbers from field into a new field

My field has a name followed by a number - SAM ADAMS (1234).   I need to put the 1234 in it's own field.   What is the best way to write a formula to do that?   

How to get the index of the link to another table

Let's say I have a table of Invoices and then a table of payments. Each invoice is an aggregate of payments i.e. one invoice can have multiple payments. How can I get the index of each payment in the list of the invoice?

Resolved! Clickable URL

Hi everyone, I searched through the community posts but could not find anything.Using a formula I created custom URL for every person in our company that will allow prefills in a form.CONCATENATE('https://airtable.com/appxxxx','?prefill_Your Name=',N...

Eren1 by 5 - Automation Enthusiast
Solved
  • 1727 Views
  • 7 replies
  • 3 kudos

Nested IF plus.... What else do I need? 😳

Hi All! I am still new to Airtable and writing formulas and (hopefully) this is an easy question.I am trying to write a formula that will display text that matches the "checked" state of 3 different checkboxes, and also will display "New" if none of ...

Spruce_0-1696519610393.png
Spruce by 6 - Interface Innovator
  • 592 Views
  • 3 replies
  • 0 kudos

Resolved! Conditional Coloring for the Record "pills" in a lookup field

Working on costuming for a film - have 4 main tables of Actors, Costumes, Scenes, and Characters.There's a lot of table to table referencing going on w/ lookups...But one thing I would LOVE to be able to do:When looking at the COSTUMES table (charact...

Can these colors be conditional.png
seanpeter2 by 5 - Automation Enthusiast
Solved
  • 495 Views
  • 3 replies
  • 1 kudos

How to view only part of a lookup field in a form?

I have a form that a member uses to search for their name using a lookup from another base. Because of PII Standards, I can't have their full name listed for others to also see. This basically works as a task tracker so (external) users have to enter...

Splitting Expenses as inventory is distrubted

I am looking for a way to split expenses amongst people in our company without duplicating the total. We purchase company merch/promo items and that expense goes under our expense table and is assigned to 1 of our 7 offices, or corporate. We assign a...

Resolved! IF + DATETIME_DIFF Formula Help! 🙏🏼

I have a lot to learn in terms of building formulas, and I'm found myself stuck and not sure what I'm missing.What I'm trying to accomplish:If the Completed column checkbox is ticked, display "Completed"If the checkbox is not ticked, display the time...

Spruce by 6 - Interface Innovator
Solved
  • 551 Views
  • 4 replies
  • 1 kudos

The best way to "unshare" an interface?

Hi! Does anyone know how to restrict access to a shared interface? I gave a read-only user access to an "editable" interface I made for my creators so that she couldn't utilize it. For her to submit information, I made a read-only version with a form...

Resolved! Combining different data fields into one column

Hi there,I want to have a column which displays two bits of data. Those are a cumulative $ amount and below that a cumulative % amount. I have these two lookup fields separately however need to combine them into one field column. Any help would be gr...

bartdubs by 4 - Data Explorer
Solved
  • 1032 Views
  • 9 replies
  • 2 kudos

IF Statement Formula with three statements and conditions

I have this IF Statement Formula:   IF(  {UNH Facilities}= "UNH Facilities - GH Cleared",    "",     IF({UNH Facilities}= "UNH Facilities - Supplying Items",      "") ) but I want to add one more piece that returns both an orange and purple circle ...

PaulComms by 4 - Data Explorer
  • 373 Views
  • 2 replies
  • 0 kudos

Calculating Differences Between Records in Increments of 1, 5 and 10

Hi All - I'm struggling with creating calculations on the base shown below. What I'm trying to do is calculate the % change in total enrollment growth by 1YR, 5YR and 10YR between Fall Years for each university (it would be a changing calculation wit...

HTDuck_0-1692985358148.png
HTDuck by 5 - Automation Enthusiast
  • 973 Views
  • 7 replies
  • 3 kudos