Other Questions

Hello everyone, I am currently using make.com to supplement some of the functions on AirTable. I have a table of my Leads, with the {Lead Status} as the focal point here. When {Lead Status} is updated to ‘Closed Won’ I want make.com to create a new record in my customer base. I’ve set up make.com to watch the {Last Modified} field (which was set to only change based on {Lead Status}) The formula used was {Lead Status} = ‘Closed Won’ Then there is a filter set up, where {Last Modified} is “now” However, nothing seems to be able to pass through the filter. Even when I set the formula in the first Watch module to AND({Lead Status} = ‘Closed Won’, {Last Modified} = {Now}) Where {Now} is a simple formula field on AT, where SET_TIMEZONE(NOW(), ‘Singapore

Hello All, I’m New Here. Sorry for my English. I Use Airtable from Last 2 Years but Got Server Issue from Last 1 week. Always Stuck and Only Loading. Here is Video Proof. Please Check it and Help me to solve Issue. (I Already tried with Clear Data, Cache, Cookies and Also try on another Browser but Result is Same) Here is Video Liink: 56.42 MB file on MEGA

Hi! I’m trying to find a way to see if a long text field contains what’s in a single line text field from another table on the same base? For example, Table A has a list of different ingredients (one per record), and Table B has a list of recipes with all ingredients that are needed for each recipe in a long text field. I’m trying to automatically see if one of the ingredients on Table B is part of the single line text field ingredients on Table A, then maybe use an IF formula to create tags and tell me how many we have vs we don’t have. Ideally all this would happen automatically when we add a new recipe/record, since I’m using image to text to grab all the ingredients quickly and won’t be selecting one by one of the ingredients of Table A. Is there a way to see if the list of Ingredients from Table B contain the Ingredients from Table A? Would I need to first break the list of ingredients into single ingredients by separating through a comma or something like that? I

This is probably really stupid but my formula below is returning the opposite of what I expect. I set the Start_Date field (data type DATE) to 9/1/2022 and TODAY() is 9/30/2022. I would expect the result to be “Y” instead it comes up as “N”. What am I doing wrong? TYIA IF(DATETIME_FORMAT(TODAY(),“MM/DD/YYYY”) > Start_Date, “Y”, “N”)

Hi, Does anyone know how to fix this error my script is throwing? I originally used the script function to avoid the 100 record limit of find records…I put stars around the line where the script has issues. let inputConfig = input.config(); let table = base.getTable("Companies"); let records = inputConfig.triggerRecords let interactionDate = new Date(inputConfig.interactionDate) let updates = new Array **let companyRecords = await table.selectRecordsAsync({** ** recordIds: records** }) for (let companyRecord of companyRecords.records) { let companyInteractionDate = new Date(companyRecord.getCellValue("Date of Last Interaction")) if(companyInteractionDate.getTime() < interactionDate.getTime()){ updates.push({ id: companyRecord.id, fields: { "Date of Last Interaction": interactionDate } }) } else{ updates.push({ id: companyRecord.id,

Hello. I was working on a project when I came to a roadblock. I have been using record linking fields, lookup fields, and rollup fields to work with data between tables but that requires you to manually select which record connects to which. Example: I was wondering if there was a way to get around that because there is a table that will likely have thousands of records so it would be nearly impossible for a single person to manage. This solution would preferably allow for the use of formulas as well but any solution would do. Thank you in advance for any advice!

Hello, I’m trying to extract the final number at the end of a string like this: Josh-B7-3 Ben-B8-28 Chris-BN-294 I want to extract just: 3 28 294 Any ideas? Appreciate your time :slightly_smiling_face:

Hi, I want to be able to copy a group of multi select options from one record to another record on a different table. If I copy and paste, it makes one new multi select option in the new field of everything I copied over. How can I copy this over without having to add in each one individually?

Our nonprofit needs some guidance, please. Can we create this search tool in Airtable? We will have a database of colleges. 4k rows 2 fields: • college name • URL of college page on a separate website. We would need to embed the search tool in our separate website via an iframe or JS. Visitor starts typing name of college. As they type, they see a shrinking list of matches. Match might not be at the beginning of what they type. For instance, if they type “Texas,” they would see all of: Texas A&M and also University of Texas. When they click a college name, that takes them to the URL for that college on our website. We could also have them click a link adjacent to the selected college’s name. If we cannot do this in Airtable, we would welcome suggestions on a no-code app that would let us do this. Thank you very much!

Hello, I use Airtable to build a simple CRM. I have a table dedicated to the client companies. (PF = String) I have a table dedicated to the contacts belonging to these companies. (PF = Autonumber…I do not have an email or a phone number for each contact) I have a table dedicated to deals (PF = String) A deal is linked to a company and a contact. I would like to be able to select a contact in my deal table, belonging to the company to which the deal is linked. In my deal table I can easily display the name of the company, which comes from the customer company table. However, when I want to choose a contact, I can only look for it by its contact_id (PF contact table)… Except that I have 2000 and I can’t know by

Hello, I have multiple typeform forms and I need to integrate all of them into one airtable table. The integration of the first typeform is OK but when I integrate the 2nd typeform form, it shows me only fields from the 1st typeform form, even though I am “connecting” from the 2nd typeform form. How can I do this?

Hi all, New user to AirTable here. I have a base set up that shows my users etc and a linked field that enables me to select a course for those users from another base. This all works fine. In the base where all my courses are stored I wish to add a count field to show how many users have a specific course assigned to them - however I can’t seem to get this to work. Hopefully the screenshots attached help. The first base has a column called ‘from delivery plan’ which is where I select the course from another base. The second screenshot is the second base with all the courses listed - I’d like to have a column which shows how many users have been assigned this course. Thanks in advance :slightly_smiling_face:

Hello, I have a problem with the rollup field, it stop working on my base. I can’t have the second element to choose to summarize the data … Has anyone ever experienced this?

Hello, This is more like How to make a ‘single field from a synced record permanent’. But I thought that may be a confusing subject title. I am trying to use synced data and make a field permanent regardless of what happens to the initial data. Example using two bases that are manually synced (for now): Base 1 syncs properly to Base 2 and displays all the ‘active’ jobs and their ID #. I then use a formula in Base 2 which uses the JobID#. What I have noticed is that if the Job becomes ‘inactive’ (or deleted) in base 1 and I do a manual sync it will no longer show in the Base 2 table and as such it disappears from the formula. How do I convert the lookup field from Base 1 into something permanent in Base 2 that will not change? (I know there is a setting where I can leave the records in Base 2 synced table, but I do not want to have a large list if I can avoid it). I do not need it to technically ‘sync’. I just need it to get the jobID# o

I am attempting to bring in RSVP data from guests associated with a Google Calendar event. At the mapping stage on an ICS import, there is no way to bring in that kind of data. I suspect AirTable can not capture RSVP data (or Google doesn’t provide) from an ICS file so wondering if there may be workarounds?

Hello! I’m trying to run an automation that clears a multiple select field rather than appending it. The only help topics I can find are about adding a value not clearing a value. Does anyone have a suggestion on what to do? I have tried everything! Thanks :slightly_smiling_face:

Hi Airtable Community, I’m looking to figure out a way to create my team’s baseball lineups in Airtable and have grouped by date. I’m looking to duplicate the entire lineup and update the date field (upcoming game) all at once. Is there a way I can do this or add an automation? Below shows you how I’m looking to duplicate all the records for 9/25 and create a duplicate data set, but for 10/2. Thanks for the help!

I’m having trouble coming up with a formula that chooses the earliest of up to 12 dates with times. I’ve seen other questions that are similar but this involves times too. The Time 1 … Time 12 variables are from a lookup in another table. They might be blank. MIN( VALUE(DATETIME_PARSE({Time 1},‘MMDYYYY hh:mm’), VALUE(DATETIME_PARSE({Time 2},‘MMDYYYY hh:mm’), VALUE(DATETIME_PARSE({Time 3},‘MMDYYYY hh:mm’… ^ Fails. Thanks!

I am building a document automation app. My staff will enter client information into a form which is uploaded into Airtable. Form there, formulas will build the parts of the document and, ideally, dump them into Formstack (Webmerge). My problem comes in that when this happens, the formatting is lost. The formulas that I create for this purpose have html tags such as: <h1>, etc. The word document has these headers defined. Formstack has field mapping turned on and I have included some of their code for formatting. For instance {$variable} becomes {$variable|html2office}. Other than bolding one of the header lines, no other formatting pulls through and in the generated document, all of the lines reflect “normal” style. The document I am generating (estate planning documents) will need a number of different levels, section numbers, etc. Is there a better way to do this? I really do not want to dump all of the possible formulas into the word d

Hello everybody! I was wondering is there a way to make it so that airtable and chose a record randomly?

Is there a way to set up a lookup field without duplicates?

For example we do surveys to our schools, and they have multiple choices as to how to answer the questions. We want to pull data based on how many students answered a specific way to a specific question. We created the questions as fields and sent the forms out. So like: “How often do you come to class prepared?” and the answers are “Never” “Sometimes” or “Often” and we would like grab what % of the students answered “Never” or “Often” etc… End result would be a pie chart that has the questions and the % of students that answered “Often” Very Often" etc… any help pulling the data as a sum or even a percentage would be AMAZING!

:smiling_face_with_sunglasses: I’ve heard many folks in this community are working independently on projects for clients to make super awesome custom solutions. Airtable is great for this! :star_struck: I’m looking for anyone interested in broadening their skills to collaborate on an application. We’re a start-up nonprofit with an idea I think will be huge for organic, local community building. :muscle: We could sure use your help! More info in the linked thread below. Continuing the discussion from Seeking a Volunteer Airtable programmer:

Hello, I’ve seen a few forums on here that address something similar but none that exactly addresses my issue or gives a clear answer. I have a series of price entries in a table called RFQ/PO Items. I have a Lookup on a table called Supplier SKUs that looks up each of the prices on the RFQ/PO Items table. I have a Lookup on the Supplier SKUs table that looks up each of the Dates on the RFQ/PO Items table. I have a Roll-up on the Supplier SKUs table that looks at the MAX(values) to return the latest Date from RFQ/PO Items. What I’d like to have is something that let’s me see just the latest Price. So, if there are three prices, $5, $8, and $6 on 1/1/2022, 2/1/2022, and 3/1/2022, respectively, I would like the rollup to return the value “$6”. Thanks in advance for your help!

Hello, In the timeline view is it possible to display in the summary bar in use mode utilization a color when an employee is unavailable Merci beaucoup for your help Franck