Other Questions

Hi Airtable community! I am trying to collect ideas from people. Currently, I have a form embedded on a website and a gallery view of the responses embedded below. Some users said that instead of filling out a new form to add a new idea, they’d like to respond to an idea submitted by someone else that they can see in the gallery. What airtable features or apps might allow this functionality? Ideally, there would be a conversation thread. Thank you!

Shortcuts to switch between views/bases/tables is potentially a great productivity boost! When using a shortcut after successfully switching to the desired location, the keyboard does not automatically focus itself on any of the records. Is there any way to focus on any of the records using the keyboard? One way is to create a new record and then delete it using Keyboards shortcuts. However, this is cumbersome.

Hello Folks, The batch feature here works perfect and it creates 50 records in milliseconds and goes on till it finishes the total number of episodes ( EPS ), I have a tiny issue with the numerical calculation, it doesn’t work well with pattern adds to the date So if you run this batch script to add 7 days to each date the result is not accurate const importTable = base.getTable(“Titles”); const importQuery = await importTable.selectRecordsAsync(); const episodesscheduletable = base.getTable(‘Episodes Schedule’); const episodesScheduleQuery = await episodesscheduletable.selectRecordsAsync() const episodesScheduleNames = episodesScheduleQuery.records.map(x => x.name) let contactsToMake = ; for (let record of importQuery.records) { let myDate = new Date(); let RowsToCreate=0; RowsToCreate= record.getCellValue(‘EPS’) ; myDate = new Date(record.getCellValue(‘Release Date’)); ``` while (RowsToCreate>0) { myDate.setDate(myDate.getDate() + 7); await episodesscheduletable

Hello! I am trying to upload images through the Airtable API. I store the images on a server, so that i can provide the link that the attatchement object requires. But for some reason, airtable rotates my images when displayed. I rotate them programatically through the PIL package - and when i visit the photo link in the browser (hosted on my server), the photos are correctly displayed - but in airtable they are not. When i use the uploader dialogue on airtable, they are displayed correctly (when i give the SAME link). Anybody else experienced this problem? IN AIRTABLE: IN BROWSER:

I just created a new Base to use as a CRM. Whenever I try to save a date (in any field) I’m met with “An error has occurred - sorry, your request conflicted with another change”. I’m not sure what that change is or how to fix it. Please help!

I’m trying to write a formula that will automatically populate this field with an email address based on the name entered in another field so I don’t have to manually type the address each time I create a record. I’ve used the Switch formula and assigned an address for each of 4 names, however, sometimes there are multiple names in that original field. How do I write the formula to populate each email address for each name in that “Assigned To” field in my table? Right now, if there is anything but an individual name in that field I have it defaulting to send to me, but I don’t want to have to keep forwarding to the appropriate people in the automation I created linked to that email address field.

Hello :slightly_smiling_face: I am creating an automation with the condition: when there’s a gcal event created, an email will be sent to my team (30 people). For example: I set the gcal event on 5th, recurring every month. So if today is 5th of March, an email will be send automatically to every email address listed on airtable record (in records grouped as ‘active employee’). Is that possible? Looking forward for your help, thankyou!

I’m new to Airtable, but have extensive experience in SQL databases. I could do something like the following in Access, but I want to make this database cloud native. Any assistance would be appreciated. I’m working with a consulting firm that has ~50 consultants who relate to one or more legal affiliates of the firm through independent contractor agreements (ICA). Each ICA formally connects one of our legal affiliates with an “external entity” (an LLC, a sole proprietorship, etc.) to which a consultant belongs. Each consultant may have one or more external entities that they are themselves connected to. I have built my base like this: I want to be able to create a Consultant view (ideally a card/grid-view) that would show me the consultant’s information and a list of all the agreements that are related to him/her through the external entity table. However, I can only figure out how to display data that is from the directly related table “Consultant/Entity Relationships”.

I have an Airtable questionnaire form for students to determine a possible career fields. I’d like to make this more efficient by listing categories, then subcategories. For example: Trades - carpentry, plumbing, electrical etc. Right now, I list each item in the multiple select field, but that doesn’t support subcategories. Are there other options? Thanks! Sharon

HI all - First time on this asking for advice, hoping I’m doing this correctly! I’m creating a database for crew members doing Covid testing schedules for a movie production coming up. I for some reason can’t wrap my head around how to set this up so that it’s great in Airtable. Situation: Tons of crew members in various “Zones”. Depending on which Zone they’re in sets how many times they test. For example Crew person 1 is in Zone A and gets tested 3 times a week. Crew Person 2 in Zone B gets tested 1 time a week and Crew in Zone C get tested every 2 weeks. Trying to figure out how I can have the testing dates set up in a table and then when I put a zone A/B/C that person gets populated into the correct testing dates (ie: Zone A person gets put into every testing date, Zone B gets put into weekly testing date and Zone C into every other week testing date). So I was hoping to have one table be grouped into all the testing dates for Feb (ie 2/10, 2/12, 2/15, 2/17, 2/19, etc). Then in

Hi guys, We have multiple servers with remote desktop access, and we’re using them on a daily basis. The current solution is a sheet with the server IP, username, and password. As you can imagine, it makes it very difficult and inefficient to search the relevant server, insert its address and credentials, and log in. In order to solve this problem, I’ve started to read and look for a solution. The first and easy-to-implement solution I’ve found is to create an “RDP” (Remote Desktop Protocol) file, with the relevant credentials - and connect directly to the server without the need of adding credentials each time. Still, from what I’ve seen - you can’t create a hyperlink to this file, either locally or on the web. So, I’m looking for a creative way to add a column to my table with a direct link to each server. The ideal is that a user clicks on the link, and the session opens and logs in automatically, but we’ll be more than satisfied also with a simple link to open the login page and th

Look to me like the entire airtable is down. Do we know when this will be fixed? Thanks

Hello Desperately needing help. I realize there is an article about this here: Automate changing the file name of an attachment Ask the community Hey Airtable Community. I need help with automating the repetitive task of manually changing the name of a file after it’s been uploaded into my base. As of right now, we have a user filling out a form, and after it’s submitted, I want that to trigger the name changing. I have a field that is automatically created with a formula based on information captured in the form that I want the name changed too. I’ve been looking at using the Airtable automation feature, but after trying a bunch of thi… I am a newbie of sorts to scripting. Can someone please help me with a step-by-step instruction?

Hi, I’m having trouble with my caption field as it’s repeated itself automatically and I don’t know what’s happened. The undo button won’t work and it wasn’t like this this morning. I had different text on each line.

I’m using the Airtable API to read data from a table. I find that when I make the API call after a period of inactivity, the first call takes more than 1 second. A subsequent call a few seconds later performs much quicker than the first (approx 300ms). Is there any way that I can speed up this first call as performance is important for what I am doing.

Is there a way to duplicate the formatting of an element in the Page Designer Block? The would be similar to the “brush” functionality in Word where you would select one element, copy its formatting (i.e., font, alignment, text color, etc) and “apply” it to another element. My use case is the following - I have an Airtable that lists Courses for a university program. I have fields named “Course Code”, “Course ID”, “Course Section” and “Course Name”. I’d like all of these to have the same formatting, but there are a lot of fields to adjust, so a way to copy the formatting to different elements/fields would be a huge time saver. Alternatively, I tried “duplicating the element” (which copies all of the formattings), but I can’t seem to find a way to change the field that element is referring to. This might be the easiest solution to issue, but haven’t been able to find any solutions in the help, support, or community, so hopefully someone can point me in the right direction. Thanks in

I have a csv of volunteers for upload via script into a table called Volunteers. I have a table another table called campaigns. The volunteers table is linked to the campaigns table via a field in Volunteers called Campaign. The Problem: While uploading, I wanted to link Volunteers data to the Campaigns table. I found the record ID of the appropriate campaign and made an array [{id: “recordID”}]. I checked that this would work by hardcoding the record ID. The linking worked. Here is the relevant code: let newRecords = csvRows.map(csvRow => ({ fields: { ‘First Name’: csvRow.FirstName, ‘Last Name’: csvRow.LastName, ‘Vetting Status’: {name: csvRow.VettingStatus}, ‘Skills’: csvRow.Skills, ‘Email’: csvRow.Email, ‘Phone Number’: csvRow.PhoneNumber, ‘Notes’: csvRow.Notes, ‘Campaign’:[{id:“recxxxxxxxx”}] } })); while (newRecords.length > 0) { await table.createRecordsAsync(newRecords.slice(0, 50)); newRecords = newRecords.slice(50); } After doing this, I wrote some code to loop through n

Hi all - Our company has a sheet specifically for “People,” where we create entries that identify a person, a description, and their contact information. Another component is “Connections” which is linked to the entire “People” database. Connections allows us to link two “People” together. One thing we’ve been trying to figure out is how we might automatically link these connections once a connection is created from one person’s profile. Example: We open Person A’s entry, and select Person B as a “connection,” and it is displayed on Person A’s profile. However, when you go to Person B’s profile, Person A is not listed as a “connection.” Is there a way to automatically backlink connections between two people? Please ask clarifying questions if this doesn’t make sense. Thank you.

OK - I have built a crazy complex base (IMHO) over the last month and a half. I am amazed at what it can do, but as it seems all advanced bases have - there are some kludgey solutions. Schema just for fun: OK - so vertically linked tables: Master Table → Flag table Resource Table -->Master Table Resource Table → Flag Table How to get the record created in #3 (Flag created in a Resource Table) to link over and show up in the Master table? Solution #1: Use automations to grab lookup field names and populate the linking record to get a flag created in #3 to show up in #1. That works. But with four programs, and three or four Resource Tables per program, plus other automations - am at max of 25 automations before I can get them all covered. should have looked up automation caps before I went down that path… :dizzy_face: Solution #2: I just discovered Link Records by Fields App. Wow! This seems like the solution I have been needing. Sweet. But, I cannot figure out how to autom

Is Airtable working normal? Its so slow my by us, when we try to import in bulk by the API

Hello, I hope someone can help me out. I have on airtable multiple tabs. For example a tab “Social Media campaigns” and a tab “Webshop” and a tab “Advertising” . Each tab consists of maybe 30 tasks but each of these tabs have one column that is called “this week” . This column has a checkbox, when we mark the checkbox, it is meant we do this task this week. Now, as we have multiple tabs, I want to create one new tab. This tab will be called “this week” and needs to summarize all tasks across all tabs into one tab. So we can have quickly an overview of all tasks we have to finish this week. It means the new tab should have some selection like this. Checkmark this week across all tabs is YES Then show in new tab Task name Tab name Something like that. That is all, I want! I dug into the sync tables but I could not figure it out.

I’m trying to figure out how to email an attachment to my contacts (not collaborators). Is there a way to do this? It’s a .jpg image. Thanks

Hi, guys! I need to share a base with a client, so he can fill some cells. It’s someone who is new to Airtable, so I’m afraid he got a bit scared. I was wondering: should I share an editable view with him or should I use a Google Sheet and integrate it with Airtable?

Hi. I’ve combined two tables into one but when I sort by any of the single text it sorts into two A-Z lists one after the other. This happens when I sort cells with numbers or with letters. I’ve checked and can’t see any leading spaces in either list (although may be checking for these wrong - I’ve been clicking into a cell and scrolling to the start to make sure the first character is a letter and not a space). Any other thoughts?

Hi everyone, I’ve been a long-time user, but only recently started following the forum. I have a table of hashtags specific to that are specific to my industry marked as “High”, “Medium”, and “Low” based on their popularity. I want to generate a list that selects a specific limit of hashtags per category randomly; ie. 6 High, 10 Medium, 16 Low. Ideally, I could regenerate a new list somehow and the list would be easy to copy to paste into Instagram. Any suggestions would be deeply appreciated. TIA.