Other Questions

Hi everyone, I want to have beta features to share and embed blocks on other websites. It looks like they exist and I applied it from here(https://airtable.com/shrLK2dGvhx46S6bU) a couple weeks ago, however I haven’t got any reply yet. Does anyone know what’s going on with this beta feature? Do I have to just wait to access it? Thanks

Is there a way to set up Kanban table to provide notifications of a specific status change. I.e. provide notice to a specific Slack channel of a change from status X to Y, instead of any general changes to the status overall. Thanks

Hi, community, I’m looking for advice on a better way to organize my process for clients. (new to the process) Right now I handle this in two different bases but I’m hoping I can have all info in one. I have a client base then an inventory base. I work in the interior design/real estate is the industry. I have a client base that has the job description and address of the job that I do for a client, then I have another base that has inventory for the client and the associated address of the job. Is there a way to have one base that shows the following path: client “A” info then I can drill down to client “A” particular job via address, then drill down to that addresses inventory sheet? I hope this makes sense. It seems silly to go to one base and put in all the details for the client except the inventory (which is done in another base) I’d love to handle it all in one if it’s possible then I can see all details for each client. Client “A” hired me to do “x” job then “x” job

Hi all! Working on a project where I have different tables: Events People I create an event that has a start date and an end date. After creating the event, I add the event team by adding team members (table.people) to a linked field. In order to see who is added to an event, I would like to create a Gantt view that has the following layout: Event shown from start date to end date When collapsing the event, each team member is shown separately, also with the start and end date I cannot seem to setup this view. Got as far as displaying the Gantt with the ‘full team’ (showing all team members linked to the event in one field, instead of the team showing separately). Is there a workaround for this?

Please explain the Revision and Snapshot History to me. Does this mean that in the free version, any changes that I make to my records will be lost after 2 weeks? I am using this (or hope to) to track gardening, i.e. name of plant, location, when planted, attaching picture and tag info, etc. just something simple. I’m just concerned that if I update the info with new date and such that they will disappear after 2 weeks. Is this the case?

I have a table of subtasks called subtasks. this is the todo list for the whole team. I used self-linking to get predecessors setup, and so I have: a rollup field showing the predecessor end date (PredEnd) a manual task start date (START) a manual task duration in days (LT) a formulated task completion date that adds the task duration in workdays to the start date (END) What I want to do now is create a scripting block that can load all the records in this table only, and compare each records PredEnd vs START, and if they are different, to update the START using the correct PredEnd value. But I keep getting errors and this is my first script… no idea what im doing… let table = base.getTable('subtasks'); let field = table.getField("START") let predEnd = table.getField("PredEnd"); let taskStart = table.getField("START"); // Load all of the records in the table let result = await table.selectRecordsAsync(); // Find every record we need to update let replacements = []; for (let record

Where is the “undo” button? I don’t always do everything right. Of course, there should also be a redo function, as well. Thanks!

I manage base full of events that can be displayed as a grid or calendar Each event at least 1 tag (for example: event-movie tag-fun, event-yoga tag-sports) I’m looking to create a few different iCal links from this base Each link will subscribe to events contain only one tag For example: iCal link that shows only sports events Can it be done? any recommendations?

Currently I have a form, where I want to be able to limit the options in a single select, based on the option selected in the previous single selected. My example is: I am a rock climber and use a Airtable to base to log all my routes. The first single select in the form is for the style of climbing, eg sport, boulder, etc. I want the next single select (grade) to show different options, depending on the style of climbing, eg the sport grading system, the bouldering grading system. I don’t know if this is possible, but any help is greatly appreciated! Thanks!

Hey, Im only doing from Zapier using Airtable Find records as a action. My question is: What happens if 6 People at the same time request data from Airtable with Zapier Find records. Wille the first 5 go through without any error and only the 6th call will be an error? If yes what happens if I activate the Autoplay in Zapier for error Zaps in my Zap task history? Will it retry with Zapier to find record couple of seconds later and will it then be working?

Is there a method to check/un-check a checkbox field for all of the records in a base?

Following is how a formatted SendGrid email message appears in email. {Current Date} Friends of Niños Adelante, Inc. PO Box 1624 Sonoma, CA 95476-1624 Alejandra & Todd Hinkie 46 villiage Way PMB 167 Port Ludlow, WA 98365 USA Dear Alejandra & Todd, Little did we realize when we welcomed the first few students into the college beca program for the 2005-06 school year that we would be supporting 100 students in college by the fall of 2020. Thank you for your involvement and dollars which are truly making a difference in the lives of many in Zihuatanejo young people. Each year Friends of Niños Adelante utilizes general funds to cover students whose sponsors are unable to meet the total beca amount or have had to drop out of the program (approximately $10,000 this year). Our commitment, of course, is to provide full becas for all students who qualify. Since all the contributions for becas from our sponsors go to the kids, we need to be able to have funds for special needs situations

I am trying to set up a user log-in page in Adalo but where the Adalo DB lets me chose between Create a User, or Log-in a User. I am only allowed to Create a User using Airtable as my DB. I can add a Log-in action when connected to my User Table in Airtable but I am unable to remove the Create User Action so every time I try to log in it creates that same user again… What am I doing wrong? Thanks in Advance, Richard

Hi, the number of views on our airtable base is getting very unwieldy. I’d love to be able to see who created a view in order to check in with them and determine if they’re still using it or if they could make it a personal view. Is it possible to do this? Thank you.

Still putting together a Base to track my Fitness Instructor business. I have tables for Client Names, Classes Offered, and an Income table that tracks which clients attended which classes and how much each paid for each class. I also have Assistant Instructors for each class. There is one Assistant in each class I teach, but it can be any of 3 different people. I track who the Assistant was for each class in the Classes Offered table. Assistants are paid a percentage of the total income from that class. Now, with these 3 tables, I’m at a loss to figure out whether or not Airtable is able to track how much each of the instructors is owed (total and per class), and if Airtable can also track my payments to the Assistants, and keep a running balance of each of their “accounts”. I’ve not found any examples of Airtable being used for accounting tasks, so I greatly appreciate any help in determining of Airtable is the right tool for the job; OR if it is, some assistance in designing the Bas

Microsoft copied Airtable? See this Microsoft Lists walkthrough (a new app announced today). See how similar the mobile app is. Also, the conditional formatting and card views.

The Web clipper block has an accompanying Airtable web clipper Chrome extension. I would love to try it out, but I haven’t dared to yet. To be able to install the extension, you naturally need to accept the set of permissions it requires to operate, but with the current set of permissions it asks for, Airtable gets access to absolutely everything in my browsing history, including all the content in all the tabs, online banking, web based chat apps, etc. I might be mistaken here, but from the description of features that the web clipper enables, it sounds like it would only need full access to the current tab that the user is on when they invoke the extension. The API for full access to the current tab is available at: https://developer.chrome.com/extensions/activeTab. Is changing to use that permission something the Airtable team would be open to?

Hello, I am looking to display the current time in different countries in a single column, corresponding to their entries. I have three columns Person name, country, Current time in-country. This is the desired output & has been created manually. I want to automate this process. Thank you

Hi, I am wondering if it’s possible to have personal/private fields. We track all of our campaign scheduling/planning through Airtable + reporting and revenue. What we now need is to calculate commission per sales person for each campaign record and have this information be private/unviewable to the rest of the team. Is there a way I can create a field that can only be viewed by specific users? Can it be done via a locked/personal view maybe or would this person need to create their own private base and then copy and paste the information across to it? Thanks, Rachel

Hi all, I am looking to auto populate a date that has been calculated via a formula from one table, and add it to another table / sheet. Date Due in Table 4 to Date Due in Pre-Launch Any help would be greatly appreciated! Thanks

Hi! Using the Summary Block, Under Summary Type, we will be able to get the sum of the deals we have won. However, what we want to display on the summary block is the amount needed for us to achieve the goal for the year/ month. Is it possible to display $X - instead of just ? Thanks!

Hey there! I’m still relatively new to AirTable, but I have grand plans. I’ll try to explain this simply, if I can. I have a table full of a list of rooms that I provide support to. These rooms have equipment in them that needs to be refreshed occasionally and relies on standard packages to do so. These packages often share several items across them, but sometimes in different quantities. What I have figured out: Created the table with a list of items and I can link those items to another table that brings in their summed costs in the form of a package. Link those summed costs to their room on another table. Here is where I am stuck: I cannot increase the quantities of items without it affecting all the items across packages. I cannot seem to export the final list of equipment in any meaningful way. I tried looking at the “Product Catalog” template, but nothing immediate jumped out as a solution. The only way I’ve been able to make it work is to create a new table for each packag

Hey there, I’m hoping to create 1 “exported” word doc from Airtable using Formstack. I need to use information from multiple tables within one base. I understand that Formstock requires all information to be exported from 1 table, so I have created linked fields. As shown below, my “Vendor-Main View” contains ALL information I’ll want to include in a pre-formatted Formstack document. I’ve linked cells from Documents/Interactions, Brand Analysis, etc to Vendor-Main View and created lookup fields. Here’s my issue: It doesn’t seem like Airtable is able to attribute cells to specific fields. For instance: In my Documents/Interactions tab, I have check marks next to AXA Analysis/Line Review and Items have begun selling. I also have an attachment on AXA Analysis/Line Review. When I link those records to my main doc, it just shows up as two check marks, rather than a check mark (or attachment) associated to a specific row. It should be able to show the check mark / attachment / date/time of c

Continuing the discussion from Autofill Task Dates Based on Project Due Date: Can anyone explain how to do this calculation within the script block for record templates? All of the scripts have the user putting in a start date with the task objects being created and calculating the end dates (probably explaining wrong). I am using the PM Script Block 1.2 as my basis for making my template, but I want to do the opposite date calculations with: End Date: user input Days Out: field filled in already Start Date: calculated I am new to script so any ideas, direction, or specific help would be appreciated.

I just started using Airtable as a project management tool. I have multiple employees with multiple projects occuring at the same time. The next step is to build something that can take these estimates for our projects and drive out a capacity forecast. We need some assistance with rolling up the hours estimated between the start and end dates for our projects, allocating those hours to our employees, and then visualizing how much capacity they have vs how many hours they have been assigned to. Does anyone know how to create this field to an existing Project/Task/Team table?