Other Questions

Hi, I’m an Airtable Newbie. At work we are setting up an inventory of our items/assets to be checked in and checked out of our warehouse. We have an Asset Management Base set up and populated. The individual inventory records are barcoded as well. What I’m looking to do in the same base, but under a different table, is run a check in/out list. Ideally we would be able to use the Airtable mobile app > open up the base > go to our check in/out table > scan items in or out > have the table automatically fill in the designated fields. At the moment, I don’t see anyway to do this, other than scanning the barcode and then manually linking to an existing record in the Asset Management table. Any help/advice is greatly appreciated. thanks

I’ll like to share a table with a partner. The table should be synchronized automatically as soon as a change is made. Thanks.

Hi folks I’m having an issue with the Charts app. I’m setting up a simple scatter chart with x and y axes drawing from formula fields in my base outputting a percentage and a decimal, respectively. After initially setting the axes, the plot works nicely, and when I rollover the data points on the chart it shows me the points measurements alongside the primary field data for that entry, identifying the point. My issue is, when I then go to group the points by a third field (using the “group by” toggle in the chart’s Y-axis settings), while the grouping displays on the chart correctly, when I rollover any particular point the primary field data that appears on the chart is for a completely different point. Though, when I click on the point, it does bring up the base entry for the correct field it is supposed to represent. Am I doing something wrong here? It seems like a bug to me, and it reduces the usefulness of the charts app quite a bit for me. Would appreciate any and all feedback! C

Do you still have to manually go in and delete each record from every table in a template? That is an almost impossible task. Seems that every other SaaS that does something similar to airtable has a template data delete function… Was hoping Airtable caught up to the times as this is why we did not use them before

Hi. I am fairly new to airtable. I am trying to represent my marketing data on a chart, but I cannot get the chart to represent the way I want it too. I want it to show the $ amount on y axis, months on x axis and then a stack for types of marketing. How do I make this work. Thanks in advance

I have a table in my base that captures information about tasks and what person they are assigned to. The field with the person’s name is a linked filed to another table that captures information about them and their company like contact information. Since we have multiple people working for some of the companies, I would like to create a lookup field for my task sheet that shows which company they are associated with. However, since the table with that information is linked —> that way, it isn’t showing up as an option when I try to create a new lookup field. Any ideas on how to fix this? I tried to write an automation, but because these records have different IDs, I can’t figure out how to get it to write back to the correct project. I also tried to do another linked field that read <---- from the contact information sheet to the task sheet, but it just started to create new records when I put the information in.

I have a scheduling base for Volunteers helping at Non-Profits. I am wondering if it is possible accomplish these with a formula? I have attached a generic base to give you an idea of what i am looking for. I have entered the answers into the fields as an Example via text. #1. Volunteering with - If multiple volunteers are on the (same date, same location, same start time, same stop time), I would like column " :raising_hand_man: Volunteering with :raising_hand_man: " to show the names of each volunteer on the same detail. #2. Double Booked - If a volunteer is signed up for multiple details the same day I would like a column “ :eyes: Double Booked/Overlapping Shifts :eyes: ”, if they are double booked or have overlapping shifts. #3. Relieving/Relieved by - I would like two columns " :handshake: Relieving Volunteer :handshake: " & " :handshake: Relieved By Volunteer :handshake: " to list the names of those volunteers if applicable (ie. If one shift ends and another one

