Other Questions

Hi, I am trying to patch a record using the primary field. How would I go about doing this? Use case: I create a record and assign the primary field as the object’s unique ID. A few minutes later I receive more information about this object and I want to add the information to the record. I do not have the airtable id that I received when I created the record, but I do have my unique ID for this object. How can I update this record using my unique ID for the object, without airtables underlying id?

Hi everyone! I’m new to Airtable and need some help with the Forms view. Providing some context below: Table 1: Contains IDs and names of specific users. Table 2: Contains data that is inserted via the Form View, with one of the questions being a Linked Field to Table 1’s ID. My questions are: Why does the form in edit/preview mode show all the other data in Table 1, but when you share the form it only shows the ID? Edit mode: Share mode: Is there a way for me to display the lookup field of the name of the user from Table 1 when their ID is selected? Since selecting IDs will start to get confusing after a while. Thanks in advance!

I am using AirTable to manage a vehicle database. The entire base is embedded within our company intranet page and is visible to Salespersons. We want Salespersons to be able to email a record (from a specific view) to a customer quickly and easily. On the full version of AirTable, I can right-click on a record and choose “Send Record” to email a nice summary of the record and photo attachments. When I embed the base, the ability to right-click is no longer available. Is there either a way to get this functionality back in an embedded base, or a way to simulate it? Thanks so much!

Our primary lead source comes from Canada Post neighborhood mailings. Right now we are sending about 300K flyers/month across 4 divisions but will be increasing to 450K plus come the new year. We have over 20 areas a week and multiple flyer types which we are looking for a more stable way to keep track of. I am wondering a couple of key things before I dive more heavily into mastering this myself. As we schedule new routes, is a recurring date scheduling function something that can be coded in? From what I have come across, this is not something I’ve seen others need to use, but for us it would be essential. Ideally as a mailing route is generated you could schedule it one of 3 ways. a: Say the route has 10,000 homes, and you want to send them out over 4 weeks on mondays starting X date, it splits up the routes (taking into account the varying number of homes) and generates a plan with an assigned flyer type. b: You want to send at least 2000 flyer per week starting on X date and the

