Solved

To create a more efficient process in pricing materials I’m working through different ideas and it’s just becoming messy. I’m trying to figure out if a formula would provide the best option or possibly a drop-down based on conditions. Example : I’d post a picture of my base, but it’s not quite finished, which is why I’m reaching out. If I need to purchase paint and paint supplies to bid materials needed correctly I’m trying to find the best option to fill in QTY TO ORDER gallon of paint is $30.00. Coverage area is 200 SF paintbrush is $2.00 needs replaced after 100 SF All materialS, coverage/price breakdown, is listed in a materials table. In the Bidding table I’d like to: COVERAGE AREA MATERIAL QTY TO ORDER PRICE Manual input SF, LF, tile count, etc. Manual input based on linked field based on the details from the materials table, this info is auto calculated Calculated by formula EXAMPLE OF WHAT I’M TRYING TO ACCOMPLISH 400 SF PAINT 2 GALLONS $60.00 400 SF PAINTBRUSH

My PDB report includes a Multiple Select field and the report requires a LIST format instead of the defaulted line of selected items… Q> Is there a way to have the print changed to a LIST format?

How the heck do I report bugs now? I have a linked record field that is supposed to be limited to a specific view. It works most of the time, but often enough, the entire linked table is exposed. When this linked record is functioning properly, I can hit enter, then enter again and select the desired record, as it is the first in the list. When it isn’t working properly and I do the same enter + enter combo, I select a name that shouldn’t be there. When the box closes out, no record is displayed in the linked record field. That is great, but something VERY ODD happens. The situation is this: Each project has several project contacts Each project contact is associated with one other contact (usually myself) While working on a project, if I need to add a new project contact, I simply click add new record From there, I select my name from the limited view linked record. When this doesn’t function properly, I mistakenly select the name of the first contact in my contacts table. This contac

I want to count the number of attendees on course. I’ve uplodad a pic of the formula. Any ideas what I’ve done wrong?

Is anyone using Memberstack and pulling data from Airtable to make a private client dashboard. I’m using Duda as CMS and have integrated Memberstack. Now I need to pull user data, stored in Airtable, and share with each client. Stuff like “Order numbers”, “tracking #”, etc.

How can I hide certain records from being displayed? We are using an Airtable form to collect entries but only want to display people we approve to the public gallery view that is embedded on our site. Is there an affordance to hide some records? For now, we just had to create a duplicate form to act as an overall collection sheet, from where I am then copying approved entries to the live gallery directory. Can this be made more efficient/easier?

I am attempting to calculate a cost per validation in a table using a Formula of two rollup Fields but I want the results to show either the resolution of the problem {column A}/{column B} or “0” if NaN or the sum of Field 1 if Infinity. Examples of problems: if Field 1 rollup is $1800.00 Field 2 rollup is 0 I need the formula in Field 3 {column A}/{column B} to show $1800.00 not Infinity if Field 1 rollup is $0.00 Field 2 rollup is 0 I need the formula in Field 3 {column A}/{column B} to show $1800.00 not NaN if Field 1 rollup is $1800.00 Field 2 rollup is 2 I need the formula in Field 3 {column A}/{column B} to show $900 Getting the formula to give me the last result is easy enough - but I can’t seem to figure out how to use nested if formula to give me either 0 or Feild 1 amount. Is anyone else able to help me build this formula? Please and thank you so much if so!

I use a formula filterByFormula=Lower(E_Mail)=Lower("{user_email}". If there is a special Character of # or & or + in the e-mail address, for example debby+maier@gmail.com the formula does not find correspondig records in airtable. Special Characters like !$%’*-/=? within the E-Mail address are found. Can someone give me a workaround or solution. Thank you for your help

Hi, I’m not very clued up when it comes to the more complex features of Airtable so I’m hoping someone in this community can offer some assistance :slightly_smiling_face: I managed to solve part of my issue through searching these community forums here I am using UK postcodes to determine a salesperson’s region. I have a list of these vs salesperson which can be viewed here. I have a webform that is pulling into Airtable using Zapier so it populates the fields whenever a form is submitted. I’m now adding some extra fields to this so that our sales team can utilise the base as a leads tracker. I’ve got as far as using a formula to assign a salesperson based on the first 2 digits of the postcode: And that is working ok, but it leaves me with the issue of when a postcode starts with a single letter as is the case on line 5 here. I also wondered whether it’s possible to add a collaborator based on the postcode so that they would be notified, but I think that might be a step too far vs w

I am working on a database of the individuals in our feeding programme. In December we host an annual Christmas party for the kids between 5 and 16. How do I write a formula to identify these children? I have tried variations: IF({Current Age}>4 AND {Current Age}<17), ‘invite’) or IF( AND({Current Age}>4 {Current Age}<17), ‘invite’) and I just keep getting error messages. Clearly something is wrong with my format but I don’t know how to fix it. Please help :slightly_smiling_face:

Hi, I am still an Airtable newbie. We are trying to set up a database of families receiving food from our NGO. I have one table set up for the families (with information like their address, intake records, etc), and one for the records of each individual (with information like birthdate, school reports, gender, etc). I have managed to get column showing the number of individuals in each family (on the family table) and one showing which individuals are children (on the individuals table). Is there a way to get a column on the family table that gives the number of children (under 18s) in each family? (something like a combination of a count and formula field).

DATETIME_FORMAT(SET_TIMEZONE(Date, 'Australia/Brisbane'), 'DD/MM/YYYY') This is not working for me. It doesn’t matter what I set the timezone to, it keeps saying it is yesterday. I need help to fix this because it is driving me crazy.

