Ask the Community
Recently active
Hello everyone,I created an automation that sends an email (gmail) at the click of a button. It uses some fields + attachment to create the email:Fields:Email addressSubjectBodyAttachment It works fine but it is very fragile: if one of those fields is empty, the email won’t work and the user won’t know.I set a warning message when clicking the button, it helps, but I’d like something stronger; like during the automation, if any of those fields is empty, to show a popup or error message to the user.I have looked around but cannot find anything like this. Any help?
Hello Airtable Community!I’m designing a system to collect structured KPI data (10 standardized metrics) from independent businesses. Phase 1 (Pilot): 16 businesses entering data via Airtable forms Phase 2: Expand to 60 businesses Phase 3 (Scale): 600+ businesses Goal: Aggregate all submissions into a single dataset for analysis and benchmarking.My core questions: Can Airtable handle this scale of data collection and access control? If so, what architecture would you recommend? One base where businesses submit via forms, with Interfaces restricting visibility to only their data? Or multiple bases that sync into a central analytics base? Thanks in advance for your insights!— Walker
So, we have calendars imbedded in our website and have color-coded different activities to make it easier for the parents to look for certain things. This is the grid view.And this is the embedded calendar. But the colors aren’t translating. Everything on the calendar is the same color unless you open the activity up.
I am from a company selling STEM supplies to schools. I have three tables:A “Material List” table with a list of materials we have in inventory An “Activity List” table with a list of our STEM activities. Each activity has a linked record field which is populated with linked records in the “Material List” table An “Activity Material” junction table with the quantities of each material for each activity listed. Desired Outcome of the Script:I’ve written a script that is intended to: Retrieve an activity record from the "Activity List" table using a passed record ID, whenever the list of linked Material records is changed. Get the linked materials for that activity. Compare the linked materials with existing records in the "Activity Materials" table. Delete outdated records of materials no longer linked to the activity. Create new records for materials that are newly linked to the activity, including setting the Activity and Material fields with appropriate record references
I have two emails showing up and the wrong one is one character off. I don’t know how to reach help to fix this so I can get access to all my bases
Hi everyone,I always found Airtable formulas a bit tricky, so I built a Chrome extension called Airtable AI Formula Builder. It lets you describe what you want in plain English (e.g. “combine first name and last name”), and it instantly generates the correct Airtable formula.👉 Extension link: Ai formula builder It’s a freemium tool: you can try it once for free to see how it works, and then unlock unlimited usage with a small upgrade.This is the very first version (MVP), and I’d love your feedback: What formula types do you use the most? What extra features would make this more useful for you?Thanks a lot, every bit of feedback helps me improve it 🙏
Hello!In the interface, I have a kanban section with some cards where 4 fields shows, aside from the name of the cards. Now my problem is that those fields also show their title.So at the moment it look like this:Garry’s PubTypeCADAddress157 Rue de VilléCityMontréalBut I want it to look like this:Garry’s PubCAD157 Rue de VilléMontréalAnd I cannot find the option to hide the field titles anywhere.Anybody with better luck than me here?
We have an intake form to generate URLs with UTMs parameters. I have created a new form with additional functionality. During testing, I need both the old and new forms to work.My current Formula field concatenates the URL (Root Link) with the UTM parameters and values. There is also a check to determine if the URL provided in the Root Link field contains a "?". If it does, then the concatenation output is handled differently:IF(FIND("?", {Root Link})=0,{Root Link}&{Source Parameter}&{Source Input}&{Medium Parameter}&{Medium Input}&{Campaign Parameter}&{Campaign Input (Child Campaign Name_Linked)}&{Content Parameter}&{Content Input},{Root Link}&"&utm_source="&{Source Input}&{Medium Parameter}&{Medium Input}&{Campaign Parameter}&{Campaign Input (Child Campaign Name_Linked)}&{Content Parameter}&{Content Input})My new form has the option to create some additional link types based on content. If you choose that option, the
Hi guys,The easiest explanation of my problem is this:I have an orders table and I have a “Tags” field in that table (multi select) - one of the tags is “Awaiting Payment” When a customer pays, a team member will remove this tag. When this happens, we want to automatically leave a note in our Notes table.We already create notes automatically in other automations so are confident with that part, but the trigger is more of an issue?I’m thinking that maybe I need a “Tags Previous State” field to copy to?Not really sure, I appreciate any insight anyone can offer.
In airtable form the column should be visible when 2 column values together should be 100%. 1st Question:For example, as shown in the screenshot below, in the Airtable Form, when a user updates Tag 1 and Tag 2 so that their total equals 100%, Tag 3 and Tag 4 should no longer be visible in the form. If the tags do not total 100%, all three remaining tags (Tag 2, Tag 3, and Tag 4) should remain visible. 2nd Question:Is there an option or way in Airtable forms to prevent users from submitting the form if the total Tag does not equal 100%?
Hello, I have a basic form for people to request new feature. When i open the form and submit all goods. When some of the users open the form they have the message: “Error Refresh Server”. Any idea what’s the issue ? Thank you :)
Since the latest update, when looking at our Interface the data is getting jumbled. eg. we allocate workers to projects and they are correct on our Base, however when we look on the Interface on a mobile phone the columns seem to mix up and Workers are appearing against the incorrect projects. Has anyone else experienced this or have a fix for this?
@ScottWorld , I went through a few options to look at ways to just highlight the duplicate entries as they get entered into a database. I noted u came up with a simple one but there were no steps written down. We have a unique patient ID which is in the primary column , we dont want to duplicate a patient file. Every time we enter we wish to have a look and see if there is a duplicate entry and delete if its highlighted. makes sense?
Hi Awesome Airtable folks, I am a fairly competent basic Airtable user - basic integrations and data moving between bases, however not a full coder (so need an easy solution that is easily passed on to others please). I would love your advice on the best approach for this: -We have an event, and we have 2 different H&S forms that we require our various stakeholders to complete. Each area (trade, volunteers etc) has its own base in AirtbaleForm 1 - DeclarationA simple airtable form, no images. Built in Airtable, communicates directly back to base. Worked well last time.Completed by - trade onlyForm 2 - InductionNeeds to contain imagery. This is where we came unstuck last year as Airtable Business doesn’t have imagery in the forms, so we built with an integration in Jotform. This created data and sent it back to the airtable base, but we struggled to integrate it with existing data so had to manually audit it. We also have people attending who will complete this form that we do not h
Just wanted to pitch this, and see if you are seeing this as much of a need as I see it. I am a heavy Notion user, which I quite a lot but I overall preffer Airtable except for one thing. NOTION Formulas as far superior. To give an example, you can use dot notation in Notion formulas sum((Pagos.filter(and(current.Tipo=="Cuota",formatDate(current.Date,"MMMM")==(formatDate(today(),"MMMM")))).map(current.Monto)).first())!-->Here I am getting fro my list of members, all the categories they belong to, and from there all the events there are, and from there all the dates. All within one single formula. This would be so great in Airtable.If I have a level hierarchy Company, Office and ContactThere is no way to bring the contact email to the Company record unless i create a roll up of a rollup so I am creating 1 extra field in Office, whereas in Notion I could simple go for:Office.map(current,Contact.Email) I can even apply filters making it much easier to set up.Am I the only one with thi
I can’t believe I couldn’t find an entry about this in this forum yet. Hmm ok, here’s my problem: Every time I open Interfaces it goes straight into the editor and I have to click launch to use it. For me (main administrator and builder) it is annoying but works. Now my user back from holiday wanted to access and couldn’t. It gives a message that says to click on launch or ask the owner. No launch button though. I opened the interface on my side, had to click launch again did so and she could get in. This obviously is quite an annoying and NOT acceptable behavior. I have no idea where and how to change this behavior?Please help
Hello all!I’m building an inventory database with an associated request form. I have two separate tables - one for full inventory and one for the request. In the request table, I’ve allowed people to link records from the Inventory to a requestor record. What I want to happen is that when an item is added to that requestor record, I want the associated item in the Inventory table to update its status to “Checked Out”. Can anyone help me logic this one out? Thank you!
Trying to find a solution to always show every month in a range. Pivot tables don’t provide any customization for this, so I am trying to reimagine data in a dashboard/interface bar chart. There is an option to show empty records, but as you can see its still skipping months. This is a single select field, with every month as an option. I want to see months that are missing any selections. I’ve also tried it with a date field updated to bucket by month, but still same issue. What am I missing?
We are a small manufacturing company, and have moved most of our inventory into Airtable for our current build and possibly will continue to use for future buildsIs there a script I can use to stop duplicates from happening within a table? Is there a way to move about parts from one ”location” (which is already a table in the base) to another without physically having to continuously go into the data base? continue question from above - is there a way to have 1 part but with multiple locations? We have parts that are stored in multiple staes (eg: flat parts and then folded parts but both are the same part) what is the best way to show this other than having multiple part numbers or prefixes for the same part.Hope that all makes sense…..
Hi All. What’s the best way to set up the automation below—either in Airtable’s native automations or in Make—to reliably populate the linked field with the Trade’s subcontractors (particularly struggling to get the list of record IDs), and avoid reseeding after manual edits?Base: Dupl Construction Project https://airtable.com/invite/l?inviteId=invh3YFKHVkgkcl8h&inviteToken=ebe29e4b636f906f9bde46e9282074acf77e1634caac54dee00c188723eac427&utm_medium=email&utm_source=product_team&utm_content=transactional-alertsThe goal: when a record is added/updated in the Subcontractor Review table and Related TRADE is set, auto-populate Selected SUBCONTRACTORS (link to Subcontractors, multiple) with all Subcontractors linked to that Trade. It should seed once (only when empty) and remain editable and continue to be linked to the Subcontractor table records to create quote requests from the selected Subcontractors (which may be different to the initial allocation) later.What I’ve tri
Hello I am working to find a way to connect stripe to Airtable. The use case for this is to show when a customer’s account is paid, past due, or cancelled. We have a people base in airtable that is each individual user in our system. Name, company name, emails, etc In stripe we have subscriptions that are paid and automated there. All payments are through this system. Some stripe subscriptions are an ap or accounting email but pay for 10 users in our people base. I have tried zapier but it does not have the ability to connect the two in the way that is needed. I am thinking I need to connect the unique stripe customer Id to the user in airtable. Not sure if this is best done through the stripe meta data. Then I would need a script to connect this meta data to the users in the airtable base.
Hi, I’m trying to share a table using an iframe, I do not have problems when I see it from desktop, but from mobile it does not look good. When I enter the iframe URL in mobile it works fine, but when I enter my URL that has an iframe inside, it looks different. Does anyone know what could be happening? The code that I am using is the following: <iframe class = "airtable-embed" src = "https://airtable.com/embed/xxxxxxxx?backgroundColor=blue&viewControls=on" frameborder = "0" onmousewheel = "" width = "100%" style = "height: 90vh "> </ iframe> Thank you in advance!
I’m trying to get text and currency to combine and show properly with 2 decimal places even if they are 0.00.I have a product field (with text), a value field (with Currency)If i did a simple Formula {Product} & “ - $” & {Value} the result makes $18.30 from {Value} turn into $18.3 and $20.00 turn into $20, removing any 0’s after the decimal.Through research and help we can do the following equation:CONCATENATE({Product}, " - $", IF({Value}, ROUND({Value}, 2) & IF(FIND(".", ROUND({Value}, 2) & " ") = LEN(ROUND({Value}, 2) & "") - 1, "0", ""), "-.--")," "&{/Unit})This will put in 2 decimal places unless they are .00, then it reverts to suppressing the two 0’s after the decimal place, how do i get them back?
Is there is way in airtable filling the form by quarter and once it is submitted it should create multiple record as per the quarter.
Currently in airtable we have each project as a line item, and we have multiple columns that note milestone dates:Brief Start DateKick-off DateIn Market DateOut of Market DateIs there a way to create a gantt view (either in the base or in an interface) where each project bar is segments to show the different working phases of the project using the milestone dates above to create the segments?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
