Other Questions

I recently started using air table as a PIM. Each product has multiple tasks that need to go to team members. I want each task to be its own task per product.(Ex Product A and Product B booth need a description but currently in tasks they are both grouped under the one "Description" task and are not able to be marked as done individually.)Is there a way to make these all 1-1 instead of 1 -many? 

We have upgraded to Business account from Team. On Team plan I had set up one way synced tables, I have changed the configuration to allow creation of records from the target base. However, I still cant create new records on the synced table. Do I need to sync the table again? I would like to avoid that because of the relations I have to renew in the target base.

Hi Aweome Airtable Community. Please could you help me understand what I am doing wrong or enlighten me as to why this is happening?I have attached a sample of the Automated email that is sent to our client with a copy of all their appointment in a grid.The issue is that the appointments do not show up in the correct date order for easy checking, and we have had complaints.Why does this happen?  Is it using a different field so sort the appointments?Thank you in advance for the advice and help     

Hey guys,I have a team that is using the comments in airtable for their communication, where they tag users and user groups. When they tag users the user gets an email notification, but when they are tagged through a user group they do not get an email notification. Is there a way to turn that on?As a side note, I feel that the comments section needs an overhaul in general.Thanks!

Hello, I have several different lead sources filtering onto a base. I have a TEAM of real estate agents that I would like to auto-assign to a lead in a round robin fashion so once all 9 agents receive a lead the first agent will receive a second lead. We have our incoming lead base synced up to receive lead data on via zapier but how would I add on the next agent in line? I believe once this is done I can set up a zapier integration that will notify each agent that a lead has been received… Please let me know if there is a solution or formula I can use! Thank you, John from San Antonio, TX

Bonjour ,J'espère que vous allez bien.Je vous écris pour savoir comment effectuer un regroupement d'éléments dans une vue de liste (list view). Je voudrais regrouper les enregistrements par un champ spécifique pour mieux organiser et visualiser les données.Pourriez-vous m'indiquer la procédure à suivre pour appliquer cette fonctionnalité ?Je vous remercie d'avance pour votre aide.Cordialement,

We're currently using Airtable for resource management and planning in our agency. We break work items down into 'tasks' which our team work on and we estimate time before it starts. I want people, to easily be able to track the time taken against those tasks, as well as (if possible, and easily) other tasks which don't exist at the moment in the system.I have a field for time tracking (see attached) but it's a single field and as such not great for adding multiple entries for a single task which might span multiple days and so on. Plus it's only goof for if the task already exists vs. people being asked to work on stuff that isn't in the planning system yet. Not sure if I should try and build something into Airtable but it means replicating functionality of time tracking apps which already exist or if I should try and integrate. I have looked at toggl and harvest so far but neither seems perfect in trying to map a good workflow in those systems based on my Airtable data being the

Hey All I have a template table with sample dates, this is a process our company uses over and over. I am looking for the easiest way, to keep all dates relative to each other the same, but just advance all of them 2 weeks, 3 weeks, 10 weeks, etc. the goal is to take the template created now, and not modify each record by adding the time manually and make mistakes, but to be able to advance all the dates forward at the same time and by the same amount. Also, is there any way while working with a gantt chart to click and select all records after a certain date and push them back a week or two? the goal of this is to be able to quickly adjust schedules in the event of a delay, ie, leave everything that is in the past as is, and ‘grab’ all future events and bump them back x amount. thank you

We currently are exploring if Airtable is suitable for us (small agency). As part of my investigation I ran into the upgrade options to 'Team plan'.While we only intend to have a very limited amount of editors/creators (max 3), but do like to added functionality of the Team plan, it seems impossible to reduce the amount of (6) seats in the Team plan.In my case, with 3 intended seats, I would pay minimal $40,-/seat/month (annually).How can I get a Team plan for 3 editors and unlimited commenters? Thanks for helping out 🙂  

Every time I try to add creator access to the new treasurer of our school society , it doesn't work. It makes the person have commenter access but then when I try to change it to creator under the drop down menu when you go to "manage access" it tells me there's an error (Error: pglpqKAGvjJY649Z1) and I should refresh the page (which doesn't work FYI). When I try to share a link instead , the new treasurer says that she either still can't access it or that it says there are too many people on the page already. (so I tried to delete some old collaborators off the page but it still doesn't work and still says there is too many people). How can the error be fixed and how can I share the page with creator status to the new treasurer and president of our society ?

Hi Guys, I want to send a document (attachment field in Airtable) for digital signing and then have the returned document saved in Airtable also. Effectively the unsigned document will be loaded into Airtable via a form and once certain conditions are met it will be sent to another recipient for digital signing. Is this possible through integromat or zapier? I don’t have a preference on signing platforms as of yet - just whatever will work really. Thanks in advance, Theo

Hello everyone! I am designing a table in my Airtable Base that allows my employees to create invoices as records. I would like them to be able to link materials from the Materials table so they can add several materials that they had used on the job within the same field. I would like to know if there is any possible way to select a quantity for the items in the field. For example, if I select an item, I would like to select the quantity I used of that item. Please keep in mind that the field is linked to the materials field as “Link to another record.” Here is a screenshot of the Invoices table: I appreciate anyone’s help in advance. Thank you!

Hey all! I have what I suspect is an array issue with Airtable's back-end, but it's preventing me from filtering on the front end, so I would love some help.I have 3 tables: Books, Products, and Authors. A book might have multiple authors, and each author may or may not have a bio. I have made a roll-up in the books table for author bios with this formula: IF(values, ARRAYJOIN(values, "\n\n"), BLANK())I have also tried it with just the ARRAYJOIN, and no if statement.I then have a 1-to-1 relationship between Books and Products. In the Products table, I have a look-up of the roll-up of the bios in the Books table. Here's the issue: when a title has multiple authors, but none of them has a bio, the roll-up should obviously return blank. The look-up in the products table should return blank. But when I filter products by having the look-up be blank, the record in question won't show up. I tried filtering by newlines, whitespace, anything I could think of, but I can't find how AT

Greetings Airtable CommunityI have a long text field with RTF formatting enabled. The text includes links to web pages, emails, and phone numbers. The web links are working perfectly, as are the email links (using mailto:)—but the phone numbers are not working.When formatting the phone numbers, I did the following:1) Highlighted the phone number2) Clicked on the link icon3) Entered tel: and the number (+3606500000)But when I click on the link, I see that the system has inserted 'http://' in front of tel: and this takes me to a "can't open the page" error instead of initiating a phone call. The system hasn't inserted 'http://' in front mailto:Thanks in advance for suggesting a solution! 🙏

