Other Questions

Hey Community! I am working on multiple DBs for integrating clients into a shared DB universe. I am working on a menu ordering system for a ghost kitchen. Is there a way to update the form UI to include the relevant information from the record. Right now for an external user it only shows the formula ID(menu category, size, price) It excludes the descriptor and other relevant info we may attempt to include (photos from a gallery view) Any advice? Cheers

I want to sync two tables to another base. If I sign up for Pro and decide to go back to Plus or Free what happens to my data? In the destination I would have two synced tables and one other table. In that third table, I would be linking data from the sync tables. Will the data in the 3rd table that came from those synced tables disappear if I downgrade? Or will the sync tables still be there with data, just unable to sync anything new to them? Thanks, Stacey

Hi there, I am trying to set up a system to make a primary field that references unique case numbers. We do the cases by year, so for example, the first case of this year will be 2022001, the next one will be 2022002, etc. But, we want to use the same table from year to year, so ideally I will have a forumla that pulls the year the record was created, and then adds a 4-digit autonumber. Then in 2023 we will automatically start with 2023001, etc. Any help/advice is greatly appreciated!

Hi everyone, Is there a way to calculate the days between records? For example - I’m tracking workouts and want to promote daily activities by tracking streaks. Therefore, I need to calculate the days between each record entry. This was my google sheets formula =IFERROR(DATEDIF(A1,A2,“d”),"") but I’m not seeing any way to compare two dates from two different rows of data. Thanks for your help, I’m new to Airtable and after some searching I could only find solutions that leveraged data from the same row vs. 2 individual rows. Anastasia

Hi everyone. I have a base with multiple tables. The first Table is a Masterlist with records of names, job titles, affiliations, and contact information. The rest of the tabs or Tables are personalized versions of this Masterlist, which link names back to the Masterlist using Linked Records. I want to share each Table with the client they have been personalized to, but when I send a link to just the one table, the recipient can’t expand the linked record to see the contact information. They only seem to be able to see the linked record if I share the whole base, which I can’t do, because other clients’ information is in the other Tables. Any ideas?

I’ve imported a CSV where one of the columns contains 2 dates. Like this: 8/23/21 - 11/6/21 In order for me to create a time line I’m thinking I need to create 2 additional fields (one for each date). I know I need to use FIND to tell the formula to find the “-” and work from there, I just don’t know how. Can some one please help me?

Is it possible to copy a record in one table along with all dependent records in other tables including any further dependent records in further tables?

Hello, I’d love some help refining a Zap such that it: Copies a text string from an Airtable formula field to an Airtable URL field, and THEN goes to that URL (which is a hard link to an image) and uploads the image file back into an Airtable attachment field. The use-case here is barcoding. We have a formula that is dynamically generating image URLs to barcode images. The links work fine, but I don’t yet have a way of actually pulling and uploading the barcode images we’ve linked to. Any/all help appreciated, THANX!

Hey there, Is there a way to multiplyer an array of number to a constant or variable. I have all my item with a default quantity on a table like so : I’ve created group of item so I only have to add one group to list of the items with their default quantity (to prevent errors) My problem is here on the packing List, when I want to be able to multiply the default quantity per Tower I need but I can’t figure out how to do so. How to multiply an array with “Tower needed” ?

I’d like to move my base currently running on Wrike to Airtable. Exporting/importing my records is easy but I’m concerned that I have 1,000 attachments in my Wrike table and no obvious way to save them all at once. Does anybody have an idea? Thank you in advance for your help.

Hi! Quick poll here: Do you use Cmd or Ctrl + Y for redoing? Yes or no? I mostly use Cmd + Shift + Z, and because Cmd + Y coincides with the history shortcut on Chrome, I end up redoing actions and running into problems because of that. My vote would be to keeping the Redo shortcut only on Cmd + Shift + Z, but maybe there’s a ton of people using Cmd/Ctrl + Y out there… thanks!

Hello All! Sorry for the extremely general topic… but I feel like I might be missing something… I have a team of employees and we work in a distribution business. I am trying to create a unified platform so that my employees can enter information regarding quotes and pricing. I am somewhat familiar with database structure, so the mechanics of creating the application are fairly clear to me. The piece that I feel I am missing is this: Is there a way to create a user-friendly input method without giving users access to all of the backend mechanics? My concern is (from past experience), users will tend to enter things in the wrong fields or overwrite data accidentally. Other applications I have used (AppSheet, most recently), separate the backend data from the UX components. Is there something similar with Airtable? Do I need to use a 3rd party application in order for users to enter / interact with data? I have tried using the “Interfaces”, which are very nice, but my understandin

Nice to meet you all. I’m sorry if something similar has already been posted. I am managing a membership. Members are assigned a date of registration and a rank. Both are set manually by me. I am required to create a report every month, but I don’t know how to calculate it automatically, so I consume my own time every month to create the report. I would like to be able to collect the numbers needed for the report as automatically as possible. [1] I would like to automatically track the number of new members each month and use Interface Designer to represent that number. Currently, I have a table for the number of members, and I calculate and enter the number myself. I am already using formulas to get months out of dates. DATETIME_FORMAT({Date},'YYYY-MM')=DATETIME_FORMAT(NOW(),'YYYY-MM') [2] I would like to automatically keep track of the number of members per rank each month and use Interface Designer to represent that number. Currently, I have a table of ranks, and I calculate and inp

I have a CRM and on my Interactions table, I want to be able to create an Interaction and select multiple contacts on a record at the same time. The linked record allows linking to multiple records - I can select records one at a time, but this is taking time. I cant shift-click or CTRL-A to choose multiple records. The use case, is if I send a promo email to all my contacts, I want to have one interaction with multiple contacts. I have been looking at this for hours, can’t figure it out. Any help appreciated. Thanks

