Other Questions

Hi, I’m a developper, and new to airTable. Wondering what other developers are using to build stuff with airTable. My client has a lot of data, and it is really messy. His employee are using airtable for ‘front end’ so my goal is to keep that this way. I would like to make my rest API to sort bases, lists and records in the client specs that somehow be re-injected/ deployed within airtable, in fresh new base, I might create a front end app later but that’s not the goal at this time. I have seen that, I you can create script within bases, or the airtable api there is a write back into airtable, which I understand that you need to run the app whenever you want to update ? or maybe create an automation from it ? thank you

Hello everybody i’m looking for a very simple script that would by ran with clicking on a button field in one table i would like to duplicate the record and to set the “date” field to tomorrow i would really appreciate some help thanks

Looking for a work around to the below, or if not currently possible please consider this to be a feature request! As far as I understand it, the way that fields are organized & viewed when a record is expanded from within the Org Chart extension are linked to the “topmost” view for that respective table. I would like the way that these fields are organized to be linked to the view that is controlling that org chart extension. The connected view already drives the filtering, and the way that records are organized at a given level for that org chart, thus it seems logical to me to also have the field organization driven by that view. I am working with a base that has multiple org chart extensions tied to the same table. These org chart extensions are providing visibility to a diversity of stakeholder (teams) and being used for different purposes. Thus would like to have a different organization of the “most important”, and not needed to be frequently accessed (hidden) fields. E

Hi everyone, I’ve got a many-to-many relationship. I have a Clients table and a Plans table. Clients have many Plans, and each Plan could be assigned to many Clients. I have a join table called Clients-Plans, so I can see all the possible combinations (for example, Client 1 + Plan 1, Client 1 + Plan 2, Client 2 + Plan 2, etc.). The problem is, my Clients-Plans table is not populated yet, and I can’t figure out a way to populate it automatically. Is manually the only way to do that? Thanks in advance.

I am embedding calendar view of a base having exam dates and assignment deadlines into my website, and providing users the option to select which subjects they want to see records. How do I change the embed URL dynamically to result in {Subject} = ‘Subject 1’ or {Subject} = ‘Subject 2’ …? The advanced filtering option is working for API but not for embed. Please help, thanks

I have 2 tables: table A contains groups and table b contains items. 1 record in table A can link to many in table B, but also 2 records in table a could link to the same record in table B. I want to score the records in each of the two tables, in order to understand and prioritise which unique combination has the highest score. So, I need a third table which is automatically generated and where each row is a distinct combination of a single record from table A and a single record from table B, where they are linked according to the above. In SQL this would be ‘full outer join’ of these 2 tables. Is this possible?

Hi, i did not remember deleting my views but all of them are gone. Am i missing something?

I want to use Airtable to host images that need to be edited (some areas need to be manually blurred). What extension can I use to open an image, make the edit and save back to Airtable?

Hi there, First off please accept this in the spirit of genuine concern and not moaning or such. AirTable is an important part of my business, and indeed a joyful part of my life as a tool that gives me immense value. However, there are things that I am noticing that are starting to make me worried, and wonder if AirTable is going downhill. I’m worried about this because I had the same experience with Evernote. It was an excellent product for a long time, and then it stared going down hill. It’s now a worse product than it was at its place of best usage to me. AirTable was a very consistent product. That’s what I liked about it. But I’m starting to notice inconsistencies, and it’s really worrying me. Maybe I’m just getting itchy feet. I don’t know. Is anyone else feeling this?

Hi - is there any way to use the Org Chart with “co-managers” as you would in a family tree with two parents corresponding to “managing” a team? The Org Chart is a great feature, and it seems like this could be a natural extension of the functionality.

I have a base that I have configured for an event. At the event, we will collect ideas in real-time and enter them into the table. At the end of the event, I would like to be able to send out a form that allows participants to rank each listed idea in the table for at least two categories. Ideally, the form will have each idea listed with the ranking options below each one. Once participants have all filled out the form, I would like to be able to average all of the collected data. Do you know how to set up a form like this and configure my base to allow this to work? If not, do you have suggestions on other routes or programs to take? Any and all help is appreciated! Thank you in advance