Hi everyone!I'm looking for a way to automatically set the time to 00:00 for certain entries in Airtable that have a date field. The goal is to allow some entries to have a specific time (like for flight schedules) while others default to 00:00 (such as open train tickets). I’ve tried using forms to set a default time, but the options only allow me to set a specific date and time or use the current date and time, which doesn’t work for my needs. Does anyone know how to achieve this?Thanks!

Hello, I have a Airtable Table that sorts different records by release date. I want to be able to manually re-order the different records that have the same release date (as many of them do) but for some reason I can't figure out how to do that? I've tried to turn off automatic sorting and then manually re-arrange my records but as soon as I turn automatic sorting back on, it overwrites my changes. Anybody got a fix or insight for this?

I want to add rows in airtable According to Shopify order quantity,for example if quantity is 4 then 4 rows must shown in airtable with random spot numbers but unfortunately Shopify give us just one spot of order is there any automation expert here who can solve this issue

Hello! I have had a colleague leave recently who made a form that links to data that gets submitted. However, I cannot locate the workspace the data is pulling into and cannot ask the colleague. Any tips?

 I have a problem with related tables.Button 1: When you click the "Add" button, it does not automatically fill out the foreign key. However, you can cancel the form at any time, so it will not be saved in the database.Button 2: This button automatically relates the record to the parent table. However, if you do not fill out the Mailing Address and Source fields, the record is still saved in the database. Therefore, if you accidentally press the "Add Record" button, you will need to delete it manually.Questions:How can I fill out the foreign key in Button #1?If I use Button #2, how can I prevent the app from saving the data in the database if I haven't filled out the Mailing Address and Source fields?

TLDR: is there a standard format that people use to define the application they want to build so companies can bid on it's implementation?When a new person decides to farm out the work to one of the solutions companies that are part of this community, is there a standard specification document that a customer can author that allows solution architects to bid on the implementation?  Or is there another site that people solicit specialists to do the project?  I am sure that the types of customers range from a small retailer to a large company, with each solution provider geared to implement on either small, medium or large solutions.  But there is probably a cap on the "large" before a company just goes full oracle database or the like....TBH, it would probably be an interesting airtable/filltable app to allow people to define their requirements. I wouldn't be surprised if one is out there and I'm just not aware of it. 🙂Thanks.Jeff

Hello all,We have an automation set up through Zapier that searches for a record and updates the record if it finds it and creates a new one if it doesn't. The problem I am having is that duplicate records are being created that match the search criteria. I am unsure why and where to look for the issue (Work Flow: Jot Form to Zapier to Airtable).Additionally, if anyone has a fix for a dupe record created because there is an extra space in the field (where and how can I strip it out or make it part of the search criteria)Attached are my search criteria (with a fictional test person) in Zapier and the ID in Airtable.Thanks for any suggestions. 

I'm new and have watched a lot of excellent tutorials that seems to indicate that I should be able to do what I want, but I wanted to ask the user-base to confirm, and perhaps to add any "to do that, do this" comments. I'm on the free plan, but if i can get this to work, I definitely want to upgrade to the paid plan and support the service, but I've been so bad about getting started on projects and then get distracted by some other shiny object and abandon it.  But this time I'm hoping it's different, as the product seems pretty simple to use.I help run a local makerspace, and we have members that pay dues to get access to our space that has tools and stuff.  People apply for membership, and our rotating board of directors (elected by the membership) approve the members.Currently, our process is:member sends google form to apply.the board members get an email, and they reply all with "aye" or "nay".If we get 2 "aye's",  I manually send an email to the prospect to tell th

I have uploaded images as attachments to about 250 records in a base. Each one uploads without issue and I’m able to see the preview in grid view and the full image in gallery view. I checked each attachment as it was uploaded. The problem is after the fact: now, about 25% of them are coming up as empty jpg icons in both views. When I attempt to open the image within an individual record, the same thing happens - a white box with the jpg icon and the file name. Any insight? I’ve tried refreshing the base, but to no avail…

TLDR: Is dokuwiki a reasonable solution for non-airtable user account management? Or is there something better?As I'm trying to build my application for a social maker related nonprofit organization  that has about 105 members that cycle in and out, some are leaders in the group (9 board members, 4 officers, 6 area leads, etc), I want to have airtable data available to all registered members such as read only the member list and their contact information, and other people that can have access to member maintenance.  And each member would be able to update their own information (self help).  But with 100+ members, giving each an airtable account would be difficult to manage.But then I realized we have a wiki page that supports user management, and I might be able to embed forms and views in certain pages that require different access. I'm curious if any of you see a flaw with this idea, or if there's a better solution.Background: There's a free open source wiki product ca

Hello guys, I hope you are doing well. I was wondering if you also have this error? The letters are superimposed on the gallery cards. Could you tell me if it's a bug or if it's me?Greetings!