Other Questions

Hi, I have two linked record columns. Our users use a custom app to link records to these columns.,I don’t want the users to link records directly from the columns but instead use the app. since we cannot restrict permissions to a column, is there a way to open the app when someone makes changes to a column? I am thinking an Automation when the record is updated and open the app from Autmation? Thanks in advance

I have a “Requirements” table with the following fields: ID Description (rich text) Question (rich text) I want to render all of the records as a single document so I can email it. Example (with Markdown formatting): # Outstanding questions ## {id 1} {description 1} ### Question {question 1} ## {id 2} {description 2} ### Question {question 2} ... My current attempt: Write a script and use output.markdown(...) to render everything. The issues: record.getCellValue('Description') returns a string, but that string isn’t suitable for passing to output.markdown(...). For example, if there is a “[” in the string, it’s interpreted as a link. Is there a way to render rich text values properly?

We noticed the Airtable API doesn’t return the same data as it used to be when returning an Attachment record. This is what my base contains: There is a width column set to 200.00 for the record efrei-v4-logo-efrei-advisor489. This is the record I get from the Airtable REST API: { id: 'attStvRqkaEsbPNBT', width: 500, height: 500, url: null, // Hidden filename: 'XXX (3).png', size: 42687, type: 'image/png', thumbnails: null // Abbregated for clarity } Before, this API was not returning the width and height properties (at least, it wasn’t returning those with our way of building our query). This seems to be something new, which in turn broke our products because it overrode our own width and height properties (we were looping on all of the Attachment record properties to dynamically copy those properties into an aggregated record which contains a mix of the Attachment record and the Asset record). This kind of small changes should be documented, there is no changelog

Hi, I have two tables from a csv file. Programs and Partners. I have an Program_ID field in the programs table that is not an autonumber field and that links to a field in the partners table also called Program_ID. I then created a new autonumber field in the programs table so I can add new records later. But now I need to update the foreign key in the partners table with the new program id autonumber field in the program table. I tried this with automation but i keep getting test failed and I know I am doing something wrong. I don’t want a linked field because I just want to get rid of the old program ID fields when the new autonumber id is updated in the partners table. Any help would be appreciated. Thanks, Marc

We could have more than two records with the same name. But Is it possible to prevent the record with the same name from appearing? I hope it will pop up a window to warn me when a same name record is created.

I’m trying to use the web clipper to get the URL (https://www.youtube.com/watch?v=t7X_WBQ6JRA) from a button and I just can’t seem to figure it out. URL is from USA CRIME Direct link to source page: https://usacrime.com/2021/08/16/police-release-video-officer-involved-shooting-allen-mirzayan-altadena/ Code: Here’s how I set it up in the Webclipper Block: Any help would be appreciated.

Hello lovely Airtable Community! Here’s my conundrum - I work for a not-for-profit trying to give locals on a low budget access to food at low cost. We’re using Airtable to log who comes, when, what food they take, and how much they pay - we’re essentially using an Airtable form as a shop “till” of sorts, using a network of linked fields and formulas that allow our Shop team to log all this info straight onto our Airtable database. The problem we have is that if someone wants to collect two of one food item, the person using the Shop Form has to submit the form twice, once with the bulk of what they’ve collected, and again with any duplicates, as the form won’t allow the same Linked Record to be selected more than once. This really slows things down, and while it’s not the end of the world, I’ve had a few requests from the team for this to change, if it can. I’ve currently got one Tab called “Transactions”, which contains the Shop Form view, and another Tab called “Food Stock”. The two

We are trying to transfer the ownership of various bases under one account. So its easy for us to manage the payments for all the bases from one account. I was wondering if we do so will that effect the zaps we have set for the different bases and tables and to what extent will that effect be? We are also using custom apis and webhooks to update the data within the organization. So thats what out concern is regarding the transfer of ownership.

Like the attached…can fudge it using a Kanban but can’t visualise the relationships

Wow, I have been using Airtable for years and cannot figure out what I’m missing- probably something extremely obvious. I’m trying to set up two views with opposite information. In one view, I only want the records that are not done, or are not identical to show, so I want two things filtered out: “Done” is unchecked OR “Are the forms identical” is unchecked. On the other view, I want the reverse- records that are done or are identical, so I have the filters as: “Done” is checked OR “Are the forms identical” is checked. However, the first view is only working if I select AND instead of or, even though I am not looking for records with both of these conditions, rather, either of these conditions. What am I missing here? Screenshots: The view showing the records I want to filter out, and the filters I think should do it, having no effect. Same view with the records filtered out, with AND instead of OR. The other view, with the reverse records- using OR.

Hi Team, Soooo, because Airtable doesn’t have a stand alone time field (it really needs one) I need to create a ridiculous bodge… I start with a Date field set to local format lets call it {CommDate} Next I have a bulk standard number field set to integer we’ll call that {Day} The third field uses DATEADD to add {Day} to {CommDate} easy enough, we’ll call that field {StartDate} it’s set in local format with “use same time zone” unchecked cos I’m in Australia. Field 4 is a text field with a time of the day written in it in HH:mm format, lets call that field {Time} Now here’s where it gets tricky… I CONCATENATE {StartDate} & {Time} it spits out an answer which looks like YYYY-MM-DDT00:00:00.000ZHH:mm The YYYY-MM-DD matches what’s in {StartDate} and the HH:mm matches the text in {Time} and I can only assume the T00:00:00.000Z is a representation of the UTC/GMT timezone. Let’s call this field {Date&Time} But here’s where the problem comes in… My next field is a DATETIME_PARSE of {D

Hi! So, I’m using Airtable to organize volunteers and delegate tasks based on their interests. I have a multiple select column called “Interests”, with options such as education, research, communications, and design. I want to organize my data in such a way that I can see everyone interested in education, everyone interested in research, and so on. However, some volunteers marked multiple interests. When I try to group the table by Interests, it creates unique sections for those who marked multiple interests. I’d like to have four discrete sections that include the volunteer in each section they marked. I’ve seen in other forums that I should create a join table, but I have no idea what that is and I need someone to break it down for me. Thanks so much!!

Hi I have an airtable app that I use to tract diecast cars. I want to know if its possible to say query ebay for an item that I have and pull in the price that it recently sold for? I’ve looked around and I’m not sure if its even possible. Maybe an API call to ebay? Thanks Greg

If a person is ON the CRM but their ‘Current Title’ field is empty in the CRM. When they select their name on a dropdown list on the survey, how can I show the current title and company fields ONLY to them and not show to those that have their current title completed on the CRM?

Hello community, I’m impressed by Airtable features, in fact i’m a Pro User, but the IPad APP has a terrible user experience so i’m trying to use desktop versione but is IMPOSSIBLE to scroll. I don’t know why it’s not possibile to scroll but for my work i need it absolutely otherwise it’s impossible to work. thank you, Alex

Hello! We’ve come up with a way to use web clipper to pull data from our forum website using css classes, however, we have multiple records we need filled but the clipper only pulls the very first. Is there a way to pull multiple entries if the same class shows up on the page we are clipping from? Thank you.

Hi Community, I love AirTable. However, I’m running into some low-code architecture dilemmas and could really use your help. We are building a web-application to easily work with European regulation. Complying to these regulations, requires filling out a ton of details about a business activity such as the CO2 emissions, gender diversity etc. You can compare our functional requirements to tax tools such as TurboTax. For anyone not familiar with TurboTax, we need to following components: Member portal Users should be able to register, login and have access to user specific, or team specific private content. Data I/O Users need to specify details about business activities such as its CO2 emissions through a smart form in a browser. The complexity of the information is quite high. The smart forms should allow for: Logic, for instance, if the answer to question 3 is “yes”, skip question 4-10. Help. If a user gets stuck, there should be ample help options available. Calculation of derivati

Hi, I’m currently testing the app to see if we can incorporate it into our company. My main issue is the way that data can be formulated in order to display desired visual data in charts. I want to make a visualization of data for Comparison between Anticipated revenue and Actuals revenue, Actuals revenue, per client, per month, and the set goal for the year. I have attached the current base format I am trying to make to reflect the data. Looking forward to the community support, TIA !

Hi , I have used fetch method fetch external data to airtable Via customer script app . But while while we used to download PDF from API url and the External Api response as HEADERS Content-Type:application/octet-stream Content-Disposition:attachment; filename="{filename}" BODY File content My Question is how can get this fies and store in airtable some attachment fields . Please advice .,

The Vision App requires an API Key. The API Key is visible to all collaborators. Google specifies that API Keys should not be exposed in code, as this is a security problem. I attempted to “restrict” the API so that I could at least limit usage to airtable / vision. But I got an error related to OAuth. Am I misunderstanding something about the potential security implications? Why would this app be designed to keep the API exposed? Thanks for any advice!

I’m using page designer to create reference documents for each of the clients who have scheduled visits to my organization to take part in our outreach programming. The page references information from a “Client” table which in turn links to a table called “Group Visits” listing all of the visit dates for clients coming to the organization. The date or dates that a Client will be visiting are shown as a table in the Page Designer Block along with additional data from the “Group Visits” table. Included in the data is a “Status” column which is a single select filed indicating whether the visit is “pending”, “booked”, "cancelled’ or “completed”. I want to be able to filter the linked records so that “Group Visit” entries with statuses of “Completed” or “cancelled” no longer show up in the table on the page designer block. This way, when an existing client makes a new reservation for a visit, their previously “completed” or “cancelled” visits will not show up in the table on the page des

I’d like to program certain fields to perform iterative calculations in Airtable. Does anyone know what coding language is acceptable to program a data field? Or, do I have to run some other application (e.g. google sheets, excel, access, etc.), have that application pull airtable data, and then have it push back that data to Airtable? thanks

Hi friends! I’ve been using the new when webhook received automation trigger and was wondering if there was a way to “silence” the response. Currently, Airtable returns {success: true}, which some sites take issue with – they consider an empty 200 as a success and anything else as an error of some kind to be reported. I noticed that Zapier’s webhook functionality has a checkbox to enable “Silent Mode”, which responds with an empty body. I’m wondering if similar functionality either exists already in Airtable (and I’ve somehow missed it), or if there might be plans to implement something similar. Thanks!

In the kanban view, I don’t see the full text of the content. For example I see :slightly_smiling_face: Danone’s specialized nutrition plant in Poços de Caldas in Brazil, which produces milk formula and medical nutrition products, is the company’s first … When I open the full view I see the whole content: Danone’s specialized nutrition plant in Poços de Caldas in Brazil, which produces milk formula and medical nutrition products, is the company’s first production site in the world to meet its sustainability goals across three environmental areas of carbon, water and waste. Is there a way to see the whole content without the need to enter the full view?

This might be a bit difficult, because it involves both Typeform and Zapier as well as Airtable. I’m having two issues but both are overlapping. In my Typeform I have some questions that are multiple choice with the option for multiple or single select. One of the questions asks about which states the person is involved with and has them all listed out. One person might just choose one state and the next might choose five. When I plug this data into Zapier, it comes across as one lump instead of individual selections so it doesn’t match up with the multiple select field in Airtable unless the person just selects one. Does anyone know how to fix this? In my Typeform, I have a question similar to the one above that lets the person choose what field they are in. Some people select only one, but several select more than one. This works with a linked field in Airtable. The issue I’m having is similar to the one above, if a person selects 2 it creates a new field with those two as one item