Other Questions

Hello. I’m new here and so far I’m quite impressed with all the possibilities Airtable offers. I searched all the help topics and community topics for the answer to this question, but I may not be wording it correctly. I have set up a Product Inventory and Sales base for my fledgling business this past few week, with no problems. Yesterday I received a notice of price increases from one of my mfrs to take effect 5/1/17. When i change to the updated price, the change affects all transaction from the past. How do i input these price changes to take affect only on and after 5/1? Maybe i should create an additional column and use updated pricing? Thank you.

Hi, I can not upload a record in Airtable using W5100S-EVB-Pico . Its support ethernet connectivity and uses micropython-urequests library to ‘get’ and ‘post’ data. Kindly help…

Is there a way to “publish” an Airtable database that family and friends may access without needing the Airtable license? Considering Airtable as a replacement for Zoho Creator (which does allow for database publications). Thanks so much.

Hello community!! I’m really hoping for some help here as I’m struggling to find the solution. Here is my problem: I’m running a survey into multiple schools / classes, and I can’t link the # of the survey to the students in each class automatically. So on one hand I have a table with the surveys that I will be running in each school and class. On another hand I have a table with all my students with the class they are in as well as the school. If I would be in excel, I would create a basic concatenate of the unique combination of school+class and link to the student table. In Airtable I’m able to link yes. But by doing this through the link to a record field, I need to manually associate the students to to the other table, which when I will have 2000 students it’s going to be a huge problem. I’m attaching screen shots… thanks for the help!!! Patrick

I’ve got a Pro account, so I can see the counts and types (field, view, sync) of dependencies in Field Manager, but not the details. What does it mean for a field to have a VIEW dependency? It doesn’t seem that it means that particular field is shown in a view, because when I hide that field in a view, the number of view dependencies doesn’t change. Does it mean that the field appears in a shared link of a view?

I’m using the Timeline view to display a project duration for resourcing purposes. I recently learned how to add a milestone. However, from my understanding, you have to create a record separate from the project. Is there a way to combine these records in order to have the milestone overlay (aka live within the start/end date range) the start/end project display?

I’m trying to create a form that allows residents to sign-up for one of the programs we offer. One of the common issues I’ve had with sign-ups in the past is that residents are allowed to type in their address and then select the neighborhood they’re in. However, usually they don’t select the correct neighborhood so it creates more work on the back end having to fix it. I have an excel doc that contains everyone’s address and their associated neighborhood. Is there a way to connect excel doc (or the data) this with my form somehow so that when a resident types in their address it automatically fills in what neighborhood they are associated with? That way they don’t have a choice about what neighborhood they’re in, it just tells them.

I have my main contact database in Airtable, and I’m using Zapier to update the information when we get new registrations in other apps as well. It all works great, but I’m looking to remove a bulk list of inactive people based on our email list. I pulled a CSV from MailChimp and I want to remove those people from my Airtable contacts. Is there a way to segment out that group to bulk remove them from my main list?

Hello Everyone, I have a table that is linked from another table that gives me a summary by percentage for every group. Now I need to take that percentage by month vertically. I wanted to create something like this, see screenshot below for reference. Is this possible in airtable? Thank you so much for future response!

Purpose: In a table where the field is a “LINKED to record” field. Many times the value for the LINKED field is a value in another text or formula field. A script that can take the value of a string field, and insert that value to the LINKED To field so that the lookup is somewhat automatic. Currently the only way to do this is to manually do a copy/paste from one field to the LINKED Field. I believe what would need to be done is - Copy the table field from to a variable Do a lookup in the LINKED Table Insert the valid lookup into the LINKED TO Field If there is an invalid look - then don’t display anything ie. Master Table Phone # Link to Contacts via Phone Name Lookup 111-111-1111 111-111-1111 Abe Lincoln (This is the desired result) Lookup Table Phone # Name 111-111-1111 Abe Lincoln

Hi there, we try to sync a calendar view from one base to an other but it says its disabled but when we try to enable it its gryed out. Any help please? The grid view from the same base works fine and the enable / disable option is functional. Thanks.

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/ Singapore’) But still, nothing passes through the filter. What can I do better here? Thank you

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’ve been reading

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, fields: { "Dat

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 heart the id of each customer… I would like to be able to choose the customer by his, or have a list of contacts related to the company where the deal belongs… Thank you for your help. Julien

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# once and it is important that we only have a short