Other Questions

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 )

I’ve a Pro workspace so was hoping to achieve my desired outcome with the Page Designer Block. Although I can get the layout I want, I can’t easily export a png or JPEG for quick use on social media. I’m new to Airtable so think I must be missing something obvious. I’ve done a lot of searching but haven’t found anything suitable so if anyone has any advice I’d be grateful. My objective: I have a base with a sports team’s player names and their photo. The team manager selects the team by adding the chosen players to a multi-select field. I then want a single team image of the players’ names, their photos (from the base). If you’ve ever watched sports you will have seen this sort of thing a lot at the start of matches. My current workaround is to use the Page Design Block and show the custom page full screen and take a screenshot. I’m worried the only elegant solution is some custom Python with the API so I’m hoping someone can suggest a more time-efficient route!

I cannot figure out how does Integromat Trigger field work? What does it actually mean? I point IM to watch an Airtable and set the Trigger field to date created? I run the scenario and it pulls the record. I I run it again, it gives me “null” result. Does IM look for the latest item in the table and once it registers it, it never touches it again? What if there is is more than one entry? Can someone please explain the flow behind the Trigger field?

Attachment field type has a nice preview element for audio files. They can be played by clicking on the ‘play’ icon. Is there a keyboard shortcut for playing those file? I didn’t find it in the official list.

Not 100% sure where this should go but: I am using airtable as a database for the teas we have in stock. However, when a tea goes out of stock, I would like to mark the item as “finished” and relocate it to a new table automatically so it isn’t included in the main count and doesn’t clutter up the table. While I know I can do that using a filter, people who are unfamiliar with airtable (or even spreadsheets/databases) have found this difficult. I don’t want to lose the information entirely since it lets me know if something we got didn’t go over well and we don’t want to purchase again or if it’s something we really enjoyed, I want to be able to quickly add it back to the main table. Please let me know if this is possible? I’d rather avoid manually moving this data but understand if that’s the only way.

I have a separate table for contacts, name, email, tel, address, etc. In the primary field, I enter the person’s name, eg. John Smith. Having read somewhere useful for the base design to have separate fields for a person’s name, I have added two fields immediately to the right of the primary, field name FN (for first name) and SN (for surname). Each field option Single Select. Which means that whenever I add a record in the primary field I also have to add the person’s first and surname separately to the respective fields. I sort on primary field and that suits my needs, as in the event not finding instantly does a filter or simple search. But unless there is some benefit to the database set-up evolution in having two separate fields for FN and SN I can’t see any advantage. Is there? and if so then what is it? tia

Why can’t I see all of my records linked into one field where there’s 10+ records linked?

Hi, Is it possible to to assign gmail thread to Airtable record? Thank you, Pjero

Hey guys! Does anyone know if embedding a video on an airtable form is possible?