Other Questions

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

Hey there, I would like to show: Total Number of Vendors Defined as the # of vendors in each cohort. This lives on a tab called “Vendor - Main View” Total Number of those Vendors with Completed “AERs” AER Completion is defined as a date corresponding to the Step 27 shown here in the table named “Checklist v2.0”. (An empty cell implies the step is incomplete) The thought is that we’d show “Of the 12 vendors in the January cohort, only 9 of them have completed AERs” “Of the February Cohort, 2 have completed AERs”. Thanks in advance for your help!

Hello, i have set a password for my Form. I tried to open this url the first time and it asked me the password. I submitted the form. Then, i open the url again but now it did not ask for password. How can i prevent this?

Hello all. I use buttons to navigate between my interface pages, however when I navigate to a different interface (using a button) the URL opens in a different tab. Is their anything I can include in the URL to stop it from doing this or is this just standard behaviour? I guess I could create one interface for everything and that would solve it but it’s not how I’ve designed it currently. Thanks in advance. Dan

I am looking for a simple formula to compute hours worked. I have “Start Time” and “End Time” and am looking for a formula for “Total Hours Worked”. I tried one of the other formulas that I found on another post and was unable to get it to work with my table. If someone could provide me with a simple formula to add my start time and end time and output a total hours worked I would appreciate it!

I’m curious to see if anyone is having an issue with their IOS app reverting back to the view that was last used on their desktop? Example - On my desktop I’m using Base#1, View#1. Then go to my IOS app using Base#1, View#2. If I close my phone’s screen do some work. Then go back to the Airtable app, it will show a grey bar at the bottom that says “loading”. The app screen will blank out then go back to Base#1, View#1(which is what was on my desktop). It will also close the record I have open and revert back to the desktop’s view. The IOS app used to not do this. I’ve contacted Support and sent a video of the issue.