Other Questions

Hello, I’m currently trying to take my primary field in a table and concatenate based on what applies. The table itself is pretty basic - using it for client information; i.e. First Name, Middle Initial, Last Name, Spouse First Name, Spouse Last Name, and other basic information. We have some clients where we want the spouses other last name for whatever reasons. What I’m wanting to do is have the primary field concatenate certain information when 1 IF applies, OR concatenate different information if the OTHER IF applies. For Example: IF({Spouse Last Name}!=Blank(), Concatenate({Last Name}, ", ", {First Name}, " & ", {Spouse First Name})) -OR- IF({Spouse Last Name}, Concatenate({Last Name}, ", ", {First Name}, " & ", {Spouse Last Name}, ", ", {Spouse First Name}) My problem is combining those IF statements so that both would apply, so IF it meets criteria of 1, it applies that concatenated formula, or if it meets the criteria of the

I am just getting familiar with Airtable, doing some test driving, so sorry if this has been answered elsewhere and I just couldn’t find it. I would say a vast majority of the Projects we do all use the same tasks over and over. Is there a way to create like a “preset” when you add a Project it just pre-populates a set of all the common tasks? I’d considered just using 1 task that is attached to multiple projects but we’ll track time on those tasks and although they are all the same task they may take a different amount of time to complete. Not to mention, different employees may be completing them so they’d need to be assigned to different people.

Is there a way to view all of the field permissions that I have set in my base or do I have to click on each field individually and check there?

I’m rather new to Airtable but I’ve been playing around with it this week and I’m not finding it easy to do what I want to do. I’ve searched the net and all roads point to using Zapier to copy data from one table to another. Here is my situation: I have a table called Scheduled Orders that has the same data every day. Quantities/Prices might increase over time but the idea is to have one master schedule and every day at said time, it will create these order in the Order Board table. I have not found a way to do this and my Zapier “zap” is not working. I need some help from users who may have done this or something similar before. Summary: Select all scheduled orders from the scheduler table. For each scheduled order, populate on the Orders Table. I need to create a new order each time. Any help greatly appreciated. Jason

Hi community ! I have ann issue with a zap (by zapier) I use to send a mail to each new users (in a record). I would like to display in a view records that follow certain criteria. The fact is that a record can appear in this view, disappear few minutes later, and appear again. I would like to send an email each time this record appear in this view, but it doesn’t work, it seems like the record is save in zapier memory … Do u know if i have to wait a certain time till the record id is forget ? Thanks by advance !

Is there a way to copy and paste a whole row or column? I would already have the column name and type set up -i just want to copy the information in the rows and columns. It doesn’t seem to let you copy and paste more than one cell. I’ve tried dragging to select and holding control while selecting but that doesn’t seem to work.

I am trying to setup a client portal with an external plugin. In my table, each record represent a client case. Considering to setup a simple login mechanism. Is it safe to use the RECORD_ID() as the password of the particular record? Or any workaround to generate a random password for each record (case)?

I have a business that deals with a single recurring service, typically occurring every 1-3 years. My intent in using Airtable is to manage all of my Contacts, Services Performed, and the ability to identify when a Contact is due for a recurring service. I currently have a Contacts table, as well as a Services Performed table (I have Zapier add the performed service, pulling from my Google Calendar). I link the two tables via phone number. I would like to have all the dates that the service has been performed for a contact displayed in the Contacts table in a single cell, with the ability to roll it up to most recent service (or just add another cell to do so). Additionally, I would like all corresponding fields updated (or added if different). Also, if possible, I would like a new contact added if there is no match in Services Performed (though this may only be possible through Zapier). Thank you in advance for any help, and please ask me for any clarification

greeting - airtable noob here with my first post :slightly_smiling_face: i need to take a text string from a field called NAME - make it lower case - and then do search and replace for a number of characters . I have it working for one condition - replacing spaces with dashes. SUBSTITUTE(LOWER(NAME), " ", “-”) now i need to find special characters like ( ) " etc and eliminate from the string. is there a way to nest multiple commands…? or…? thanks!

Hello, I have a question. I have a table Product that has a Product name and Barcode, and I have a Sales table then I want to scan the barcode and I want it to fill the product name based on barcode connected to the Product field. I am trying to create an inventory tracking system.

Hi, I’m doing an assignments per person in one table. I have at least 60 persons who works on different tasks\record which are in rows and I don’t want other persons to see different tasks that were not assigned to them. Is it possible for each people to just see the only records or rows that were assigned to them? and hide other records or row that was not assigned to them?

I can try to export page designer (200 Records) to PDF file and then PDF file is not complete My PDF file All page and All Element move down in every page (Logo / Header / Picture / Etc.) Pls share “How to exporting report PDF complete ?” Thank you :slightly_smiling_face:

I have a multi-select field type (first column), I want to have a multi-select field type in second column based on first column options, but I need to omitting options which are selected in previous cell automatically. How can I do that? Faithfully Yours,

I have the pro version of AirTables and would like to be able to completely lock a table so no one can add or remove any information. I’ve changed both the table permissions and the view permissions, but I can still add information to the cells in the table as well as add fields.

Hi - I am trying to move from Smartsheet to Airtable, but have a specific way we track phases of some of our jobs. Attached is a screenshot of our current Smartsheet that allows for a customer line with all of the associated phases to be beneath and associated with the parent row - and the dollar amounts roll up. We track each phase as individual “jobs” beneath the summary job and the ability to “collapse” on Smartsheet limits a gigantic sheet. I realize the structure of Airtable is different and most likely is not able to re-create what I have, but I do need to be able to have the same basic idea and not sure where to start. Thanks for any input offered!

Hello! I was wondering if I was to give someone read only access if they are then able to duplicate the workspace for their own use. (please note this is what I want them to do). Thanks Kristy

What determines the 3 fields in the screenshot (Product Title, SKU (Supplier), Supplier UPC) per record to show below? Initially thought the fields reflected follows the order of the fields/columns in the View that’s being searched, but that’s not it. Thoughts?

I am designing a new base for tracking client accounts. We currently have approximately 12 clients, but are looking to expand our services in the next year. Each client has 1-5 accounts with up to 5 sub accounts. The accounts are prepaid and I want to ensure we don’t go over budget. The expenses are divided into direct expenses (paid by us) and reimbursed expenses (that we will issue payment for). I would also like to submit the expense information using a form and then approve the expenses monthly. I want to create the following views: Break down of client accounts and sub accounts with the detailed expenses Summary of client accounts and sub accounts that only shows remaining balance Reimbursed expenses each month Direct expenses each month I would appreciate thoughts on how to cleanly design this base. Thank you.

Hi everyone, I have a base where I have a list of invoices which have a date an an amount. I need to know the average earnings for each working day of the month the invoice is billed. To do so, I wanted to calculate the number of working days for each month of the invoices. I saw that there’s the WORKINGDAY DIFF formula, but to make it works I’ll need the first and last day of each invoice, as the screenshot below: Here, for example, I entered manually the 1st and last, but is there a way to automate this? With my manually entered 1st and last date of the month, I calculated the working days for the month. Then, I created a formula which calculate the average amount billed each day from the amount of the bill (Formula is: Amount of the bill divided by the # of working days in the month). Finally, I sum all the bills of the month to know th

Is there a way for me to use images for each location for the map pins when using the map block?

I created a time tracker block to track time and wish to create a billable time calculated field that will calculate the duration and set to 30 minutes if the duration is less 30 minutes. something like: IF( duration is less than 30 minutes, set "Billable Time Value to 30 minutes, Otherwise set to Current Duration). I’m assuming I need to create a field called “Billable Time” as a calculated field, I just need help with the logic. Duration Field is set to type: Duration

I’ve been using Airtable integration for a few years and its always been seamless. But since April 2020 I can’t do it anymore. When I try to open a new Airtable base directly from G-Drive I get a message " Sorry, the page you were looking for was not found". Does anyone have an idea what’s happening?

Hey I have this gallery view of movies, and I want to go to the link of the trailer directly, without needing to enter in each item, but I have to clik on the field and later click on the link To sum up, I want to go to the trailer link without entering in each item, how can I do that in Airtable? Thanks

Hi there, I am new to Airtable and am trying to figure out why does the card layout behaves so differently when embedding it to an external website? This is how it looks at my grid-view once embedded into my site (this capture is from the sharable Airtable link, but it looks the same once actually embedded). As you can guess, there are plenty of fields missing in the middle. Strangely I can see the last field (an image) at the end: And this is how it originally looks the view in my Airtable base: Can someone help me to understand why or if I can fix it somehow? It’s not a hidden thing I guess, I already tried that.

Hello, Who has achieved some (or all) of these 3 goals, and has a solution already in place? I’m looking for a way to achieve these goals. Thank you so much in advance for sharing your wisdom. I’m looking through the Intergromat integration list of all the email tools, and I bet some of you are familiar with some of the tools that will meet my vision. And, perhaps even a direct AirTable integration not involving Intergromat – that would be magical. Lol, currently lost in the sea of reviewing all these tools and would LOVE your advice on what tools match for my vision. Thank you SO much in advance. It’s a bit time sensitive. Which of these pictured here do you like and also matches my goals/criteria outlined below? Or any others that integrate with Intergromat and/or AirTable directly, that you know of? ClickSend integrates as well. These are all tools that integrate with Intergromat.