Other Questions

hey everyone, I want to start using the comments on records but I’m hesitant due to the warning about only having 1 year of history. What does this mean? is it just revision history or does it include comments? Appreciate your time people

If I set a user as having view-only rights to a Base, can that user use the mobile app to view the data. The user would not be an AirTable subscriber. Thanks,

Hi, I created a shareable link for a grid view. However, when I open this link and expand a record, the comments are missing. Is there a way to include them? Thanks.

Is it possible to get the “Suggested Views” to stop showing in the sidebar? This takes up a lot of prime real estate. On my screen I can only see 5 of my many views :stuck_out_tongue: Also, I would prefer to have a single “Create a view button”, but that’s more of a feature request.

I am trying to make an automation that will send attachments from airtable using airtable automations when a record enters a specific view. I made an attachment field in the table and added the two attachments I want to send. I can get it to send an email, but cannot get it to actually include the attachments. Does anyone know if this is possible?

I’ve seen multiple threads on the discussion forums but no real solution around this. Here’s the use case with some qualifications in hopes of making my ask clearer: I work for an agency where we are using an AirTable workspace with multiple bases to work with a client. For the primary base both teams are using to collaborate, my team are all Creator/Owner level, and the client is all Editor level. The base has dozens of tables where my team is doing their work. That said, the nature of our work is such that we do not want to necessarily show the work to the client until the table is presentation-ready. I would like to be able to hide a table from the client team until I’m ready to share it and solicit feedback. My current approach is to just duplicate the entire base and keep it on a separate staging workspace, then once it’s done, I just copy and paste the records into the client-visible table. For obvious reasons, this can take away from the real-time collaborative benefits of ope

Hello, I am about to upgrade one of my workspace to the Pro Plan. I have a special discount for the Pro plan if I pay annually + an extra one (I guess I am a good customer). If I transfer the ownership in a few month and then change the credit card information, would the new owner will keep the same price when the plan will renew in Nov. 2021, or it will be back to the original price with no special discount ? Thank you for sharing your experience.

Hello, I am working on a form to allow a user to set an event that will be reoccurring for a given date range. For example, they need to submit an event that could be every Monday, Wednesday and Friday for 3 weeks. Is it possible to set this up in airtable? I am wanting to make a form where they can submit this reoccurring date range. Thanks!

I am encountering a problem with the pdf generated via the Gantt app. On the Mac it is no problem printing the pdf through the standard Preview app. But the generated Gantt chart is quite large, so I wanted to print it on several sheets, using Adobe software. In that way you compose one large image from different prints. Except… that Adobe does not want to print the PDF. Whatever I try, it generates an error message. Airtable support indicates that no issues are known with printing PDF’s, and suggests contacting Adobe. I’m trying to do so, but that is another kind of challenge :winking_face: Meanwhile: is there anybody who recognises this problem? This is everything we tried to make even a simple print using Adobe: Printing from Acrobat Pro DC results in an error ‘Unable to print document’ followed by an error ‘No pages selected for printing’ Putting de PDF in InDesign (16.0) for printing results in an error ‘Printing Error: Adobe print engine has failed to output your data due t

I live in an area with poor internet connection. I was wondering how much data I would need to use Airtable?

For especially sensitive data such as credit card numbers, it would be great to be able to add an extra layer of encryption (e.g AES) by encrypting that data before it enters an Airtable sheet/base from the API. I found an app called Encryptor from Integromat. Do you know of any other programs that can simply encrypt and decrypt text/numeric data through an API?

Anyone have the same issue? I can type maybe a few words and then it freezes. I exit and restart and maybe on the 5th try it lets me finish the comment and post. I am working in Chrome. Many colleagues are also in Chrome and have no issues.

So I have thousands of images stored as attachments within a base. Each record in the base has 1 image attached to the “Image” column I have created. When I export my base to a CSV file, instead of giving the URL it gives the internal image name followed by the url IN ( ). I can’t type out a url in here so I have attached a screenshot of what it is doing I can’t type out a url in here so I have attached a screenshot of what it is doing I need the raw CSV file exported to have a properly formatted URL: I can’t type out a url in here so I have attached a screenshot of what it is doing As a workaround, I am trying to create a new formula field next to the image column that uses a formula to delete the beginning and end of the improperly formatted URL. If I create a formula field and simply set it to = {Image} I can get that field to display the improper URL: Is there a way to expand upon that formula similar to a excel where I could maybe use a MID & FIND combo to format the resul

I used this guide to create my current setup. I am trying to take get a list of words that are unique across the “sentences” column as the “Word array Rollup).” So currently “Sentences” under the “Calc” sheet is taking values from “Sentences” on the “Sentences and words” sheet. The rollup “@WordArray” then creates an array from the values in that linked list. Finally, back on the first sheet I want to take unique words from the rollup “@WordArray” on the “calc” sheet. However, currently I am getting whole sentences.

Hi! I have a Lookup column that gets one or more images from another table. Now I need to get each image link in its own column. I already have the formula to extract the images URLs, but how do I get each of the URLs in a separated column? Thanks!

