Other Questions

Hello I have in my base five columns: Product Name (starting point) (ex: Apple Macbook) Main Color (optional) Secondary Color (optional) Finish (optional) Product Variant Name (formula) I am trying to write the following formula to generate the “Product variant name” , but having a hard time: Product Variant Name = Main Color + “,” + Secondary Color + “,” + Finish However, IF ANY of those three optional fields is (blank) then skip it as well as the “,” corresponding to it My hope is to get in “product variant name” a clean product name. How can I do so? I get lost when trying to use the IF / AND formula :frowning:

Is anyone using airtable to crunch census data? I’m curious if it’s a good fit and if anyone has jumped in.

I don’t remember my new password. I have the old password. I didn’t register via email because contains special characters " _ ". How can I log in again? Thanks

I am trying to do a look up based on two fields. Here is the situation: my first field is called Severity and it is the primary field of a “severity definition” table, which contains 5 records my second field is called Probability and it is the primary field of a “probability definition” table, which also contains 5 records I have created a junction table, called “Risk acceptability” which is built with the two above-mentioned fields; the primary field is built as a formula (Severity&"-"&Probability). On that table is the field “Acceptability” which is the one I will try to lookup. See below -Finally, my FMEA table will allow for any new record to pick a Severity and a Probability: I would like to automatically have the “Acceptability” appear. So I have created the same formula in that table (Severity&"-"&Probability) to lookup to the table “Risk acceptability”. Problem is: I cannot create a Lookup based on the result of the formula. So my question is: how can I use

I have a form that i send to my faculty and I want them to be able to choose their own name “record” and have the data show up in that “record”. I figured out how to get a drop down for the faculty to choose their own name but when they input data it creates a new line “record”…Boo on that!

When using Filter in Grid view, I can filter across linked field with multiple values. However, for the same field in Calendar it doesn’t work. As seen in the screenshots, filtering for a name returns multiple records in the Grid view but not in the Calendar view. Is this a known issue?

Hi, I am trying to add comments on table in airtable but not able to see any option from where I can comments on table, but there is option for comments on using row only. My question on comments is Can we write comment on table directly instead of write comment on row? Is there any API available for write comments or retrieve comments? Thanks

I track contract dates in Airtable. I need to use this field as a reference in an email automation. However, in order to have the date show up correctly in the automation, I have to use the Set_Timezone formula –here’s my formula --DATETIME_FORMAT( SET_TIMEZONE({Contract date}, ‘America/Los_Angeles’), ‘MMMM D, YYYY’)– When I use this formula, the date now changes in this formula column in my database to the day before the date I have in the Contract Date field. This seems ridiculous that this is an issue and I assume I’m doing something wrong. I could just write a day ahead of the actual contract date to “solve” this issue, but again, this seems ridiculous. How can I set up my Airtable so that when I input the contract date, it’s in the timzone I’m in, so that my formula field (which I have to use so that it shows up in my automated email) is synced correctly with my Date field?

I have entry and exit dates (date range) for volunteers to our project. Each volunteer has a separate record. I need a formula or method to show on a calendar how many volunteers I have on any given day by referencing the entry and exit dates of the volunteers.

Hello Airtable community! I have Table 1 with over 10K records, and I want to link every single record there to Table 2 in the Linked Record Field such that everytime there’s a new record in table 2, the Linked Record Field already has all records in Table 1 linked. I actually found a solution through the Automations app and followed this instruction: Linking existing records using automations – Airtable Support But it seems to not link all the records. So I reached out to Airtable support and found that there’s a limit of 1000 records linked in this way. So I am wondering if a Script can solve the 1000 records limitation, and if so, I am happy with the solution where everytime I have a new record in Table 2, it all records in Table 1 are already automatically linked, or I can take an additional action like checking a checked box as a trigger (as suggested in the Automations instructions). Thanks in advance!

Hi everyone I’m using n8n.io to facilitate the process of sending email via AWS SES. The small issue though is that the various nodes used in n8n to send email (both generic email node and AWS SES node) don’t seem to play 100% well with the body of the text I link to it, which sits in a lookup column in my airtable table (looking up from a Long, Rich Text enabled column from an another associated table). Basically, my results of sending such text from n8n suggest the AirTable Long Text (Rich or not) via a Lookup is neither sending across plain text or html text, and instead something in-between. Thus is there anyway to convert the Long Text to pure html? Thank you Stephen

Hi! I am using Zapier to autofull documents based on airtable inputs, I am struggling with checkboxes and trying to use formula fields to provide me with a “true” or “false” based on the input of a single select field. Has anyone used single select to provide a true or false outpouts, I am stuck!

I would stop my pro-trial plan and start my subscription with Pro Plan immediately, How could I do it? (because I want to write script for my automation and it was indicated that my plan can not do that) Thank you in advance Wirun

My organization has 10 employees. We all work on a single base. But few of the records in each base will be handled by different employees. I want to restrict employees to view and edit only those records for which they are the collaborators. But as an employer I want to view and edit all the information in the records. I also want to restrict my employees from accessing few columns. Can you please let me know how to proceed. Thanks in advance

