Other Questions

Hi! I would like to use the WORKDAY function to count the number of working days from an input date, but I would also like to include the input date as well. For example, if I count 6 working days from 19-Aug, the WORKDAY formula would count until 27-Aug. However, I want 19-Aug to be included in those 6-days – so by right, 6-working days from 19-Aug, including 19-Aug itself, should be 26-Aug. How do I include that in a formula? Thanks in advance for any help! :grinning_face_with_smiling_eyes:

I’m building an attendance tracker that needs to track many many many individuals attendance to a moderate volume of events. This will be entered in by staff every day. I’m trying to find an easy way for those staff members to enter ~40 to 80 names, what they were at/not at and a reason they were present/not present. These names, events, and valid reasons are all pre existing and do not change. There will be a small staff of true collaborators that will be the ones actually looking at/organizing the data on other tables so if the input is messy that is fine, it just needs to be easy on the user side. I can’t think of a good way to do this, only various types of bad ways to do this. Any advice would be appreciated.

Hi! Currently to filter, the user must click at the top and do the usual process of picking an item from the dropdown. Instead of that, is there a way to make all filter fields visible? The end-user is wanting something similar to how you search on the lefthand side with Amazon. Thanks!

My ios app is completely unusable because every 5 seconds it pops up with an error message that just says “an error has occured” and closes what im doing. i use barcodes so i need to be able to scan them and i cant even get them scanned before this “error” occurs.

When using Sanity it’s really important all of our entires in our base have unique id’s not just on tables but in the base itself. Are the id’s for the entry unique to the table or the base?

Hello, I’ve created multiple automations to send emails when a record enters a view. I am testing this with my email to make sure that it works. When the record enters the view I can see that the automation has run and sent to the correct email, however, when I check my inbox there is nothing there. I’ve checked spam and all other mailboxes as well but there is no message. I’ve tried using different email addresses and keep having the same issue. This only happens to some of the automations, typically the second or third in a sequence of automated emails. What do I do??

Hi, I have a few tables on my base with records of inventory, each one with a price attached. I want to see how much I have in inventory total, so what I’ve been doing so far is using a summary block to easily see the totals from each table. Now I would like to combine the totals from several tables- does anyone have a suggestion on how to do that? I didn’t want to combine them all into one table because there’s very different data for each. Thanks very much! Alex

Hi. Is it possible to copy a row in a table to another table? I need to do this, effectively moving completed items to a file that accumulates the completed tasks. Any way to do that? Thanks!

Hi Airtables users, this is my first question in this forum because I’m using Airtable for the first time today ! :winking_face: I’m really impressed but I’ve an issue (the first one) I can’t fix myself. I’m trying to capture tags (all the tags) on a Webflow Page in the Showcase Section. Here is an example : https://webflow.com/website/clonecomp In this case, I would like to capture : cloneable / webflow / finsweet / nocode / meetups / community / competition / clonecomp I would like to be able to capture each tag. I can only select the first one (cloneable) for the moment using “.tag-holder .skill” with the “Text content by CSS selector”) and put it in my table if this is possible with the multi-select type. I don’t know if this is a good idea to use multi-select but I would like to give it a try in order to filter by tag after… Hope it makes sense to someone !

Hi Im using a paid version i would like to allow my clients to have access to a Personal area for the customer where they will be able to view their purchases, their payments and their balance. what should I use to build it? Best Sagi

Hi all, this is my first time posting a question here. I’m using AT to communicate with my project managers of a construction company when their jobs are delivering and installing. I have two issues they are complaining about. They’ve save the shared link to their phone home screen and when they open it always takes them to the beginning of June when I first shared the link with them. How can I get it to go to today’s date or to this week? One project manager has made a request about the colors. Currently I have the delivery date one color and the install date another color. He wants the delivery date to be the color of the supplier (of 4 choices) I’m using and the Install date to be the color of the crew doing the work (of about 6 options). Is this possible within a single calendar view or would I have to give him two different calendar links - one for delivery and one for install? Thanks in advance!

Hi i would like to allow my clients to have access to a Personal area for the customer where they will be able to view their purchases, their payments and their balance. what should I use to build it? Best Sagi

