Other Questions

Running into a problem creating an order tracking form. I have 4 tables Customer Info - name, address, etc… Product List - products and prices Orders - each row has customer name and product and product quantity purchased. Primary field is a formula concatenating Customer name and product they purchased Now I’m creating a 4th table Order summary by customer. Primary field is an Autonumber. Second column is a linked record to Customer Name pulled from the Customer Info table. What I want to do is group by customer, everything they ordered and the total they owe. Where I am running intotrouble is I can’t pull the Quantity field from the Orders table using a Lookup; I don’t know why. Please help! Thank you

Hello Friends! I’m not sure how to do this but perhaps there is someone out there that can help me. With all my records we use 1 image to quickly identify the type of record. For example,: We have a tab with all our webinars. We use two images to identify which is which (CRO or PV). To do this with each new record, it’s annoying to upload the same image repeatedly. I like the idea of using the BUTTON feature to attach an image, but the issue is that it will only add images from Pexels. I’m looking to upload images from within my base with a table dedicated to images acting as a portal. Does this make sense to anybody? Any idea how this can be done?

Hello everyone, I’ve had a look on the forums and haven’t found a mention of this, but is it possible to have air table automatically rename attachments. For example. If I have a record named Ross and there are four images attached for those images to be named renamed ROSS-1.jpg, ROSS-2.jpg, ROSS-3.jpg, ROSS-4.pg? Thanks so much!

Hello Everyone, We have the requirement as explained below. I would like to understand how it can be achieved in airtable? The steps are as follow. There will be a form-1 where in user enters “company name”. Click on “Generate Data” button. This button will call the script to invoke external API.And whatever response we get from API,those responses will used to buld the airtable form-2 link with pre-fill option. After that, flow will be redirect edto this pre-filled form-2 link automatically. The challenges in above approach is as flollow: For step-2, when end user will click on generate data button This action will call some custom script to fetch response from external API. So, my doubt is how to build form-2 link using pre-fill option with the values got from custom script/external API on the fly. Apart from this, Let’s say we are on form-1 and clicked on generate data button. So, is it possible to display responses got from custom script/API on same airtable form? Please su

Hi community, I have a question about using Airtable to manage the creative team workload over time. My goal is to build an Airtable template and ask the team members to write down the number of hours they spent on every task on a daily or weekly basis. And keep these records in the Airtable. This could help us to keep track of the busy weeks and days that are less packed. E.g., my producer can put down 2 hours today working on a video shoot task for planning, and 8 hours tomorrow on this video task again for onsite shooting, then 5 hours the day after tomorrow for this video shoot task for post-editing. As you can see, I need a series of fields, that are connected with consecutive dates, and to be filled with numbers, which are the working hours. I can then calculate the total hours they spent on a task easily with a formula. But I’m having difficulty building this template. Does anyone know how to achieve that with the Airtable? I’m open to any suggestions from using a template to an

Hello Everyone, I am really one man person try to build a system for the institution… I try a few things but seems not really work, so I am thinking can one grid view, just show one specific selective group? Hope anyone can kindly give me some inspiration about it! Thank you again.

Hi, I’m so sorry to be repeating what other people have already asked, I have tried a few of the solutions previously suggested, but I am such a novice, I’m obviously doing something wrong. I’m hoping that if I give my specific examples someone really clever and very patient can give me a step by step idiots guide please. This is the simplified version: Table A = purchase orders to buy various types of material Table B = batches of material booked into stock (from the purchase orders) Table C = customer orders to sell the material These tables are linked so that every time a purchase order is completed (Table A) the material gets booked into stock (Table B) and the quantities increased accordingly, then every time a customer order is completed (Table C) it deducts the corresponding quantity from stock - so far so good. In Table C there is a link to Table B check the stock levels and I want to also at this stage be able to see at a glance the price of the most recent batch purchased wi

I’m wondering if there is a way to setup a view similar to the Dedupte extension, where you can see duplicate entries that compare 2 columns of information. I like Dedupte but I want to use the automations feature to send myself an email when a duplicate entry is created.

I have a team of creatives that are scheduled on a shared calendar and all tasks are color coded to signify who is assigned to them for our coordinator to manage individual capacity. Many of my team members have been given the same color for their profile. I would like to change the users colors but can’t seem to find a way to modify that detail. Any help would be appreciated!

I have a base that includes tables synced to three other bases. I would love to be able to provide a visual representation of the base schema INCLUDING where the syncs come from. I want to be able to do this to show my colleagues what the entire flow of information looks like, making it clear that they will need to enter certain records in the source(synced) base rather than into the base where the output from the sync is.

Thank you in advance! I’m new to Airtable and have watched several tutorials and still I’m stumped. Here is the situation I have is a base with 8 Tables. Table 1 is the master list of products I sell. This table has fields with my product name, and number, etc. The other 7 tables are vendors where I can buy the products. Each vendor has a different name and price for the product. The first 5 fields on every table is the name of my product. The goal is to be able to move from Vendor A to Vendor B and so on and see my name and color of item and compare it to the Vendors product name. What I want to do is have the first 5 fields on table 1 linked to the other 7 tables. The goal is when I discontinue an item on my product list (table 1) and change the status to discontinued then the status changes on all the other vendor tables. Or if a vendor discontinues a product, I can change the status on the vendors table, and it will change on all other tables. I hope this makes sense, an

