Other Questions

I am using python to run sum calculations and data summaries at various sub-groupings. This is being done using python pandas and the data format is a dataframe. I have to convert this dataframe to a list according to the airtable python wrapper documentation, which I have used before, just not the dataframe part. After converting to a list, I am getting this error requests.exceptions.HTTPError: (‘422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appQzuUudoe2rSAR0/Test-2’, “422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appQzuUudoe2rSAR0/Test-2 [Error: {‘type’: ‘INVALID_REQUEST_BODY’, ‘message’: ‘Could not parse request body’}]”) is anyone familiar with this any why it is happening?

Hi, Apologies if this has been covered elsewhere. I’ve got a table with 3 fields: Customer (Single Line Text) Interests (Multiple Select Field) VTS (Formula Field) and I’m trying to get the VTS field to populate with the Customer Code if “VTS” has been selected in the Interests field. I used the formula IF({Interests} = “VTS”, {Customer}) Screenshot 2021-02-13 231010|700x490 and it returned a result when “VTS” was the only item selected in the Interests field, but not when more than one option had been selected. I’m assuming it’s the equals sign that needs editing, but I’m not sure what I need to replace it with. Any help would be much appreciated.

The airtable app on the iPhone doesn’t make any sound alert when a collaborator mentioned me. How can I solve that problem?

how to copy and paste an excel date field to Airtable so it can be formatted as MMM-YY, iie., Dec-02 is Dec in year 2002. copy and paste an excel date fields to Airtable

Hi. I created an Airtable form template that I would like to use in multiple bases. Is there a way I can just upload the template into each base rather than having to recreate the form in every base?

Hi Community, I’m very new to AirTable and still trying to figure things out, but am having issues syncing ONE of my iCal calendars to AirTable. I see all kinds of descriptions of how to sync an Airtable calendar with iCal, but that’s the opposite direction of how I would like to sync. I signed up with Zaphier in the hopes that that would help, but I just get continuous error messages. I am currently working with my producer and we have a shared iCal calendar, so I need to be able to integrate it into AirTable so we can see all of our upcomings events. Thanks for the help, Christi

I am brand new today, I am trying to import an entire large spreadsheet from Google sheets with Tabs. I have added my google account and I am prompted to sign in to google, then it won’t let me and says error. Help

I have a table with a column that links to another record. This column allows linking multiple records. Is it possible to create a form where people can select records and add a comment on them? I want to be able to link a record with a comment.

Hi Airtable Community! I’d love to create an automation from Table A, so that when I click “Send Invoice,” it will update all the records of Table B by changing the “Sent Invoice to Client” from “No” to “Yes”. I believe I’m stuck because I’m trying to pull a string of Record IDs from Table A’s lookup field and then update the Record IDs as individual rows in Table B. Is there a way to do this? Thanks so much for all your help!!! Cameron!!! Screen Shot 2021-02-12 at 3.06.51 PM|700x283

Now that I’m on a Pro plan with more tools available to me, I’m trying to eliminate a spreadsheet from my workflow because all the data in it stems from AT. Surely, AT must have the ability to summarize all of this for me. I have a table in my base where I track what I’m working on each day. I can have multiple records with the same date. I then use views to get a summary for a specific date or for a whole month. I can see my total earnings and time worked for that view at the bottom. Is there a way to link to those numbers in another table so that I can then use those numbers to do some calculations? The only way I’ve figured out how to get to what I want to do is a combo of a linked field and a roll-up, but the linked field can have dozens of records I have to add manually, so I could miss one. It would be so much easier if that record field could immediately link to the summary of a view in another table.

Hi - I’ve created a shared view of a table but it doesn’t seem like the shared view gives access to linked field data (linking to another table in the base). I suppose this makes sense. Is there a setting I can use to change that?

I am unable to find way to view all the collaborators for the workspace where I am the owner. When I go to permissions using share and selecting “Add or Manage Collaborators” it only show me as “owner” simply says “there are 7 collaborators not shown above” with no apparent way to show them.

Is there a way to show a dotted line relationship in the org chart app?

Hello, I am not sure how to word this and did not find any topics that matched what I wanted to achieve, so I wanted to ask if this is possible. We track all of our orders within one table. Each order has a unique name. That name comes from a ticketing system. (Example REQ0000001) We have a team of about five people who pick these orders to ship off to customers. I am often asked what is on the order because sometimes all the fields don’t populate correctly on the ticketing system. What I am trying to achieve is a self-serve user portal, where the team can type the request number and they are shown the line items of the order. I guess like the opposite of a form entry, but instead a record lookup. Any ideas would be appreciated. I am guessing, I might have to use a third-party app to achieve this.

