Other Questions

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?

I want to clone a field from Entity 1 to entity 2, usually this is trivial. But the field is an attachment field, “cmsLogo”. When I use values, it “works” but shows a weird formatted string. I tried other options such as values.1 and values[1] but no luck. Any idea how to get the url only?

Hi! Is it possible to save the names of uploaded files? I use Airtable to backup my Cognito forms using ZAPier. Everything works great, but filenames change during synchronization.

Is there a way to use Sort or Filter and then have each set of results be separated onto a new table (or new export)? For example, let’s say I have 3 names: Al, Beth, and Cindy. When I Sort/Filter by name, Al has 2 results, Beth has 4, and Cindy has 5. I know I can Filter by Al, Beth and Cindy separately, and then copy or export the results. Which is ok for 3 names, but very time consuming with 100 names. Is there a way to have the results by name automatically populate onto separate tables or separate exported files by name? So that Al’s results, Beth’s results, and Cindy’s results are automatically separated for me?

Hi all, I’m so new to Airtable and just working through its potential as I need it. I need to create a players’ list that reads on a form: Player 1: xxx Specator Name: xxx Spectator Mobile: xxx Player 2: xxx Specator Name: xxx Spectator Mobile: xxx Player 3: xxx Specator Name: xxx Spectator Mobile: xxx And so on and so on… I cannot figure out how to get player info on the ONE LINE in a form. Am I missing something? Appreciate the help. MB

How can you “catch” a change in the value of a table cell and perform a specific action? (as a trigger)

Hi folks, I’m having alot of issues calling the records array that holds all the column data in my grid into my chart.js react file. Currently I have a static array in my data field where I am manually entering inputs but I want the data field to be able to read directly from a specific column array so it will update dynamically? Does anyone have any examples on how to have this done?

Hello! I’m trying to automate my airtable with integromat (excel data to airtable) and I manage to do it. But the only way a found was in the record detail (level). So if i have a table with 20k records, i need to delete one by one and upload one by one too… It works but takes too much time to complete. Does anyone know how (or if its possible) to do delete all the records from the table with integromat? The same thing to upload. Thanks!

hi, i’m from Moldova, our contry code is +373, i want to enable two step authentication but it’s not possible for my country, i need to enable 2fa using mobile app, why you don’t give option to enable 2fa, and give a list for emergency codes, like other services! error: Error submitting phone number; please try again.

Hi, everyone! I need to devise a formula that can extract the date from large numbers of text strings that look (more or less) like this: Purchase authorized on 02/08 Starbucks Card Rel 800-782-7282 WA S466038798107217 Card XXX Purchase with Cash Back $ 20.00 authorized on 02/08 Vons Store 2665 Los Angeles CA P00466040145047099 Card XXXX Purchase authorized on 02/09 Arco #42938 Los Angeles CA P00466040490070986 Card XXXX Purchase authorized on 02/08 Rudy’s Barbershop S Los Angeles CA S286040133024078 Card XXX Purchase authorized on 02/09 Lyft *Ride Mon 7 Lyft.ME CA S386041115222697 Card XXX I guess the formula would have to FIND the first occurrence of the “/” symbol and return the two characters that come before and after it but from there I get lost… Any ideas, team? :slightly_smiling_face: all the best!

Hello Airtable community! I’m trying to set up a Zapier to send a new record to Mailchimp via Zapier. I have birthdate set in the correct format US style which is what Mailchimp is too. However it seems Airtable is sending it to Zapier YYYY-DD-MM Can anyone help me? Thank you so much!