Per the attachment changes after Nov 8 - Any attachment URLs obtained via the public API and the CSV export functionality will expire after a few hours. If I am using Airtable as a CMS for my own site where the data (and attachment column) is being fetched via API, what url will the API return 2 hours after the attachment as been uploaded? For example let’s say the original url of the attachment is airtable.com/image-first-location.jpg, I understand after 2 hours it will return 404 not found. However if I make a second API call after 2 hours, would the url returned for the attachment field be a new “working” url such as airtable.com/image-second-location.jpg or would it still return airtable.com/image-first-location.jpg (404 not found)? In other words, if the user visiting my site refreshes the page (thereby making a new API request), would it get an updated (working) attachment url?

So this is my situation at the moment: I have a table called PAYMENTS in which i record payment on invoices (generic information). I then have another table called REBATE which has all the detailed information (including the generic which is pulled in from Payments) with a line per line item in the invoice and lots of other info on the line item. Would it be possible that from the Payments table i create a BUTTON that would pull all the line entries in the REBATE table and show them in a sensical manner for the user to understand? Thanks in advance M

Hi, Is there a way for a list of multiselect labels to appear in the gallery view without getting cut off?

Hi, When I fetch my records through the api, the text is cut off. For example: “text field” : “Very long text. Et cetera Et cetera wil but cuff. Like thi…” Is there any way to get the full text content?

TLDR; it’d be dope to have a new method in the Airtable API that allows you to trigger a base’s sync. I have two bases: one for a crm, and one for projects. The projects base has a table for projects, and two synced tables from the crm, one for people and one for a subset of companies that are clients. I have automations and scripts in the projects base that do things like Creating Invoices and Tracking Time, which call external APIs that return information I’d like to update on the crm, like a customer’s Stripe ID. I can do that using Airtable’s API, but then the current base I’m in becomes stale. It’d be great to sync the base at the end of the script or automation so that future scripts and automations can use the synced data.

Hi all, I’m currently the Airtable Product Owner for my organization and in about six weeks I’ll be hosting a handful of internal trainings at my workplace. I’m planning on Airtable being the focus of the training, however the training itself can be very general – the only requirement is that those who attend walk away with 3 takeaways. For example, our social media team did a training last year that revolved around general social media, and their 3 takeaways were: How the social media landscape has evolved and where it’s going How each channel is different and content best practices Social media at work and how to use it to increase your paycheck I have a few ideas as to what I might do, but I’d like to get some community feedback to hear any ideas that you may think be useful to present to groups of hundreds of people who have never used Airtable before. I’d like to touch on the importance of organization and tie in linked records. I’d also like to start the presentation with an Ai

Have a question regarding the correct Airtable implementation for a unique situation I am currently facing. I want to have a Subcategory column in my table that is of type multiple select and then have a following column that directs all the possible combinations of Subcategories into 3 different groups (1, 2, both) and a simple conditional statement can determine this. Unfortunately, I cannot use a for loop in the Formula builder correctly so the function does not work correctly. Now I am wondering if I should implement a script to create the desired column or is this overkill and is there a simpler solution? Apologies if my explanation is not clear and can dive into more detail upon request. Thanks!

Hi guys, I have this base here where we put all the projects we take care. 1° e 2° columns we have the name of all projects and their groups. Every 3 months, they have to send us a few documents for project accountability (each project has a specific date). We have the columns with the dates and others columns enumerated with 1°, 2°, 3°… accountability, so when the date comes, an automatic e-mail is sent to them (the automation takes the columns: name, group and number of accountability). The e-mail is something like: 15 days to the project XXX from YYY send us the Z° accountability. But the problem is: we have many accountabilities for each project (like 10 or more), we are taking more than 10 automations (synced to each date column) and we want to put it all in just one automation. Someone knows how to do it? The idea is creating a formula that recognize the date and takes its accountability number column

Hi, i want to share a view to my employe, in a new base, from a general base. In this general base i have some partners. Is it possible to do a sync base with filter for my employe that he’s seeing only specific data ? iI don’t know if I’m making myself clear, thank you for your feedback.

How to make a base private in a shared workspace?

I’d like to be able to reorder fields, sometimes several at once. Presently, I’m clicking on a column and dragging it. Is it possible to reorder multiple fields at once?

In Interface - Is it possible to improve the amount of detail shown directly on a line chart? I’m looking for: -a point at every data point (instead of just a line with no points) -a label for a price at each data point (not just on hover over, but directly on the chart) -more frequent numbers/hashes on the Y-axis (my y-axis price) -also looking for the ability to not aggregate… -also looking for the ability to have multiple groupings -would also be wonderful to have similar functionality to the Charts extension where you can click on a point and open up the record from the Base… …any tips appreciated!

Hey AT community! Been working with Airtable for only a little while now and having trouble coming up with a formula that we will use in many of our tables. I would simply like to input an amount in a USD$ field and have it automatically appear in the €EUR field by multiplying it against an exchange rate (ie. 0.93) Often, we receive both currencies in sales or donations. In other words, if the Euro field is empty and the sale was in USD, we could enter the USD and exchange rate and have it calculate and populate the Euro column. Here’s a screenshot of the columns and what I’m trying to figure out. How would you suggest I do this? Thanks in advance!

So, one of the repetitive tasks that I have is to go back to a certain day when a receipt was made and find the USD to EURO exchange rate for that day – and then robotically and often zombie-like paste it into the record in Airtable. Here’s my question(s): WHERE do I find a site or a feed that I can pull the historic exchange rate from (which plays nice with Airtable) and HOW do I script it to look at the date and get that information? I’ve tried various sites and ways to do this and have not had much luck at all. I need more brains - your brains. (trying to stay with the zombie theme a little bit) :slightly_smiling_face: thanks in advance!