Other Questions

I have one tabled named “customers” and another name “properties”. One customer can be related to multiply properties. In another table called “Leads” I have a linked field named “customer” where I select the correct customer. I’d like to have another field called “address” where I’d be able to link to the “properties” table but it would ONLY show properties related to the Customer selected. Is that possible?

Basically, my use case is similar to authors and books they have written. the parent table would include information about the author, like name, age, etc. Each author will only have one row. The child table consists of books they have written and the book’s information, like copyright date, publishing house, etc. What I need is for the parent table to have in one cell( so not duplicating the authors) each of the book’s information, not just the name, the author has written and the parent table is updated whenever there is a new entry inside of the child table. if this was a database, it would be a regular Authors table with a JSON called books with each book’s information, not just the name, the author has written. I could technically do this using the airtable API but that would create too many calls as I would have to filter for each author

Hello, pretty often I use IPad to print documents from Page Designer. In order to do it I open my base in the browser/safari and go from there. After I hit ‘Present’ I make a screenshot (print doesn’t work giving me a blank page). Then I just print the screenshot. Works perfect. However the person with whom I shared my base (as Editor) don’t have ‘Present’ option. Only Print. Any ideas why it might be happening? We both have the same large Pro iPads, hers is the newest, mine is 2 years old. Thank you!

I’d like to combine three fields from three columns (Start date and time, Description, Duration). However I’m not aware of a way to format the "Start date and time’ so that it displays in a more user friendly format - I’m getting “2018-07-01T12:00:00.000Z “ I’d like to have “2018-07-01 T 1.00pm” for some reason it’s also saying 12pm not 1pm. This screenshot also shows the setup. The duration is also a problem displayed as seconds I think /60 /60 give 2.5 and I’d like it displayed as 2:30 or 2h 30m. I need to bring these into one column with a concatenate so that on another linked table I can rollup this information when I allocate multiple items/rows to a given invoice, so that I have all the ‘Start date and time’, Description and Durations rolled up for a given invoice. Thanks

Confirming that it is NOT possible to automate posts to Instagram from Airtable using the automation tool? Any workaround? Custom script?

hi. im trying to change the view with filter by api as i said. (outside airtable) i read the api document. and tried to “filter by formula” by airtable encoder. BUT as i understand it only support “GET records” which is not i want (to ADD filter in the view) is there a way?

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!