Is there anywhere recording of this webinar? I missed it and there aren’t any available slots anymore. [Live training: Introducing Airtable Automations(Live training: Introducing Airtable Automations)

Hello, I am in search of an API to manage the shares of tables and bases. The idea is we would keep a permission list (potentially the list would actually live in airtable, but this shouldn’t be relevant to the ask) and be able to verify that the airtable permissions currently in force are those that are recorded in our separate source of truth. We are a nonprofit organization that uses Airtable heavily for our day to day but care deeply about information security as well. Part of the problem is mitigating the spread of share links, direct individual shares by members, and non-expiry of shares for members who are inactive in our system. It seems that there is no such API available. I could use webscraping to simulate what happens in the web UI, but obviously this is suboptimal. As Airtable’s adoption rises and our organization grows, I consider this a critical issue for our continued usage of the product.

Hi - just staring out with Airtable and wondering if anyone knows how to do the following. I have a table that is collecting a variety of meeting requests at my conference, and have 3 different forms which are collecting requests from different audiences. For each of those forms, there is a date selection of what day they want the meeting to take place. Is there a way to limit what dates they are allowed to choose? I don’t necessarily want to use a single-select field, because I want to be able to use my calendar view for the table to plot out what dates the requests are for (assuming I can’t do it if it’s not a date field). I also need the ability to limit the dates to a range of 4 days for some of the forms and only 2 days for another form. However I want it to be the same field to avoid having multiple columns of event dates. Is this possible in any way? Help appreciated!

Hi there, I want to set up a simple system to plan/manage staff utilisation. Does anyone have experience of doing this? We have a small team and our goals are to track allocation of staff time against projects and prospects in order to get an over view of work load, spot where we may have more work than time and need to bring in additional resources, identify spare capacity where we have opportunity to bring in extra work or shift overflow. Any ideas?

Hi, is this possible? Thanks for your help.

I’ve upgraded my Mac to OS Catalina this weekend and Apps stoped working. I’ve re-installed node and npm to the latest version and tried to install a “Hello World” App and after running the command “npm install -g @airtable/blocks-cli” couldn’t continue because the terminal said block command is ‘not found’. Any tips, please?

Hello, I have seen similar requests posted on this forum for things like a “dashboard” view of data from various tables but some of the solutions are not well documented, so I am asking this question again. I have 3 tables: Proceeds, Expenses and Income On the proceeds table I have aprons and cookbooks which are currency columns that - of course - give me a total sum on each column. On the expenses table I have a misc. column (currency) which gives me a total sum at the bottom. On the income table, I am building a dashboard so that I can see the total cost of my expenses from the expenses table and the total sum of my proceeds from my proceeds table. I then want to simply have a formula column that subtracts the two so that I have a snapshot of what my income is currently. The way that I have achieved this so far is to create a link to all records on the income table in both proceeds and expenses. Every time I add an expense or proceed record in one of those tables, I simply populat

Hi, I am looking to change our current media base to Airtable but have one question that I can´t seem to find an answer for. We have over 300 dealers in different countrys and I need to know if I can create a account for every dealer with different access. We have 6 different brands and some dealers sell all brands and some just one. It is very important that I can specify in their account what folders they have access to. Is this possible? Regards Per

I’m trying to work out how I can have different members of a team view a spreadsheet of ideas (each row is an idea) and have them each vote on whether they like the ideas. I want to then show an updated tally of the number of votes each row gets. I was thinking maybe I have a multi-select column with the names of each team member. If you like an idea you add your own name to this selection. I’d then want another column which is a number, which I was thinking I could have a formula to count the number of items selected in the multi-select field. So I’m not sure what formula would work there. Or if perhaps there’s a better way of approaching this? Thanks.

SOLVED: SEE POST FROM KAMILLE I have a database of students in Uganda and I am building a separate table to help the administration track student temperatures (government requirement for school re-opening). The table is simple and the nurse will use a basic form (Select student name, enter date/time, enter temp). In the Student table, I’d like to add a field that shows the most recent temperature taken and the date. The Rollup field works well for the date using the MAX(values) aggregation formula, but I can’t figure out how to show the most recent temperature (as opposed to the max or min). Any suggestions on how to show the most recent number added within a set of values? I’ve seen a few other posts on this, but I couldn’t find a clarification. I realize the “Most Recent Temp” field in my screenshot is a text field. I’ve placed that there for illustrative purposes only until I can figure this out. Thanks, Dave

Hi there, I’m trying to create a grid that compares values from two columns, like the preview thumbnail for the chart app. Other forum posts have said this is impossible, but every thumbnail in the chart app shows comparing multiple values. So either it is possible, or the thumbnails are purposefully misleading. Any ideas? Compare columns in chart Compare columns in chart

We are managing all our orders in Airtable and I’m trying to calculate the time between orders to get an average for each customer. So a client orders, say on September 13, and then the same client orders again September 19 and September 25. I’ve been trying to figure out a solution, but have a hard time. How can I calculate the datetime_diff between records in the same table? Thanks a lot!

Hello! Has anyone managed to create a workflow that generates a pdf from the document creator using a code step and attaches it to the record? I’m looking for ways to automate document creation based on a button press, or programmatically, and I’m not seeing any option without using other software…Which is frustrating, as it feels like Airtable is SOOOOOOO close to what I need

I have a Zap that includes running Javascript in response to a trigger. Specifically, when a record enters a view in the project table, the zap adds tasks for that project into the task table. Here’s what the Zap screen looks like for the Run Javascript action: Input Data csString 1. Task Record IDs: record id…record id… Code //this code is required to turn the string containing record IDs into //an array of objects. Because the output is an array of objects the following //steps will run for each record found. if (inputData.csString == null) { var listArray = ; } else { var listArray = inputData.csString.split(","); } var output = ; var arrayNos = listArray.length; var i=0; do { var thisItem = new String(listArray[i]); var thisItemObj = {}; thisItemObj.record = thisItem; output.push({thisItemObj}); i++; } while (i < arrayNos); I’m trying to recreate this Zap using Airtable automation. Step 1, of course, is the trigger. In Step 2, I chose a “run script” action. I pa

Hello, We have an Airtable base set up to receive information from JotForm. The form will collect emails from every submission; sometimes the submission is missing components to make it a complete application. We would like to notify this customer, with the incomplete application, what is missing by sending them an email copy of their record. If we right-click and select ‘Send Record’, the way bottom part of the message has a ‘View in Airtable’ link. We can not send these to the customers because they will try to request access to our workspace. Is there a reliable way to send a single record to a customer without having this link embedded? The SendGrid app only appears to be able to send to whole columns, and it just seems tedious to single out a record, enter it into a view, and send the email that way.

I have 3 tables: Units - a list of all our technology units whether classified as inventory or leased to a customer Customers - linked to the Units table Unit Setup - this is a form to be used by the shipping department to go through shipping checklists AND assign a Unit to a Customer. I cannot figure out how to get the Unit Setup Form to update the Unit assigned to the Customer. I can get it to add a new linked record column… but I want it to update the main associated Customer record to the Unit.

Hi! Yesterday evening my SendGrid Airtable app stopped working. I would get an error sign after clicking send and no explanation. After a day of lots of testing, I was able to figure out that what’s triggering the error is that the email template contains more than 8,000 characters, including characters created by merged fields. That’s so little for an HTML email…! I don’t want to go back to plain text, and have so many templates that I use… Has anyone else ran into this issue? Any workarounds? Thanks so much!

I have a master media list set up as a relational database in Airtable. I now want to create individual lists from the master list for each of my clients. I have considered using ‘Views’ but if I delete a contact in one view it will delete the data in all views. Is there an easier way to achieve my goal?