Our employees are paid in multiple ways. First, the amount of Revenue they generate dictates Hourly Pay Rate for the week. We are able to import all revenue transactions from our CRM via .csv Revenue Report files. We have a chart that displays Hourly Pay Rate by Weekly Revenue level in the base as well. An Airtable form is used to capture timesheet entries from the field on a daily basis. The number of hours entered is applied to the Hourly Pay Rate to generate Straight Time and Overtime pay. Additionally, we pay bonuses for certain high value items that are sold (commissions are on another rate sheet in the base). Again, we use an Airtable form for field reps to submit bonus items that have been sold. Finally, in all situations, we are using DateTime functions to identify the Week of the Year for pay periods (Sunday through Saturday). So, all transactions include a Pay Period (Week of the year) in the records. All of this data is in the base in the following tables: Revenue Timesheet

I am new to using Airtable and need help. I would like to have a user choose their name from a list in a table called (Inv by Rep) and then have a form or table populated with all of their records from another table called (Main Inv by Rep). When those records are returned, I want the Rep to be able to update the “Status” field and add a picture in the “Picture of Serial Number” field for just their records. I tried to link the tables by Assigned Rep, but in form view, I can just pick the name from the list, it doesn’t return any records. Is it even possible to do what I am trying to do in Airtable? Any help would be appreciated.

Hi all! I’m wondering if it’s possible to set up a case sensitive Contains Filter on a single line text field in a Grid View. So if the Contains filter value was ‘Abc’, a row with the field containing ‘Abc123’ would be shown but not rows containing ‘ABC456’ or abc789’? Thanks! Steve

Hi Airtable, I have created a workspace and base and then connected the base with my Duda website by the API. When I added content to the base, the base data didn’t appear on my website properly. Please let me know how can I solve this problem. Thank you

Is there a way to fix scatter plot axis ranges to a specific value rather than having them automatically adjust to the input data?

Not sure if this was asked. But using record listing interface for table A with a related table B. When you click, you end up at the backend of Table B and not another interface. How can you set this up?

Hello, i have an airtable table where i have addresses, i am looking to get coodinates (lat-long) from them, after doing many researches i found some paid airatble extensions but also a platform called positionstack that offer a free plan to achieves geocoding. They have an api to do it remotely. seems that it need to call it from airtable but i don not have any idea how to do it, here is an example for google sheet : https://api.positionstack.com/v1/forward?access_key=YOUR-API-KEY&query=+++sheet_name!C2:C11+++ Any idea how to do this on airtable ? here the api doc page : API Documentation - positionstack

Is there any option to directly fetch the collaborator name whoever is entering the record? I am using a shared base. If the above thing is possible, is it also possible using forms? Thank you in advance.

Hello all, I hoped to close a project that I worked on for a few weeks today just to realize that synched tables do not behave as I expected. Using synched tables, records get a new Record ID in the destination. My workflow works a lot based on (pre-filled) forms. Now how can I pre-fill a form with a record from a synched table? Cheers Christoph

Hey, I was lost with pagination issue with QlikSense REST Connector but found a solution, here it goes: Pagination Type: Next token 'Next token' parameter name: offset 'Next token' path: root/offset :smirk: Luigi problems qlik airtable error 422 pagination offset token solution HOPE ‘IT’ REACHES YOU WELL :stuck_out_tongue:

Hi. I’m creating some new documents in the Page Designer block. Some fields that I’m referencing from my base do not always have data in them. Airtable is putting “lorum ipsum” placeholder text when the field is empty. Is there a way to turn this off so that it’s just blank? I created similar documents before and I don’t recall having this issue. Is the placeholder text a new “feature”? Thanks! ~ Geoffrey

Is there a way to embed a youtube video in a grid view card so the video is playable inside the card?

Hi, I am facing the same issue. I want to record time and send a notification to Discord whenever someone fills a form, but it shows in seconds only. How do I show it in HH:MM. It records in seconds as of now Could anyone please guide me.

I’m trying to find a way to send a copy of a form submitted by our Account Executives by using something else besides automations. I have only 2 slots left of the 25 limit and would rather not use them for something as simple as this.