Other Questions

Hi there, I’m doing an IFTTT to Airtable integration, which creates recurring tasks. The only challenge I’m facing is adding the current date. IFTTT passes a date as “August 08, 2020 at 09:31PM” which Airtable can’t use. So I’m looking for other solutions. One possible solution is using Automation and Scripting. Any new record created in view runs a script that adds the current date to my “Date” column. Can anyone help me with this script? Or suggest another way of adding the current date, without changing the Date field into a formula field - since I input most dates manually. Cheers, Subir

Using SendGrid, is there a way to have a Good {morning, afternoon, evening} tag based on the time the record is created? Or will this require more hidden fields to accomplish?

When I select creation time it will show both the date and time. I only want to show the time portion. How would I do this?

I am the only user on my AirTable account. I utilize a large storage plan on Dropbox. Is it possible to link the Attachments from AirTable directly into this Dropbox as opposed to having to purchase an additional storage plan at double the subscription cost from AirTable?

Basically what is said above. I have a huge database already in Airtable and recently received a massive spreadsheet. In the spreadsheet there are linked documents and I was hoping to upload the whole thing, including attached documents, into Airtable. Does anyone know of an easy way to do this?

Hi, I have a list of rows with numbers. I would like to be able to send SMS to specific numbers, but it seems I can only send SMS to All the row. Is there a way to add a kind of button or something, to be able to select some numbers I want to contact ? Thanks, Sébastien

Hi all. New to Airtable. I help out with a volunteer organization, and volunteers use the Airtable base to keep track of incoming calls. I would like to find out at what times we receive the most calls. I’ve tried playing around with blocks and I can find out the most popular days of the week, but is there a way to get more granular? (for example, a bar graph that shows how many records were created between 9am-12pm, 12pm-3pm, 3pm-7pm)?

My organization I work for is using Airtable to keep track of records. One of our bases is over the limits for our Free Plan and currently on a grace period. How long is the grace period and will my records be deleted when that grace period is over? Thank you!

Dear Airtable Community! I’m designing a website that lets users search for and find organizations, collectives and cooperatives in Mexico City that match their interests. Since I don’t know how to code, I decided to use airtable as my data source and simply embed search forms on wix that redirect to specific google calendar views and airtable views based on the person’s interests. Now that I’m thinking of publishing the site, I realized I know nothing about websites! If somebody is filling out an embedded airtable form in a wix site, would I need an SSL to protect the information they share? I’m not collecting anything as sensitive as payment info, but I do use airtable forms to collect emails, full names, and addresses for volunteers or people who want to make in-kind donations. I would also love any recommendations on where to purchase a domain. I will need to pay at least the combo plan in wix to have my own domain, but am hesitant to buy the domain with them since they can’t tell

Using the solution i found in a similar thread but this formula keeps returning an error. I can’t figure out where it has gone awry. The Total Time field is field type: duration. The others are multiple select. Without the DATETIME FORMAT i dont get an error but get the time as raw seconds and that isn’t helpful. Help! what i am doing wrong? {Team member}&" -"&{Type of Service}&" - "& DATETIME_FORMAT({Total Time},‘h:mm’)

Hey everyone! I am a super new user so I apologize if these questions have been asked before (did search but… you never know! ^_^) I am making a form for furniture removal requests and I am wondering if I can do the following things automatically fill in date column with the date the form is submitted auto-generate a case/tracking # in the case column-- ideally id like it be a concatenation of the year and month, and a count of items (so the first item would be something like 0820_0001 or 0820_1 … whatever’s easier)… i’d be happy if it was just a raw count though. I’d like to have a category drop down menu (which I’ve successfully created), but I’d like to add a last category called ‘other’ that would let the user fill in their own category Similarly. I’d like the user to be able to enter the item type (office chair, file cabinet), but ideally I would love it if the form could offer other values from that column as suggestions, as to not end up with a bunch of overlapping categ

Hi, I need to extract the time and date from strings such as this one and add them as a separate cell in the record: “Thu 7/06 9:00am - Vinyasa Yoga @ Millennium Park” I’m trying this but it’s returning “-2”: MID(my_string, FIND("/",my_string), - 2) Also tried this to get the date and time up until the “:”: MID({Class Title}, FIND("/",{Class Title},0), -2,FIND(":",{Class Title})) [my_string is actually the field where the string is hosted] What would you recommend to extract the date? And what format would you recommend to have the time & date (e.g. both in one cell or separate for time and date). Many thanks for your help :slightly_smiling_face:

Here’s a hypothetical scenario that describes what I’m trying to do. Let’s say I have a table that has two fields: author name and genre. I have a second table that tracks books and their genres. I would like to create a dropdown field to select an author name but I only want to see the author names that are in the genre specified in that specific row. Is it possible to use a field in one table to match up and limit the view of the dropdown values from another table? Sorry if this is confusing.

I’m new to airtable. I want to my colleagues to see the dashboard I created. Is there any option for that?

Hi, what is the hotkey to save description, records etc? e.g other services use CTRL + Enter for this.

Is it possible to add-to or append an image / attachment to an airtable cell that already contains an image / attachment? I realize that this is more than likely possible if I were to retrieve the stored airtable image first, BUT I would like to avoid this to save the time of downloading, storing locally and re-uploading the same images as that seems a bit redundant… Any ideas are appreciated! Note: Update methods just replaces the previously stored image.

Hi. I have created a template on page designer that allows me to print off labels with content from my records. Each record has up to 8 labels (split across two sheets of A4). Looks amazing but when I try to print, only the first page is printing? How do I get the additional pages to print? I have tried changing print and page sizes to ‘lengthen’ the custom page to the equivalent of two A4 sheets but it didn’t work. Is this only a one page tool?

I want to create an issues tracker base. One column will be a manually entered submission date. Column next to it will be “Time elapsed” field to show how long this issue has not been solved yet (in days). How can I calculate the “time elapsed field” in days since the date entered in the “submission date field”. I found this question here already: Counting Days Lapsed since Date Field Ask the community Hi! I am a complete newbie finding my way around. I have created a base to track work tasks, and want to create a field that will show the number of days that have passed since my task was issued. I have a “created time” field, but am unsure what to put in the other field to show the number of days passed since the created time… Hope this makes sense! Thanks, Cassie But this works only with the creation date of the entry. It’s important to me that I can select the submission date manually, so this field should be a normal date field.

Has anyone tried making custom keyboard shortcuts for Airtable? For example, to make an action like this: ‘apply a specific tag from single select field and move the focus to the next text field’. I’m wondering what could be potential approaches to achieve this.

Hello, I would like to have only one product from each category. There are two lit in stock but I want only the first one in the grid Thx for helping

I am looking to connect my Filemaker database to an Airtable base. The main purpose would be for the Airtable base to auto update, as I add new entries into my Filemaker database. Is there a way to accomplish this? So far, I have only seen ways to have Airtable data sent to Filemaker but not the other way around.

We are thinking of using Airtable as a requirements gathering tool to compliment Jira (because all the Jira plugins are terribly unintuitive and the Jira platform itself isn’t super UI friendly for those who don’t live in it every day). Simple question: Is there any way on a Jira issues page to have a reference link to a specific Airtable row? My proposed way to do this is just to hyperlink a row specifically on the description field of a Jira page, but is there a more…eloquent way to do it using the jira block?

Hi, I’m combining 2 fields (1 with date, 1 with time) into one single time+date field. Problem: when it combines the time, it switches a time that was in “pm” to “am”. Any ideas on how to solve this? many thanks :slightly_smiling_face:

I hope to create a portal for my employees to clock in/clock out using Airtable and Airpress, so I can tie their hours back to specific jobs. Is there a way to create user authentication in Airpress which would then automatically select the appropriate employee record in Airtable and allow that user to only modify records related to themselves? Thanks, Chris @Chester_McLaughlin

First—FINALLY! I have spent months looking at various online tables and database systems, and would get partway through, and felt like it just didn’t offer what we needed. I stumbled on Airtable and it is the only one that did what I was hoping with EASE and without hours and hours of figuring things out. I have 2 tables. Table 1 is client data information. Table 2 is a dates of contact. Is there a way for table 1 to display the most recent date of contact from table 2 for each individual. I attempted Max, but it did not work. I do have a look up of all the dates taken, but it shows them all, not just the most recent. I’d appreciate any suggestions. Thanks.