Other Questions

I’m trying to do a very simple Left formula to extra the first three letters of a lookup text field but keep getting errors. Is there something obvious I’m missing here:

Hello I’m new to AT, so I’m just feeling my way. I have a base recording bookings we get from schools who want to visit us. I send a school who wants to come to us a link to a booking form view that they fill in themselves to create a new booking record initially. Once they have done that we add bits and pieces of data behind the scenes. One of the things we need to do is book staff against the school booking, but that is something someone else takes care of. Previously I would have manually completed a form in Word and mailed it to my colleague as a prompt to book staff, but I am hoping Airtable can make this process unnecessary. I would like to be able to have myself and my colleague automatically emailed when we get a new booking added by a school via the form, to prompt her to look at the staffing requirements. She is the owner of the workspace the base is in, but can I add her as a collaborator to every record in this base automatically and have AT ping us

I noticed on the About Airtable Sync page, it says this: Field types that will not sync Authenticated attachments. What are authenticated attachments? Is this a new feature coming soon to Airtable? :slightly_smiling_face:

Hello everybody! Sorry if the question is too basic, I’m new to airtable… I’m trying to keep the wine inventory of my restaurant in airtable, and use a shared grid view to show the wine menu. During Covid situation we cannot use paper menus and we have a QR code so client use its own phone to read it. I have all items sorted by wine type using groups, then price… it works great. The question is: can I add the group name in top of the item list? The list is quite long and non-expert clients will get lost (they are using a smartphone to read). It would be great to have something like: White wines: xxxx xxxx xxxx Red wines: xxx xxx “White wines” and “Red wines” are coming from a single select field which I use to group them. Any comments or recommendations will be very much appreciated. Thank you very much and keep safe!! Angel

Hopefully simple question here, but can someone please help me figure out how to pull data into an AirTable cell from a website? I would like to automatically pull the number of followers a company had on LinkedIn into a cell on AirTable. I have been trying with Web Clips and help documentation thus far but haven’t gotten anything to work. Thanks so much!

I’m using Android 7.0. I can install and open the app fine, but immediately after I try to sign in, the app stops. Anyone else had this problem, and know of a solution? Thanks.

We have an app on one of our bases that shows a Pivot graph: Each bar represents the values for a specific workweek - 20.35 all the way to 20.39 We want the bars to be sorted by week from left to right. So week 20.35 will be leftmost, week 20.36 to the right of it and so on. I have not found anything in the settings that allows it. Any ideas? Thanks!

I have several records that have multiple attachments. These attachments are all PDF, Word or Excel documents. When I expand the record and click on the first attachment, it opens just fine. However, when I click on the 2nd or 3rd, it opens the first one. The only way to view the 2nd or 3rd is to use the arrows. I attach two screen shots to show you how a record with two documents shows the first one, even if I click on the 2nd one first. Downloading and deleting works just fine. Another intriguing fact is that if the record contains more than 3 attachments, the process works correctly.

Hi, I have a form that includes a linked field that references a table full of items. The items in the table all have a unique id and a human-friendly name. When I add the linked field to the Airtable form it defaults to showing the item id in the dropdown box which isn’t very user friendly. Is there a way I can force Airtable to show the item name rather than the id?

Quick question for the community. Is it possible to get metrics on an Airtable gallery embedded to a Wix page. I would like to track the number of views per gallery item if that is possible. Thanks for the help.

Can I have a separate auto number for a different view ? So I can calculate the number of records in that view ?

Hello My Awesome Community. I am having a task at the moment to send an attachment pdf Print from a gallery view in Airtable, or send an excel attachment on a daily or weekly bases in an Email form. Is there a way I can Automate an email with either of these attachments ( Excel or PDF) on a daily or weekly bases? I know how to set a trigger time with Zapier Schedule and send an email, My problem is with the attachment itself, I have Zapier and on2air solutions as a premium account. and I hope if Airtable new automation feature can provide that, Thanks a lot for your time guys.