I use Evernote for daily notes of all activities for each week in one daily note. I use an Evernote template each week to start the process for the week and include various URL links to outside programs (i.e., Google Drive files, etc.) that I use regularly. I want to create a URL link in my Evernote template to link back to an Airtable base for call logging. I cannot determine a method to find or create a link for a specific Airtable base that I would paste in the Evernote template for regular use. Any ideas or best past practices? Thanks in advance for your help.

Hi, I am wondering if there is any way to display a single record with multiple dates in the calendar view? In the calendar view it says I can’t so is there any separate app or work around for this? What we’re trying to do is create a delivery schedule where our sales team will fill out a form which they put in date, name and select a delivery slot. For large jobs, they can select multiple delivery slots so that the delivery team is not overbooked on a certain date. But when they select multiple delivery slots, these count as a record with multiple dates so they don’t display. I checked other threads however they’re quite old now and wasn’t able to figure out a solution. Thanks!

I’m trying to figure out whether this is going to be possible, and would appreciate any pointers. I’ve been asked to set up a system to book fittings for protective equipment (COVID related). There are three constraints: Each booking slot is 30 minutes between 11am-5pm M-S (there is a definitive start and end date) Each booking slot can book access to one or more pieces of equipment (there are 180 individually numbered items in total). Once a piece of equipment has been booked it isn’t available to anyone else that day (they are re-sanitized at 5pm). Ideally the respondents would select the equipment they need, then be presented with dates where all of the selected equipment is available. I’ve seen a number of guides on creating simple booking systems using Airtable, but can’t quite wrap my head around how I could adapt these for use.

Hi! I’m trying to make a sign-up form for booking 3 different classes with 3 sessions each. So Airtable would have 9 sessions and 3 classes. The form would have 2 fields: the class and the session. The “class” (linked field) would be prefilled on the form based on the link it came from. But how can I make only the relevant sessions come up as options? In more detail: Class A: Session 1, Session 2, Session 3 Class B: Session 4, Session 5, Session 6 Class C: Session 7, Session 8, Session 9 If Class A is selected, is there any way to filter the options such that only Session 1, Session 2, and Session 3 show up? Maybe another linked field or multiple choice field would be best, though I’m not sure how to do that. Looking for a way to do this without making a view per class. My ideal would be to just have one multi-purpose form that I can prefill. Thank you very much!!

I’m trying to get a stock quote script to work for me. I’m not someone that understands scripts, but I think I have it right. Although something is wrong and not sure what. The API is from financialmodelingprep.com/developer/docs/, which I found mentioned in this forum. When I run it I get this result: Blockquote Updating stock prices Updating price of aapl… Can’t update the price of stock with no name Can’t update the price of stock with no name aapl’s price right now is: $undefined Done! Here is the script I have, with the field names changed to my field names (Symbol, Price, Price Date) (Sorry for the way the code looks below, not sure how to paste in code) output.markdown ("# Updating stock prices"); let table = base.getTable (“Holdings”), records = await table.selectRecordsAsync (); await Promise.all ( records.records.map (async record => { let stock = record.getCellValue ("Symbol"); if (! stock) { output.text ("Can't update the price of stock with no nam

Hi, All the way from Australia, and I’m newish to Airtable and will probably have 100+ questions. My first one is, can I calculate how many days there are from column B e.g. Column A is the date a property was loaded online column B is how many days a property has been online… any help would be appreciated. Thank you Sarah

Hi. I have a daily activity table, which I populate via a form (health tracker). I have several views against this table which show certain types of activity filtered for the last week - which I then use an email automation to send back targeted messages. All works great. However, I don’t know how to respond to inactivity. So if I don’t populate the form for a week (and therefore the table doesn’t have any entries for the last X days, how can I detect this (so that I can automate an email to remind the user to populate it again). Is there something with a max created timestamp, and then a logic check against this? Email automation is focused on a record being created or updated - I can’t think how to automate based on the absence of rows. Hope this makes sense - trying to prove this on my basic plan (for my MVP) before committing to a paid plan. Many thanks for any assistance.

How do I remove collaborators who are grayed out and seem to “come with” a template base? There are a couple templates I am trying to use but extra collaborators cannot be removed. I tried right clicking, I tried left clicking, I tried every other possibility that works in other bases and cannot remove the grayed out collaborators. Any suggestions? Thank you in advance!

I am trying to create a room Scheduling database. I want to be able to list the rooms on the left and have the calendar dates across the top. Please see the attachment for and example of what I am trying to create. Does AirTable do this? Please help. I

Hi all - somewhat daunted by the capabilities here … and so asking if someone can point me in the right direction. My base table is straightforward - just a list of calendar events, grouped into courses. What I want to do though is have something which allows me to populate new groups of events into that table based on some predefined rules associated with each course. For instance, if I were to setup a new course of type X, that might lead to three events being created in the table at +7, +21 +28 days from the start date of the course. Type Y might only have one event at +21 days from the start date etc. There are only a a small number of course types (<10) so needn’t be too complex. However, there are a lot of instances of courses being created. Any advice? Thanks in advance.