How would you set up a database to show the latest and historical use of resources? I run a monthly photo competition. We have one to four judges score the images submitted. I’d like to be able to enter the month and year each judge participates. When I look at my list of judges, I’d like to be able to see when the last time was they participated. I’d also like to be able to see the history of how often they’ve participated over at least a few years. I don’t want to have the same judges participating too often, but I also want to be able to see who has been available if I need to replace someone in a hurry. What kind of field or fields would I need to set up in my database of judges to be able to quickly see this information? Is there a field type where I can enter a list of participation dates? Thanks for your help! Vicki

New user. Just started exploring my base and looking at the community for best practices, but unable to find a simple way to do the following: I have 5 tables in my base, and of course I can see all records in each table. I need for a user to have a similar base as mine, with the 5 tables, but only view/edit their assigned records in each table. One solution I’ve seen is to filter, but it looks like the user can just unfilter and view/edit all records if they so choose. Is this not possible? Still trying to decide if this application with be a viable solution for our company. Cheers

I have an embedded sheet on a page on my Carrd.co site (http://database.hoobastonks.com/). It is password protected. The flow to unlock it works great on desktop (Chrome browser). But on mobile (iPhone - both Chrome and Safari) it is broken. I click the link to enter password and the page kinda freaks out and reloads. Help?

Hi there, I have two plugins in my Wordpress WooCommerce installation and some product attributes which I like to pass on to AirTable. I’m struggling to find a good way to do this. Delivery or Collection Date (generated by “Order Delivery Date Pro for Woocommerce” plugin) gift-message (generated by WooCommerce Checkout Field Editor) And also product attributes (not sure if they appear or not in the field mappings as default) I am looking at Integromat and Zapier as possible connections at the moment but not sure whether they support these fields. I’d love to hear any experience or comments you have :slightly_smiling_face:

Hi there ! I have 3 tables : CONTACT LEADS ADMINISTRATIVE FOLLOW If the customer pick one service in the table contact, I have multiple field checkbox set up to check to follow the process for this specific service (in the administrative follow table). Then i have a SUM formula that counts the number of checkbox checked to see task completion. This part works well and is perfect for me. Service 1 : needs to get 10 checkbox checked to be completed Service 2 : needs to get 14 different checkbok checked to be completed Service 3 : needs to get 20 differents checkbox checked to be completed Question is : How would you set up when a customer select let’s say 2 services (or 3) to affect the necessary checkboxs to show ? and then add a global task completion ? Any clue ? thanks !

How can I fix it?

Hi, I’ve got the form embedded in my website and that has been absolutely fantastic, but i find the load time absolutely astounding-- its at something like seven seconds. I wonder if this is because we get so many form fills-- there are 1000 responses-- or whether it’s inherent to the form being embedded in auto-sized height view. I’ll just link the responses to another base if that’s the case, i just don’t want to flaff around if it ends up being Wordpress, my OceanWP theme or the Elementor page builder. Thanks!

We use airtable to keep track of our clients and their projects. The clients place an order, and all the information appears in our airtable. We would love to have a way for our employees to update specific jobs without having access to the airtable. Ideally, if they could fill out a form and put a specific job # in that it would match the existing job and change the status of the job and assign their name to the job, that would be ideal. The goal is instead of giving them entire access to the airtable, they are only able to view and make specific requests. We want them to only have the ability to assign themselves and change the status of a job.

Hi there, How can I cancel the free trial that is automatically implimented when signing up for Airtable? I want to try the unpaid version first to get used to it and see if it is something I want, then if it is, go to the trial, and then to the purchase. Do I have to just wait for the 14 days for the trial to end? Thanks in advance.

HI All I am wanting to have a trigger set for a reminder to follow up on a job/task, eg; when something is urgent i want it flag me every day, important every 3 days, general every 7 days, once i have followed up and changed the dates of last follow up. I can’t seem to get the trigger to work when i’m trying to set up in automations.

Hey all, can anyone say if it is possible to export to excel sheet and have the links for the photos made clickable inside the excel sheet. For now, I understand that the links comes as a text and if you take more than one photos for each line item it comes as a single text. Can I make this split into two columns or at least make it clickable? Thanks in advance.