Other Questions

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 (concatenate Org and Quarter), Org (text), Qua

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_datetime, "Group": record.getCellVal

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 = )

Hey - I am currently looking to figure out an email integration issue and couldn’t find anything in previous community discussions. Maybe I was articulating my searches wrong, feel free to point me to the right post if I missed it. What I’m trying to do with my project management workspace is the below: I have a list of multiple projects in my workspace Each project has an “Overview” template attachment (a 1-2 page description) My team and I have to email this template around at times, but we like to customize it a bit when we do (ie: the template is just the “bones” of the email that we add to) Is there a way to integrate this attachment field with our Outlook, so that when we download it it’ll pop into a new message / draft that we can then edit? Thanks in advance!

I have a base in Airtable already set up that has several tables. One of the tables is my “Contacts” table. I have some additional contacts in some other places and I wanted to import them into this ‘Contacts’ table. So I imported a spreadsheet from a CSV file. The problem is that when I imported the spreadsheet it showed up in my base as ANOTHER table called ‘Imported Table’. Now, I can’t figure out how to add the contacts from my ‘Imported Table’ table into my contacts table. What I am missing here?? #AirtableLoser

When I try to convert a # field to a % field, Airtable adds like two decimal points - any idea why and how to undo this?

I’ve created a scenario in Integromat that watches for files to be added to a specific folder. The idea is that when a file is added, it will trigger the scenario which will add the file to a Table in airtable. Dropbox recognizes the file, it then downloads the file from dropbox. But when it goes to create the record in airtable, it comes back with an error. Here are some screenshots of the progression: This shows that data is coming through the dropbox scenario. However, this is what it looks like when I try to configure the airtable operation to add the file as an attachment. This shows that when the scenario is run, the dropbox listener and the dropbox file download work. But there’s an error with the URL.

I’m new to using ‘Customer Development CRM’ from ‘Sales & Customers’ section of templates and have an issue. I see the example linked interviews but can not figure out how to add new interview events. Please help Add new record - makes new record with #ERROR! in first (customer) field.

Can I share my charts in the Apps with my management team who are not on my Airtable Account? Can I also use them in power point presentations. thank you for your help. kkuhl@younginnovations.com Kim

Hi, I have a shared Form secured with email domain (so auth is needed to access it). I would like to initialize a field with the email of the logged user. I created an automation, I’m able to modify a value of the created record but the object session is null : “ReferenceError: session is not defined”. Any idea on how to achieve this ?

I am referring to data in 2 linked tables. The base design record presents the correct data - but the following pages show the change in records, and the hard data typed on the page & borders, but not the data in the tables. What gives? Ronald Hufham

I was trying to create a view that would show “My Tasks” on a “Tasks” table. For this to work for any collaborator, I would need to be able to set a filter for tasks where the “Assignee” is “Me” and not my explicit name. Since I could not find anything about this, I assume there is a workaround for this. I would love to know.

Hey folks, I have what I have to assume is a silly problem but I’m still stuck. Here’s what I’m trying to do I have a table with Users (Table: “Users_Table”) and various characteristics One of the characteristics is “Favorite Foods” (A multiple select). So Jane, a user, can have the entities “Pot Pie”, “Chocolate Cake” in her Favorite Foods column Meanwhile, another table is “Table_of_Foods” with their ingredients (Food_Name is the Primary field on that table) and the Ingredients_List column is a multiple select The Food_Name “Chocolate Cake” has these entities in the Ingredients_List: Chocolate, Butter, Sugar; and the item “Pot Pie” has: Chicken, Butter, Carrots Now, what I’m trying to do here is have a column over in Users_Table that has Ingredients_Allowed where I am rolling up all the ingredients that I know my users can eat, since they are components of their favorite items: “Pot Pie”, “Chocolate Cake” in the “Favorite Foods” column. I can rollup Ingredients_List as an ARRAYUNIQUE

Is there a way to take notes on a client that is timestamped, and lasts for longer than a year? The only two options I see are Long Text, which doesn’t timestamp or put last note first, and adding a comment, which doesn’t have any formatting and doesn’t last more than a year. Any suggestions would be greatly appreciated!