Other Questions

Hi folks, I’ve done some searching and haven’t been able to find a clear answer on this. I’m a new user to Airtable and have been looking to understand a bit more around its integration with desktop prototyping tools such as Axure. Is there any recommended desktop prototyping application that integrates with the Airtable database? I think Airtable has some functionality with forms but nothing as robust as Axure or Sketch. I know there is also Adalo integration but I believe Adalo is for mobile apps. Thanks in advance! -Marc

I’m hoping to create a script that pulls a field from an Airtable, enters it into the search bar of a website and then copy and pastes the results into another Airtable. Is that possible? How would I go about creating something like that?

I haven’t messaged anyone directly on the community forums in a while, but it appears as though the option to message individuals is no longer present. Has this ability been removed?

A newbie here, trying to understand what is possible with Airtable. I am involved in a project that is about informing about local food products. Basically, it is a couple of text entries and a picture with each product. Ambassadors with a separate login will visit a store and take an inventory - which products are available and in which store? All products and where they can be found must be viewable via a mobile or desktop browser by anyone without logging in. Is it possible to do with Airtable? How would you do it?

Hi there - WHats the best way to show bar chart, that shows 3 month’s status? I’ve been able to do the month1 status (see attached screen), but wanted to add month2 and month3 for each stats (so each stat should have 3 bars to represent each month)

Hi there - What’s the right way to display a chart that shows 3 months of progress per status? I wanted to show a chart that has June, July, August by status (# of complete vs incomplete), so ‘complete’ bar visual will show 3 bars (for June, July, Aug) and same for the ‘incomplete’ bar. APpears to be possible based on the sample chart on airtable, but I am stuck! Help.

I’d like to understand who Airtable’s cloud provider is - AWS? Azure? Is it in house?

I’m trying to build a DB to track individual athlete scores over multiple seasons and competition categories. I already have a database of fixed athlete info (name, age, email, etc), but I’m not sure how to: A) configure the record tracking DB B) connect it with the individual athletes Example of an individual athlete 2018 season for ‘Under 18’ in ‘Couples’ Round 1 score = 1 Round 2 = 2 Round 3 = 3 Total 1+2+3 = 6 Rank (for 2018 in ‘Under 18’, ‘Couples’) = #10 For the same athlete: 2019 season for ‘Under 21’ in ‘Singles’ Round 1 = 3 Round 2 = 4 Round 3 = 5 Total = 12 Rank (for 2019 in ‘Under 18’, ‘Couples’) = #5 Athlete Record Database

