Other Questions

Bonjour, Je voudrais additionner une date avec une durée (Date de début + Durée = date de fin) ma durée et comprise entre 1 minute et 10 minutes (ex 20/02/20 15:30:00 + 00:01= 20/02/20 15:31:00) Merci de vos idée et vos réponses

Here is a sample Airtable Lookup Test - Airtable Explore the "Lookup Test" base on Airtable. I would like Jobs::Total to show a sum of the Hours::time when Jobs::Work Order matches Hours::Work Order. How can I do this without manually linking each hours record? Thanks

I have Airtable integrated with a third party app, where all data collections automatically flow into Airtable. Two main fields that get loaded into Airtable are a user-entered Date and Time. I’d like to create a third formula column in order to add these two together to get a Date & Time Airtable field. Does anyone have any suggestions on the formula to use here? I’ve experimented for days with no success. Thanks in advance!

I am new to Airtable and I am setting it up to use for cataloging a personal collection. The PC version is working great but I am having an issue with setting filters on the Android App. Nothing happens when I hit “Enter Comparison Value”. Help!

I have create a simple BASE in my Airtable account. I now wish to use this within my website project. Therefore, I have generated an API key via my account page. Next I have visited REST API - Airtable then selected the BASE I have created. In my project I will be using the Javascript method to pull in the data from my BASE to my website. Within this Javascript I can choose Show API. However, as this Javascript contains my API key, I am concerned that it need to be set as Read Only. Therefore, I have visited the following article: Creating a read-only API key – Airtable Support to try and find out how I ensure my API key is set to Read Only permissions. This is where the documentation isn’t very clear or understandable. This article states, on section3, “While logged into your personal Airtable account again, add this new account as a read-only collaborator on the base that needs to be accessed with the integration you want to configure”. This is the bit I am confused about. Add this n