Hi folks, I’m trying to create a page designer app which includes a couple different single-select fields. There’s no issue with fields that are entered directly on the view that page designer pulls from—those show up correctly styled as they appear in the airtable grid view, with the rounded bubble & color-coded background. However, any lookup fields consistently show up in page designer as plaintext, even though they also appear with that same bubble styling in the grid view. Is there any way I can get page designer to render these lookup fields with the same bubble styling as well? Or worst case, can anyone think of a good workaround where I can “hack in” some similar color-coding via formulas/etc?

I will try explain my case. I own a theatre school I have a base to manage the interation and publication on social networks through integromat. I got another base to manage my current students in which i have their IG nicknames. I got another base to deal with marketing contacts in which i have some of their IG nicknames I want to have a synched table on the social network base with all the IG information i got from students and marketing contacts in orther to mention them in a proper way on my social posts. That is easy. This can be made trhough a synchronization from several resources what is possible now. However, sometimes, i want to mention a nickname which is nor a student neither a marketing contact, so i would like to add manually this type of records. This way i would have to use only a link to another table field to include every person i want to mention on a post. Is there any way to do that?

Is it just me, or has anyone had mini heart attacks when almost clicking (or actually clicking) the erase button when you meant to download something? Could I get a thumbs up to request this changed from @Airtable?

Good Day! I was wondering if I could get some help with a scenario: In the scenario a particular individual could have multiple records linked to them within another table. In the scenario let’s use contracts as an example. 1 individual could have multiple contracts with start and end dates, along with an attachment. In the “Master” table we can quite easily look up the Start and End Dates based on a MAX(VALUE), but my question is this: How would I go about linking THAT SPECIFIC contract to the given dates without showing all other contracts?

Hi Everyone, My team and I are planning on migrating our Project Management tool to Airtable. We have more than 2000 tasks, among them ~500 tasks that have a multitude of dependencies. We appreciate the Gantt view showing those dependencies. Unfortunately we have so many dependencies that the dependencies on the Gantt view are hard to digest and to work on, particularly for those that are showing as “invalid”. Is there a way to extract/highlight invalid dependencies into a separate table, view or even field? Or another solution (e.g. formula) to easily alert and/or track these invalid dependencies other than the red dotted arrows in the Gantt view? Note that the flowchart app is not meeting our needs: app limited to 100 records, records’ timeline not taken into account, thus no option to highlight invalid dependencies. Thank you in advance, Lucas

Hello, I have been building out an inventory system that shows all products, the amount of inventory and the price per product. Within the base, this inventory table is used to link to a transaction table that allows you to generate a transaction with multiple products with a total value. Following this, the transactions table links to an invoicing table where you select the transactions that were made and puts it all into an invoice with use of the page designer app. This process works fairly well, I’m not super happy with it but it works for what it needs to do. Where my issue arises is that we are constantly changing pricing on parts we sell and I cant change the pricing without changing past records. I cant change the past records because my company wants to use them to track all past sales. I set up a table to put all inventory received into the system. In the receiving table, you input the item and the price that you want to sell the product at now but I don’t know how to figure

I have the Pro Plan via a recent upgrade. Previously under this Pro Plan I added and used the Nobull app. Today I discovered that the Nobull app is deactivated. When I try to add it again, I am told “This app is available on the Pro Plan” and that an upgrade is required. I have encountered the same issue when trying to add another app. I understand that this post is a support request best sent via a direct contact to Airtable. I did so, but hoping for any comments as I await Airtable’s response. Thanks!

Hello everyone. (please excuse me for my English, I use Google Translate) I am in the process of making a small application to record my working hours with the Kodular site, and I am using an extension that allows me to use Airtable. Everything is going fine until I have to save some long text. It looks like this: 2100001 - Client1 02:00 task1 2100002 - Client2 04:00 task2 2100003 - Client3 03:00 task3 Etc … If I enter 3 lines like in this example, it saves the text correctly, but if I have more lines, then it cuts the text to me and it shows me “…” See for yourself with this screenshot: Is there an option to check, set or anything so that I can have all of my text in full? Thanks everyone!

HI I have 2 tables in Airtable. One si projects and the second table is Actions. I created a column in the project Tables in which I set a color. Actions are linked to a project (only linked to one project + lookup field to “color” from project table) I would like in the calendar view to set the color of the tasks the color of the project it belongs to Which seems not possible since for an action, I can only define a color in a single select field - color is not a single select field so no way to set my action to that color (that is not only for calendar, but it’s the same for Grid or other views). Is there a way to set the color of a tast, the color of the project ? Thanks

Hi! Here is the general idea of the process that I am trying to implement in Airtable: (1) a participant completes a survey and their results are entered into Airtable (2) the results from that participant are automatically plotted using Vega-Lite (3) the Vega-Lite plot is then automatically sent to the participant via email Setting up the survey in (1) is clear to me. For (2), I was thinking that this could somehow be implemented using AirTable scripts. I know that it is possible using AirTable automations to have the creation of a new record trigger a script to run. However, is it possible to have a script create a Vega-Lite plot using the data from the single record that was just created? My idea for (3) was to generate a url for the Vega-Lite plot, update the record in AirTable with the url in a column and then use AirTable automations to send an email including the url. The only parts of this process that I am uncertain about is whether it is possible to: -generate a url for a Veg

Hello! I’m in the Plus plan and trying to make an automation to email people on my table but there is a restriction "On your billing plan, you may only email collaborators with verified emails. " Does anyone know if the Pro plan allows that functionality? Thanks!! Adriana