Hello all. I’m new to scripting in Airtable. I’ve learned a lot from this forum but cannot resolve a multi-record linking problem. I have a table of People with a field called Crafts which links to a related table “List - Crafts” which includes records for Director, Writer, Producer, and so on. In a People record, I want to populate the Crafts field with multiple values. For example, in the Person record “John Doe” the Crafts field would include Director and Writer. My code queries the “List - Crafts” table and stores the relevant record IDs into an array named idYouNeedArray. It’s my understanding you need to pass an array of strings to populate the field with multiple values however this code does nothing with the Crafts field. peopleTbl.updateRecordAsync(foundPeopleRec, { "Crafts": [ {id: idYouNeedArray} ] }); The only way I can get multiple values into the Crafts field is with this: peopleTbl.updateRecordAsync(foundPeopleRec, { "Crafts": [ {id: idYouNeedArray[0]}, {id:

Records in my Questions table are linked to a certain view within my Answers table. While viewing the Questions table, I want to create a record in Answers linked to the question. this is easy with the little “+” sign. But I want to create the new Answer record with pre-filled fields so that it matches the view to which it is linked. This would be similar to creating a record while viewing grouped records… it prefills data to match the group. Is there any way to do this?

Hi, I’m wondering if anyone has had any luck with creating a burndown chart within the chart block of Airtable? There are a couple of topic discussions from a year or two ago but there aren’t really any specifics. Has anyone been able to implement? Thanks!

I signed up for the free version to decide if Airtable would work with my project. It looks like from what I’ve tested and read, if you link a record in an embedded view, the linked record will only show its name. I would prefer the person to be able to click on the linked record to view it. I’ve looked at lookup fields to display the additional data and may have to go that route with multiple views since there is alot of data. I was just wondering if anyone had other suggestions.

Hi All, I have a base that acts as a Property Management System with multiple tables. Two of those tables are the “Contracts” table and “Bills” Table. I have been using the new scripting block to streamline all of the daily processes: Recording new payments received and issuing receipts, creating customised reports of income/outstanding bills reports, by City/Property/Tenant reports …etc. I am finally at the last step where i am attempting to create a script that prompts the user to insert all of the relevant contract information and creates a new contract record in my “Contracts” table, and then also automatically adds corresponding bills (in the Bills table) in the wanted frequency (i.e: 12 bills of monthly rental payments with due dates and amounts), and finally links them to the contract. However, I am getting a strange behavior when adding the bills. The creation of the contract record works just fine but when the script attempts to add the bills I get the following error: Syntax

I’m using a form to collect data. I have a checkbox at the end which is required to be ticked. But the box is very faint on certain devices! I’ve included two screenshots below. In the first one, the tickbox is there, but is almost invisible. Once ticked, the box is really easy to see, as shown in the second screenshot. I assume this is related to the theme, but I also assume that I can’t change that?

Is it possible to import from csv and overwrite the current data in airtable? We intend to use Airtable to schedule and track email campaigns. Once the campaign is created we would go back to the record and add the data for opens / clicks etc The data changes from day to day, so we need to overwrite the current data with the new data.

“https://api.airtable.com/v0/appk6Z1pKED33CpCK/Table%201?maxRecords=3&view=Grid%20view” guys here in this link, there is something caled maxRecords=3, how do i write it such a way that , it will give me records as long as there are records. i want it to change dynamically. imagine i told max record to 5 today. but tomorow 6 rows are created. so dynamically i want all the rows to be fetched

Hi, I’ve shared a base for collaboration with one person. I’m also using this base as main database for my work. I would like to add a field for each line created (each line represents a new client, with a new job) where i can add some secret informations that i don’t want to share with the other person. How do i do that ? it’s text information. Thanks

Hi Airtable! I thought this might be of interest. Integromat has changed the number of active scenarios for the Free Plan. Integromat Pricing Get unrestricted access to every feature for free. Cost-effective plans for individuals, teams, and businesses. Custom enterprise automation solutions. With Integromat, everyone gets to automate. Mary Kay

I’m so confused using the Dedupe block. It doesn’t MERGE anything. It just keeps the primary record. Let’s say I have a table with Name, Email, Phone, Address, and Transactions. I select find dups records as Name and Email, 2 Records appear. has the phone and transactions. has the address How do I merge the address into record 1 or the phone and transactions into record 2. So I only have one records the with Name, Email, Phone, Address, and Transactions. What am I overlooking?

I’m trying to save our school some money and create a base that allows me to use the barcode scanner to keep track of the students in the breakfast program. I want to use the barcode scanner to scan their student id when i create a new record. I have one table set up with the students info, but how do i get the other table to look up the barcode i just scanned, and see it as the student? I’m having a hard time with the logic.

I have a Sheet… Work items … it is related to customers … In the Work items sheet I have a field that has this formula in it … Customer & “-” & AutoNumber I want the auto number to be 1 more than the customers last work item for that customer and not the next auto number … is there an easy way to do this ? Customer 1 Work item 1 Work item 2 Work item 3 Customer 2 Work item 4 Work item 7 Work item 8 Customer 3 Work item 5 Work item 6 What I want is this Customer 1 Work item 1 Work item 2 Work item 3 Customer 2 Work item 1 Work item 2 Work item 3 Customer 3 Work item 1 Work item 2 Work item 3

Hi I’m totally new to Airtable, it seems we can do a lot with this tool. I’m an intermediary with the job to find clients and give them to professionnals. Right now I’m billing a commission directly to the professionnals, but i’m planning to bill directly the client in order to increase my commission %. I’m waisting a lot of time within my business process : I receive a call from a new client through Aircall.io I write down on the Aircall notes his address, name, issue, email address I copy the informations and paste them in Whatsapp, or SMS, or Email to the professionnal who will call back the client in order to do the job I write down the same informations, with more, on a Google sheet (date, time, the name of the professionnal, and the other informations we already know) I go to Zoho CRM and create a new client, and within his profile, I create a new job with the subject in question (a client can have more than 1 service with us) I’m waiting news from the professionnal if the job

Hi, I’m wondering if it’s possible to have a multi-item order record and deduct from our inventory table without having to enter each item in the unique orders as a separate record. For example, if Stefani places an order as order number 100 for 2 chicken breasts, 3 racks of lamb, and 1 whole chicken (we are a butcher shop), I am currently entering order 100 three times, as three separate records, so that I can use a quantity field to deduct from our inventory table. Is there a way to have Stefani’s order under 1 record, and still have each of those items/quantities deducted from our product inventory? Thanks! I’m new to Airtable so sorry if I didn’t explain well. Melissa

Hi - We have some members on our team that are now NOT receiving emails. They are collaborators and do have the email notifications on but not receiving any notifications sent to their email like they used too. Is there anyone that could help? Thank you.

When I adjust a predecessor to end earlier, how do I get the successor to also start earlier? ie - how do i create a fixed finish-to-start dependency with a fixed amount if time between them? This is how every other gantt schedule program I’ve used does it ( ex. finish-start + 0 days )