Is it currently possible to limit the selection options based on the single select conditional field? Example: Single select is ABC or DEF, which makes the next multi-select field visible based on the ABC condition being met. Can I limit the multi-select options based on the ABC selection?

I upgraded from a free account to plus, but accidentally upgraded the wrong workspace. ( upgraded “example bases” - duh). Is it possible to transfer the funds to upgrade the correct workspace? Thanks.

Hi I simply need to add some records to a table into a "Linked Record’ field. I struggle to understand why it’s so difficult. I have this VIEW: and I want to add single and concatenated ‘Linked Orders’ via a script. This my array of records I’d like to add… Here is my code and results… full code let table = base.getTable("Daily Orders"); let ws = base.getTable("Production Required"); let view = table.getView("Unfulfilled Daily Orders"); let sku = table.getField("Line Items: Sku");

Is it possible to reference another table in a primary field formula? I would love to be able to automatically add/remove records based on a checkbox value in a separate table. We are using Airtable to keep track of email accounts and distribution lists for our company. A distribution list can be associated with singular email accounts as well as other distribution lists. For this reason we have two tables - “Email” and “Dist Lists”. “Email” lists all accounts including distribution lists which are distinguished with a checkbox, and a separate table, “Dist Lists” links back to “Email”. The problem is any time I create a distribution list I have to add the record to both “Email” and “Dist Lists”. Any help would be greatly appreciated! Thank you!

Hi everyone, We installed the CSV import blocks inside our Airtable because we have a CSV file that we have to update daily to make sure the data is up-to-date. We use a column to merge with that always has a unique value (product_id). Like this we want to keep the data up to date for example when a price changes or when a new product is added. The strange thing is that we import a CSV and we receive a lot of duplicates which are not in the CSV file itself. Even stranger is when we right after import the same CSV file again it will continue to import duplicate rows inside our Airtable. Since we just updated it, in my opinion there shouldn’t be any rows to update the second time we import the CSV. Is there anyone that has experienced these kind of issues and does anyone know a solution how to solve this? It would help us out very much. Thank you in advance! Max

Hi, Is there a way to hide the ‘Show Data’ option in the top right of map block embed. It allows any logged out user to see all the underlying base data across all views and tables Thanks

Hello, How do I embed an entire airtable table into my website but allow people to edit it (it will be on a password protected site with viewers who only have permission to edit). When I tried to embed the airtable it was only viewable not editable on my website? Fyi I’m using Adobe Muse html widgets.

Can you add “Page Description” for the default values of web-clipper text fields ? The Meta tag option won’t work because websites use different syntaxes. Most scrapping tool try common known meta tag then default to the first paragraph (or first N lines) otherwise use the selected text

Hi, we have a calendar of several exhibitions that ends at different dates. I would like to create an automatic email that will be sent to us 15 days in advance before the target date so we can reach out our client and ask if he want to renew the experience or not before its too late. I have downloaded Integromat but i don’t know the right formula to write… Many thanks

Hello, I am new to Airtable. I’m trying to create a project where i have different tables with Start date, end date, people. I want to write a script that will loop through the all tables to check if there is any conflict of assigned date to any person. Can anyone put me through please. Below is my script i started. let table1 = base.getTable(“Project 1”); let table2 = base.getTable(“Project 2”); let table3 = base.getTable(“Project 3”); let Conflict = await input.fileAsync() if (Conflict) { record.getCellValue('table1.Start Date') == record.getCellValue('table2.Start Date'); output.text(`Yes`); } else { output.text('No'); }

Imagine a name string: Nina and Ian Fowler I want to end up with: Nina and Ian by finding and removing: Fowler. FIND() seems to function left to right, so while I can use: LEFT(Name,FIND(" ",Name)-1) To get: Nina How can I remove the last name: Fowler To get: Nina and Ian Any ideas welcome :slightly_smiling_face:

Hi, I am not a developer and am wondering if any of you can help me out with an easy-to-understand explanations. I need to collect credit card data from our customers and export it to our clients. Our clients use various payment service providers, so I want to use a vault system like ‘PCI Vault’ to store the credit card data. Is it possible to integrate Airtable to a vault system like that?

Hi, i would like to disable horizontal view as i only have ONE column. Tx.