Hi, I’d like to create a line chart that tracks my progress in writing a book. My goal is to write 90000 words in 180 days, which is 500 words a day. I have the Y axis (# of words) already set, but I can’t seem to figure out the X axis (see image below)… How can I complete this so that when I write my 500 words in a day, I add it into Airtable and it shows me progress towards that 90K word target? Any help is greatly appreciated. Thanks!

I am trying to automate a membership application form for a society that I am member of. I would like to embed the membership application form on a page of our society webpage, then when some fills out the form and submits it. The form would then automatically be sent to the board members for approval, and once every board reviewed the application, they would submit and it would be send the form back. Once the form gets approved by all board members the society would then have it’s online PayPal link sent to the applicant for payment. Once the applicants payment is sent and received, the applicants information would then be uploaded into our membership database. Once all that is automatically taken care of the one membership view (Active View) would be automatically uploaded to the membership list on the society webpage. Any help that anyone can provide would be awesome. Thanks, Zane

Can Forms have Pages… Multipage Forms for more complex forms?

Hello AirTable Community! Just starting out with AirTable and not very strong on the scripting side, so need some guidance. I have a table called Agreements, with columns; Client, Start Date, End Date and Amount. I’d like to create a Table (then a graph) showing the forecasted monthly revenue based on this data. So just a list of Month/Year with the Sum Amount. Hope that makes sense and thanks in advance. Chris B

Hi there! so we are a property management company and we have a Base for our portfolio. the first table is Properties and it has all of our properties: i can sort by view, filter, etc to get what i need My issue is that I have a checklist that i need to go through everytime i buy a property (water on, gas switched, cert approved, etc). I don’t want to add these columns to the Properties table since it is already so many columns. can i make a new table in the same Base and call it “Checklists” whereby it pulls all the properties listed from the Properties table? i don’t want to duplicate and have to type in properties in both tables. hope that makes sense!

Hi ~ I’ve been using AT for a couple of years now, and this is the first issue I’ve run into. When I go to form view, and upload a logo and/or header image, it will not show up (header) or appears “broken” (logo). I’ve tried all of the suggestions in help… what to do?! Crisis for me as I use the forms frequently. Thanks in advance!

I desire to reorder attachments from different table. Let’s assume We have .inc table like company A,B.etc. Besides, We also have financial statements table like A’s F/S 2021, A’s F/S 2020 A’s F/S 2019. etc. When I apply lookup, ideally attachments should keep their order following year. However, the attachments become messy like A’s F/S 2020, A’s F/S 2021, A’s F/S 2019. In that case, how can reorder it?

Newbee to automations here and would like to hear if I’m doing this right because it feels wrong :slightly_smiling_face: I added a couple of automations which change a status field based on conditions. So as “Action” I select “Update record”, select the table and record ID from the trigger. But then when I add the fields to be changed and I select the “Status” field (which is a Single Select field type), I just get an free type text field instead of a dropdown with the labels/options from that Status field. This seems to work fine as long as I type in the exact words/phrase used for the single select options, but if somewhere in the future someone changes the dropdown labels/options, this will then immediately break the automation without any kind of warning. (well it wouldn’t “break” the automation in the sense that it would still run, but the automation would just keep using the old label which could cause all kinds of unintended things). So… Is this indeed the way to create these

I have a table of tasks. Each task has a due date in a date field. I want to create a new formula field that looks at the due date and spits out: Upcoming Due Today Past Due Extra credit if the formula can spit out “Due Soon” when a task is 2 days away. How do I make this happen?

Hi, I would like to know if there is a way to tackle the issue when a end user clicks on “Download CSV”, I would like to lock/ block the user from downloading the attachments type column as the CSV file captures URL links of all the attachments from the table. Thanks!

Does anybody know why the plus shaped “Add New Record” button, only sometimes shows on a table? On some tables it is there: And on some pretty identical tables it is not: I thought it might be to do with sorting, grouping, table permission, width of table. But they all seem to vary leaving me feeling like it’s totally random. Does anyone know the anwser to this mystery? Thanks Matt

I feel like I must be missing something very simple, but I have a grid view with an Email Address column, and it is sorted by that column and only that column. For the most part it looks fine, but Email Address ‘psmith82…’ is sorting ahead of ‘psmith11…’. Anyone else noticed anything like this, or have any suggestions? Thanks!

We have an order management system that provides drivers their order delivery information in custom views. We have around 20,000 records in the Base now and unfortunately multiple drivers simply get a blank screen when they select their views. We’ve cut down the data set already and need to find a way to either get the app to work or to export views to something more reliable. Drivers are using their own iOS or Android devices. I don’t have the specs for each so I’m really hoping a “mobile” solution can work across multiple devices. Right now, not so much.

Hi all, I’m trying to use an automation to send a weekly summary of items that have deadlines in the next two weeks. I have a Trigger and a Record Lookup working beautifully, but the only option I have to choose a list of records formats them as an HTML list. This works OK for an email, but doesn’t work for a Slack message. Is there any option to reformat the list of records in a Markdown table, rather than HTML?

Hi, I’m wondering if the following would be possible with Airtable without creating an additional app to handle permissions. I’m needing to have one primary database that I can filter by a column like Name, then share that filtered view and have 2 of the fields be editable and synced to the base. As I understand it, any linked view is not editable; however, I could do a synced view and add 2 columns to the new table, but it wouldn’t update anything in the original base. Thanks, Keith

Hi all- I’m attempting to use airtable to create a schedule for a summer academic program. I really need a field for start time and end time of the class/workshop. I don’t mind having a separate field for each, but I’d like to be able to group by date and sort by time to get a daily schedule. I can’t figure out how to do without a field that allows time without date. Am I missing something, is there a workaround that accomplishes the same thing? Thanks!

Hi everyone, I am currently trying to move data from Excel into Airtable. As users have mentioned in previous posts, when I do this, the data copies over without the link. Right now, I’m not importing and instead just copying/pasting (importing messes things up with this file) from the Excel file into Airtable. How can I retain the links? Would this involve the ‘Button’ field? (The columns will be, for example, a list of recipe names where each name links to a different recipe) Thank you!

Has anyone added an IMDBpro API key to their base? I’m copying individual IMDBpro links but would love it is it would regularly populate my database with new information. Thanks! Jessica

I have a “Start Date” field and a “# Duration (days)” field and would like a formula that calculates the “Due Date” in work days. I tried this formula from a YouTube tutorial: IF(AND({Start Date},{Duration (days)}),WORKDAY({Start Date},{Duration (days)})) But if I enter 2/15/21 (a Monday), and add a Duration of 10 days, the formula shows 2/28/21 (a Sunday) which is not a work day. Is there something missing? Thanks, Kevin

My company uses Airtable to compile lists of resources or organizations in specific metro areas. We are interested then, in understanding how long it takes our team to extract each full record (10~20 fields per record). We’re hoping to get a better picture of knowing how long extractions (filling out the entire record of 10+ fields) take, and running analysis on which specific fields or tags are associated with longer times (harder to extract?) or shorter times. The Time Tracker App is somewhat useful, however I am wondering if there is a way to see how long each cell is being edited. So basically each cell has a distinct timer/counter attached to it, and then a field that reads the total time spent working on that specific record. Any thoughts?