Formulas | Airtable Community

Resolved! Insert a space before a capital letter

Hi I have a file name / string of texte.g. 'ThisIsTheFileName'I would like to insert a space before each capital letter. Is there a formula to do this?Thanks

Formula If client is married, primary field will show spouses name.

I have the primary field set as a formula right now as CONCATENATE({Client Last Name},', ', {Client First Name}). I want the formula to include the spouses name after the client's name if the marital status (separate field) is married. What would be ...

Need help regarding advanced formula usage

Hello there,I am trying to create a formula that calculates the total cost of items based on their quantity and unit price; while also factoring in a discount percentage if applicable. I have tried using nested IF statements; but I am running into so...

Resolved! Complicated lookup field's Type causes formula to fail

I have two tables Experiments and Readings.Each experiment is linked to two or more reading records. Each reading has a DateTime field, and some readings such as pH and temperature. The pH and temperature readings are number fields.I want to use the ...

Resolved! Number separators formula

Looking for some help regarding a formula. Here's a little context of what I am trying to do. I am working on importing my teams marketing budget plans into Airtable, and so far everything is working well. As a final step, and in order to avoid have ...

Help with Forms and Formula's

Can anyone recommend an Airtable Consultant, preferably in the UK, who can help me with some fairly simple formulas which for some reason, I cant work out why, are not working and/or producing missing data in some rows. I feel very scrooge-like and m...

Resolved! Post comment/question to customer request(submitted via form) directed by client for prompt action

Hello,After the customer submits a request form to the client for order fulfilment, if the client has a follow-up question for the customer - Is there a feasibility/workaround to submit a comment/question on the request so that it can be re-directed ...

Resolved! SUM multiple calculations in one field.

Here's what I want to do. I have a field that lists percentages for the fees my company wants to add to a contract. Admin fee 10%, Late fee 5%, etc. If I were to stack these fees, I want to have a field that returns the sum of each percentage multipl...

Pull data from one table to another AND populate the record field

I have a Table that lists everyone who has taken our leadership courses (Participant table). Fields include Participant Name and FLL Attended.I have a second table listing everyone who is a salaried leader in our company (600 records). I want to have...

Ingredient stock rollup

Hello,We are a vitamin supplement company and we buy ingredients from all over the world. We have 178 different ingredients which are used to create 17 products. Sometime the same ingredients will be used for five different products.We want to creat...