I am trying to update a record’s attachments field. I am doing this successfully with curl, and also I have python code that successfully pulls records from the table; however when I add code to that which tries the PATCH, I get a “Could not parse request body” 422 response. Below is the code. Thanks! import requests import datetime import json auth_token=‘keyXXXXmJVG’ hed = {‘Authorization’: 'Bearer ’ + auth_token, ‘Content-Type’: ‘application/json’} url = ‘https://api.airtable.com/v0/applXXXXmLfek/Table%202/recthrgH5KVMEMglc’ print(“GET’ing records…”) # THIS REQUEST WORKS: response = requests.get(url, headers=hed) print(response.json()) r2 = { ‘fields’: { ‘mytext’: ‘success’}} print(“PATCH request…”) # THIS REQUEST FAILS WITH 'Could not parse request body’ presp = requests.patch(url, headers=hed, data=r2) print(presp.text, presp)

Hi, my colleague got this really weird problem. Starting this morning, when she tries to enter text in a Long Text field, it delete each letter after she types it. So she sees the letter for a second or two then it deletes itself. She’s been using this fields for months without any issues. Here’s what I tried so far. Close all her browsers and reboot the PC = Did not solve the problem I tried logging with her account from my PC = It worked!!! I created a Long Text field on another table without activating the rich text formatting = It worked for both of us!!! So it looks like when she tries to type anything in a long text field and activate the rich text formatting, it does not work anymore for my colleague. Beside removing the rich text formatting on the field, do you have another solution that I didn’t tried? Thanks Annie

Hello, Long time reader, first time commenter. Each year, my org has members re-enroll in our program. Ideally, they would be enter their name/ID and view all the relevant information within their record. My hope is to have this information populate a form, where they could then make updates where necessary. Does anyone have suggestions about how to do this within a Wordpress site? I have some basic facility with javascript, but that’s the extent of it. I imagine that the solution will involve the Airtable API, but I’m not sure where to begin. Thanks, Mike

Per the title. Is this a bug? If so, is there an ETA for a fix? Is there a workaround?

This is probably a basic task but I’m not finding info on how to do this. In Table A I have application info from applicants that are submitting through a form In Table B I have info coming in from Paypal (via Zapier) of payments from applicants (their application fee) How do I have each record in Table A reference each record in Table B, matching the records by the Email column, so that Table A automatically brings in the $ amount in Table B? Thanks for any tips!

Hello, I’m having trouble with some Airtable fields. Many come through fine but as you’ll see in the attachment some come through as nonsense alphanumeric sequences. They seem to be the fields that “allow linking to multiple records” and so in this example (attached screenshot) it says: Course Enrollment: reco2nD46QXVJi6pF instead of: Inner Development for World Development Any help or suggestions very much appreciated.

New to airtable, how do I auto populate the current date to every new record that is created? Thank you!

Hi there! I’m using Airtable for content scheduling and curriculum development, but I’m struggling to create a Kanban view that solves my needs due to the lack of multiple field selection (in the Kanban view). I have seen other threads on this, but I’m not clear what solutions were deployed. Here’s the context: I have a master table called ‘Content Plan’, which is made of a number of tables. One of the tables is called ‘Exercises repertoire’, where I list all the exercises media files we’ve produced, and it contains important informations around the length of the file, the production status, the person who recorded it and so on. This view is currently a grid. Each of these media files can create a content journey/curriculums. So if have the files A, B, C, and D and so on I could create various journey by mixing these files in different orders. So for example I can have Journey 1 = A - D - C in sequence and Journey 2 = D - C - A in sequence or Journey 3 = C- F -G and so on. Now, I need

How to get an input via form that creates a view? This can change every-time depending on the form submission. Help pls For example: I need to select my phase of product (column 1) and my focus (column 2) in a 10 column table and based on this input via form the view must be generated. Depending on the input in the form, the view will keep changing. How do i do that? Thanks in advance for all the help and support here :pray:

Hi everyone, Apologies if this isn’t the right spot. I have a table with many columns and 150 rows. In the slew of columns that I have, I have 3 that I am trying to compare to find duplicates (indicating classes that are scheduled in the same room, on the same day, with the same start time) using the de-dupe app currently. The room column is a text string that is identical for the room. The time column is a start time in military time. The day of the week column is giving me trouble - It uses M,T,W,R,F but also includes MW, TR, WF as a meeting pattern. Is there a way to look for duplicates that are in the same room, with the same start time, but where the day of the week column contains a matching character? I tried splitting the MW manually, but it was time-consuming and didn’t end up giving me the result I want- it still couldn’t see there was conflict when the room and start time were the same but the “day of the week” column contained a matching character (ie- didn’t recognize that

In all other views I can hide fields from read only viewers - But if I use a Gallery view there does not seem to be the option to hide fields - Am I missing something? Thanks. …Jon.

We rely a lot on custom fields in JIRA. Is it possible for the JIRA integration app to pull custom fields? Checking the documentation, it leads me to believe this is not supported. That significantly limits the usefulness of the JIRA integration, to be honest, and forces us to explore building a custom integration with the API or SDK to accomplish it. Has anyone solved this problem? Thanks! Dustin

Hi there, When uploading a new version of a CSV, I have worked out how to add and update existing records. What I can’t work out how to do is to remove records from the existing table if they have been deleted from a new import. E.g: CSV version 1 has 20 records. CSV version 2 has 18 records - how do I automatically remove these 2 old records from my new updated table after import?

I am sharing the view below: However, this is what the other person sees: What must I/they do to see the top version?

Can the universal HTTP module in Integromat be used to send information to ebay and amazon? I am not looking into integrating with Amazon Sellers Central (and other sites) but the fulfillment side (order management) which most of the 3rd solutions out there already provide.What I look into is to submit new listings via Integromat to those platforms. That would mean push information there. As far as I know Amazon provides an API to do that and there are 3rd party services offering that but the services are limited to a few platforms only and they charge more for extra services. Listing an item would involve sending the new listing related information (item title, description, price, links to images hosted on the web etc…) to Amazon. From what I found about the HTTP module it seems it does support it, right? Integromat How to connect Integromat to any web service that uses OAuth2 authorization... One of the many great features of Integromat is the abilit

Is there a way to make the expanded record information appear larger?

I need a formula to get the latest (earliest) date & time from this 2 columns I will create a new column with that formula, what is the formula to use?

How can my Virtual Assistant update our Contacts table? How can my photographer add pictures to our Products Table? How can my Marketing Agency add notes to our Campaigns table? A read only link and/or a form is not “collaboration.” Giving 3rd parties access to my my entire base is not efficient or safe. Please tell me there’s another option!

I am a real estate agent and I have a number of listings I work on. I am trying to add a synced base from my master base, where only collaborators can see listings assigned to them. I can get my master base to sync with a new base, but when I try to filter by collaborator the user’s info is replaced with “invited user”. I can filter by typing in invited user, but this won’t work as I add additional collaborators. Can anyone help? Thanks!

Hello, I would like to use airtable for social media management and scheduling with someone else. It would just be between two people. Myself and another. For example, Person 1 - Uploads attachments/documents/images/resources Person 2 - Schedules and organizes the content for the week Person 1 - Can review and enter (text/copy/“caption”) where needed, as well as leave notes revisons Is a Pro plan needed for this? and if so, would BOTH of us need to pay for a pro account? Thanks in advance, I’ve searched high and low for an answer for this, even watched a few videos, and I’m still not 100% confident that I understand.

Hi! I’m relatively new to Airtable, can I set a button field to go to a specific view and either select or scroll to the related record in a different table? Basically, I want to ‘one click’ and get right to the related record line on a grid view. I’ve gotten to the table but am unsure how to get the view or related record I’d like selected. Thanks!