Hello there, I am trying to achieve a couple of things with my Airtable setup and I am stuck. Hope someone has a good idea. There are two tables [Main] and [Calc] with the following info. [Main] Table I create, export and send it to someone else{Headline} Headline of a record or multiple records{Headline2} Headline2 of a record or multiple records{Headline3} Headline3 of a record or multiple records{Headline4} Headline4 of a record or multiple records [Calc] Table I receive back{Headline} Headline of a record{Headline2} Headline2 of a record or multiple records{Headline3} Headline3 of a record or multiple records{Headline4} Headline4 of a record or multiple records{GroupID} Group id of a record or multiple records{UniqueID} Unique id per record Each {Attachment} in [Main] receives a {GID} in [Calc] and there could be multiple records with a {UID} per {GID}. I would like to identify related records and have the information about the relation in both tables [Main] and [Calc] in order to

I am trying to add hours to a created date to get the due date of the project. First I tried this,`` DATEADD({Created On},{SLA (Internal)}),‘hours’) For this, if I am adding 64 hours to a Created on date 07/29/2021 4:16 pm the results I am getting is 07/29/2001 9:15 pm. As this is not the result I am looking for, I tried the below formula which I got from the airtable help forum, but it doesn’t seem to work either. Totally new to Airtable. DATETIME_PARSE( DATETIME_FORMAT( DATEADD({Created On}, CONCATENATE(’+’,{SLA (Internal)}),‘hours’) ,‘M/DD/YYYY h:mm’))

We have a zap using zapier set up so that airtable will record results from squarespace as well as from typeform in two different tables. In both cases, when the information is transferred, there are duplicate rows of information. Each row of information is recorded twice in airtable, even though it is only recorded once on typeform or on squarespace. I have checked the zapier side of things and it doesn’t seem to be an issue there. Is there a reason airtable is suddenly recording each row twice? Just a day ago it was working normally, and only recording each row once.

Hi all! I’m working on a user research Airtable and need some help. I’d like to make a column per question in the original table, then be able to click somewhere to view all answers for that question. Sort of like this mockup below, where the view is grouped by “question”: So far, when I group by a field, it breaks it out by answer. That means, in this example, that I get three different groups, which is not what I want. What I would like is to have each group be a question. Thanks in advance for your help! Let me know if I can be more clear :slightly_smiling_face:

I’m trying to write formula for a field that would check the {CHECKBOX} field for a check (=1), and also check another {FINAL AMOUNT} field for a range, to then return a corresponding value. If the {CHECKBOX} is empty (=0), I’d like the field to just return a “0”. I’ve tried tons of different ways to nest IF and AND statements, and the only formula I tried that will not trigger a syntax error will not display the values if both the checkbox and range criteria are met: IF(AND({CHECKBOX}=1,{FINAL AMOUNT}<20000,500,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=20000,{FINAL AMOUNT}<40000,750,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=40000,1000)))))) If I try to add one more IF statement (either at the beginning or the end) to yield the “0” if {CHECKBOX}=0, Airtable tells me it’s invalid: IF({CHECKBOX}=0,0,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}<20000,500,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=20000,{FINAL AMOUNT}<40000,750,IF(AND({CHECKBOX}=1,{FINAL AMOUNT}>=40000,1000))))))) I’ve read ton

Hi everyone I currently have a table of PROJECTS (100s) and a table of RESPONDENTS (1000s). Could anyone advise how I could easily assign a batch of filtered RESPONDENTS (let’s say I filter to about 1000) to a one (or more) selected project/s from my PROJECT table? What’s the most efficient way of doing this? Any advice would be greatly appreciated. Thank you Stephen

I would like the different Collaborators to be able to have a view where they see only their records when they login to Airtable. Currently the only way to do this would be to create a view for each user with a filter on Collaborator field. Or is there a better way to do this, say filter for Collaborator to be the “Signed In User” Ruchika

I love Airtable and I love to use it for all the things but I really wish in there kanban mode you could just type and hit return in the view instead of it opening the field for each record! I do this in Asana but I don’t want everything in different places :weary:

What is the syntax for an IF statement that only generates output if two conditions, in two fields, are met? Thanks for your help!

I am having trouble sorting a list of records in chronological order by date using a field that I have formatted with a formula that calculates the day of the week, month, day of month. The sort is defaulting to alphabetical. The formula I’m using is CONCATENATE({Start Day},", ",{Start Date}) Start Day Formula is: DATETIME_FORMAT({Start Date & TIme},‘dddd’) Start Date formula is: DATETIME_FORMAT({Start Date & TIme},‘ll’) I’m running into an issue as I go from month to month that aren’t in alpha order (sept to oct for example is being listed with oct first. I feel that if I change the formula I sort by to a DATETIME_FORMAT then this could be fixed but I can’t figure it out. Any help or direction would be greatly appreciated!! Thanks!!

I’m building a base to track contributions and multi-year pledges to a charity. Am wrestling with how to apply gifts against a specific person’s pledge when someone has more than one pledge. Example: Bob Smith pledges $100,000 to a building project for a new HQ, then 6 months later makes another pledge of $250,000 to endow scholarships. Each pledge might have a separate payment schedule (e.g., $33,333k/year for 3 years … or $25k/quarter for 2.5 years, and I need to be able to track payments made against either pledge so I can track the balance. Have someone using a Form to enter pledges or payments (separate form for each). Currently have pledges and payments (whether the payment is a one-time contribution or payment on an existing pledge) together in 1 table. Do I need distinct tables for pledges and payments? Other suggestions? Thanks …