I haven’t been able to login for the past 10 minutes or so. Anyone else having issues?

I just made a table that I likely won’t need until next year at tax time. Can I hide it until then so it doesn’t get to confusing?

I am not able to access Airtable account or my base. All I get is the message that “something broke” Anyone else having a problem? My internet is fine. Sali

why has AIRTABLE SHUT DOWN?

I have data being automatically being inputted from Stripe to the column on the right. I need to -2 from the number in the right column and then *87 however I don’t want it to go minus(it does this when there’s no data in the right column). I want 0 to be lowest value it goes. Could somebody help? ( new to all this…!) Cheers! :grinning_face_with_big_eyes:

Hello Brains! I am looking for a way to quickly “fill inn the blanks” with the value of the above cell. Something like “if cell is empty, then copy value of above cell”. (This is an issue after my weekly import to my base) I know I can drag down to copy - but when there are many lines downwards, the speed is increasing to a level I am not in control of, and I risk scrolling too far and end up overwriting a cell. So I am stuck with ctrl+C, ctrl+V, but that makes a lot of manual work, and is a source for errors. (I also have coworkers in the base, so I need it to be easy, quick and safe). Any tips, tricks, formulas or scripts?

Hi there, I was able to grab a formula from this amazing community to show status of due items, which is working great – but I need to add in one layer and my attempts so far have only produced errors. Not sure if it’s possible or what I’m doing wrong. The current formula: IF({Due Date}="",“Not Set”, IF(AND(DATETIME_DIFF({Due Date},TODAY(),‘hours’) >=12,DATETIME_DIFF({Due Date},TODAY(),‘hours’) <=48),“Due Soon”,IF(IS_BEFORE({Due Date},TODAY()),“Past Due :no_entry: ”, IF(IS_SAME({Due Date},TODAY()),"Due Today :eight_spoked_asterisk: ",“Upcoming”)))) What I need to add to the above is : If Due Date is before today AND “Status” column = Done :heavy_check_mark: , then value should show as “Completed” Appreciate any help!! This community is amazing, and I’ve learned so much from you!

How do I insert a blank in a concatenation formula?

Hi all! Thanks for taking the time to read this, I am migrating from Google Sheets and really need an inventive solution to this problem. I’d love to know your thoughts. My company run Zoom workshops and we are required to generate registers with time in/out. Zoom gives me a CSV file with this data, but it often enters the same client accross multiple rows. I then need to apply deductions for any period of time where the client was offline during the session. Time in Time out Deductions 1 ␣ 09:28 ␣ 09:37 ␣ 00:00 2 ␣ 09:34 ␣ 10:16 ␣ 00:00 3 ␣ 09:44 ␣ 10:16 ␣ 00:00 4 ␣ 10:18 ␣ 10:37 ␣ 00:02 5 ␣ 10:19 ␣ 10:37 ␣ 00:00 6 ␣ 10:38 ␣ 10:44 ␣ 00:01 7 ␣ 10:40 ␣ 10:44 ␣ 00:00 I can use a roll up to identify the MAX and MIN times, but cannot work out the deductions. To achieve this in sheets I did {Time out 2} - {Time in 1}. This had to be applied once the data was appropriately sorted using a macro. Clearly this does not work in Airtable - any other smart ideas?

I have a list of video assets that I was originally tracking in Google Sheets. I have three sheets/tables- the first table has the main data and the following tables include tags for the videos. All the records on all three tables are the same, they just have different tags. I couldn’t link the records in Sheets and so I was manually updating the records with the tags. Now I’ve discovered Airtable and this would have made my life a million times easier. So, I need to convert those other tables into a new field and this will solve the issue of this table being too big (too many records). Because I was using Sheets, on the tags sheets, each tag is a column/field. It should just be 1 field that is multiple select that I just choose which tag applies to that video. I’ve converted one table to single select and fixed the labels, but now I need for those single select fields to all combine into one field that can become a linked record. Do I use rollup? I really don’t know what to do. I coul

Hello, I see that there is a rate limitation on querying Airtable records. But is there a limitation on Airtable attachment links? I am building a table (and form) where users can upload multiple files for one entry. Later I would need to download these images off Airtable to a local DB. When downloading the CSV from Airtable, the attachments appear as links from Airtable. Would like to know if there is any specific rate limit on hitting these URLs. Thanks!

I have multiple affiliate links and descriptions that i would like to separate from their linked record. I’d like to have D1 (Description 1) and L1 (Affiliate Link 1) to be CONCATENATE(D1, L1) However, with the lookup field pulling in the affiliate descriptions and links, they are all listed as D1, D2, D3, etc. & L1, L2, L3, etc. How can i separate them from that list and pull them into another field for other use? While maintaining a correlation between D1 and L1 and D2 & L2, etc.

I’m trying to calculate a formula using the if function but not sure where to start. My formula correctly calculates the wholesale cost of a case of 12 bottles of imported wine from the ex cellar price. However, still wines under 14.10% Alc are taxed at 25% of the value (ex cellar x 1.25), still wines 14.1% and higher are not taxed, and to make things even more exciting, sparkling wines are never taxed. I want to make one formula that incorporates whether the wine is taxed or not. can anyone help? in my formula: ex cellar = price of 1 bottle of wine in EUR, 1.15 = est exchange rate 1 EUR= USD, 12 = number of bottles in a case, 18 = cost of shipping in USD to import the wine, 0.6 = target 40% margin on final price. everything works fine, just not sure how to incorporate the tariff on some wines but not others.