I have a table that was set up in a “wide” format. It tracks quarterly and annual reports from organizations. The person who set it up used the organization as the key, and then has Attachment-class columns for each quarter, Q1-2020, Q2-2020, etc., with the relevant report in each field. I’d like to convert this table to a “long” format one row per organization per quarter, with a single Attachment-class column. I’m used to calling this operation “pivoting” or “reshaping” the table, but I can’t seem to get the Pivot Table App to do anything useful for this goal. Currently, there are about 16 organizations and 12 quarter columns, so it’s doable by hand, but I’d much prefer an automated solution. (And there are a couple other wide tables I’d like to convert to long format as well). Is there a good way to do this? TL;DR # Current table fields: Org (text), Q1-2019 (attachment), Q2-2019 (attachment), Q3-2019 (attachment)... # Desired table: ID (concat

So I’m just adding more content to my table with the same format as the first set data I copy pasted from my sheets, but now it’s automatically removes a column containing website links and does not fill the 2 other columns - State and City. What do I need to do?

Was wondering if anyone had ever come across some resource that can create a calendar icon based on the value of a date field. For instance, if I had a date field that had the value of October 19, then a means of automatically creating an icon like this: and add that to an attachment field. Might be a little far-fetched…

Hi community Is there a possibility to let people anwer a maximum amount of fields in a form? Thanks!

Hi I need to send text to a linked record field instead of the record id in the same way as if I paste text into the field or if I do it with integromat (smart links) or parabola (typecast: true) but from an airtable scriptig block. recordsArray.push({ fields: { "PID": formatted_date + " | " + (i+1) + " : " + record.getCellValue("PKEY"), "production date": current_datetime, "Group": record.getCellValueAsString("group"), "Sku": record.getCellValueAsString("txtsku"), "lr": record.getCellValueAsString("txtsku"), "Product SKU": [{id:record.id}] } }) I was hoping I could simply do this… recordsArray.push({ fields: { "PID": formatted_date + " | " + (i+1) + " : " + record.getCellValue("PKEY"), "production date": current_

Hello, Is there a way to restore mass deleted records? Im using the restore button in the trash base but it was enough data that Airtable runs into an error and I need to refresh the page before the records get restored. Is there any way to restore the records without restoring to a snapshot?

Hi, I’m suffering from google sign in error. after sign in with google auth, i got this error continuously. my all of google connections are unable.(google sheet, gmail,…) Thanks

I have a csv file that I have imported into Airtable. A field is created with a file name that matches an image file in separate folder with the file name included. How can I add the images from the folder to the table and link them to their appropriate record? Thank you

Can anyone tell me how I can join two or more tables?

I’d like to find a way to construct a column that scans the Title column and updates a column in the same record with multiple select options. To further explain, I’m building a database that has newspaper/press headlines (integrated via RSS feed and zapier). Each record has a “title” that has the heading of the article. I’d like to find a way to automatically update a column in the same record with multiple select options based on what text is in the name column. For example (within the same record) if the “Title” column of a record says “Three birds were seen flying from the eagle’s nest on Tuesday and are now migrating north to Montreal.” - the tagged fields column would read this and output (birds)(migration)(Canada). Is this possible on airtable? Where would I start?

For some of the projects I’m doing right now, there’s a lot of data entry work. Some of the records have multiple records with very similar entries. It’s much easier for me to read them as a column, rather than a row. However, for some reason, Airtable by default makes records stack vertically as rows. Is there any way to switch this up?

When i tried to connect account between airtable and google sheet. I failed and got some authorize errors when call back from google.(something broke) I got google’s permission but not airtable.

Hi there, I’m attempting to display dates from some contacts that are associated with lookup values coming from an event table, but apparently, the calendar view doesn’t read the format coming from the lookup value field. Let’s say I have musicians or artists, and one musician can play at multiple events. I’d like to showcase in a calendar view the dates confirmed of those musicians. Is this possible? Sharing some pics to better explain my issue. Appreciate some help on this! Thank you = )