Other Questions

Hello! I have a question how to set up my inventory. I produce and sell chocolates, so I have Inventory of the single ingredients, Inventory of the produced chocolates and Inventory of packed chocolates. When I produce 1 mould of chocolates (40 pieces) I would need that the amount of different ingredients that is used to produce 1 mould is reduced from the inventory of single ingredients, and added to the inventory of produced chocolates. Lets say I have 1kg of sugar and 500g of cocoa beans (inventory of ingredients) & now I produce 1 mould (40 chocolates) and I need 50g of sugar and 10g of cocoa beans. in the “production table” I would select the kind of choclate I produce and the amount (1 mould) - is there any way that then the inventory of the ingredients is reduced by the exact amounts that I needed? Hope I could explain it properly! :slightly_smiling_face: Thank you very much for your help!

Hey, I’ve been having a lot of trouble trying to get hold of someone from Airtable regarding the Enterprise plan. I’ve messaged in live chat, got a colleague to message and even gone on Twitter! Now when someone got back to me they were from support and not sales. All I’m after is a minimum price for Enterprise, we need to ensure all our users are managed in one portal and we have one bill and are seucre.

Does anyone have suggestions to go one route over another for setting up my base? Essentially in a table called SKUs I will be linking to another table or tables for each SKU component. Each of the fields in the screenshot below will be a linked record. My question is, should I link these fields each to the same table (like the image below) or create a separate table for each component/field type (ex. A table for supplier, pattern, colour, etc.)? There will be additional information specific to each field/Sku component included as well. Like price per square inch for a specific pattern or prices for inserts, etc. Thanks in advance!

I’ve been looking and looking but I can’t seem to find a viable way to return to the workspace from a base. I always have to return to airtable.com on the address bar. That can’t be right.

Hi, I use airtable like a CRM. And I don’t want to miss some opportunities. So I would to know if it is possible to create an alert ? For example if a certain date is reached or exceeded.

Hi I would create a public calculator on my website with airtable ? Please, anyone could tell me if is possible or not ?

Hi, I’m hoping someone can help. My company manages projects and when a project has a formal issue, we create a Governance Ticket related to it in another Base (to ensure the underlying information is not visible to other users). This results in a series of Syncs between Bases. Projects sync to the Governance Base from a Projects Management Base Governance Tickets sync back to the Projects Management Base (showing a limited View of the issue’s details. What I can’t get to work is the update using automations of the RAG status field which lives on Projects tab on the Projects Management Base. The scenario is that a ticket is raised which moves a project to Red status, which is a field in the Governance Base. The sync occurs and shows that a ticket relating to a Project is in Red status and if the current Project is not in Red, the automation should change the linked Project record to Red status. However, I can’t get this to work. It’s al

Hello - I’m trying to set up an automation that runs whenever my editor inputs a note into a field. When I had the automation set to trigger when field is updated, I would get 7+ notifications as she typed her message. I adapted the trigger to be ‘when a record enters a view’ and the view only shows records with notes in the notes field, and a formula I added: IF({MINS SINCE UPDATE} > 5, “Automate”, “Wait”) To only show records that say ‘Automate’ to give her 5 min to type her message. However, this now sends a notification any time any record with notes is modified in any way. My question is: Is there a way to have the minutes since update formula only watch my notes field?

I have a spreadsheet that lists email addresses along with two pieces of data each in one column. Some email addresses have one row, some have 3, some have up to 60. What I’d like to do is sent one email to each email address and include the other two rows of data whether it be 1 or 60 in the email. Anybody have any good suggestions for accomplishing this?

a colleague has invited me to their pre-modified template, I want to open, copy and keep as my own for my own uses. When I click the link I get a “the page you are looking for was not found” message. can you help?

Hello, I am new to AirTable, trying to figure out how to implement my required features. I need to let users specify a payment schedule. So that the user can add dates, and values for each date. Ideally I would like to figure out how to add a column which is a “List of Date+Number pairs”. If that is not possible (and it doesn’t seem possible?) what would be the best way to simulate this feature? I have not yet looked at creating Interfaces in case there is a way to create a one-to-many with a “Payment Schedule” table and have multiple records in multiple tables be populated by an Interface. (So if this is what I need to do, please let me know) Thank you for your help figuring this out.

Hi all I’ve had Airtable for only a few days and I’m desperately trying to replicate what I’ve got in Excel, however I’m a bit stuck and hoping for some help please. It’s essentially a points lookup. Requirements Users must answer 4 yes/no questions (represented by 4 columns/fields) Each answer of Yes will add the number of points shown in table below, with the total points across the 4 fields attributed to a priority Users should only see the below 5 columns - any other fields created and used to calculate/lookup to determine the priority should not be visible to the user The priority should not be able to be edited by the user - this defeats the whole purpose In the above example, user has answered Yes to B so 10 points has been assigned in total and this results in a medium priority be

I can’t find the place where you make feature requests so am posting here. One of my forty favorite features in Airtable (lots of favorites) is the ability to copy some or all aspects of view A’s configuration to new view B: for example, to copy field visibility, column order, but NOT copy filter. This is great. My request is: It’s great to be able to copy config, but I’d really like to be able to LINK the config. I’m finding that it’s extremely useful for most of my views to display the same fields in the same order. I’d like to be able to define a single model view, and then basically lock all the other views to a few aspects of that model view. That way, I can keep tweaking the model view and the other views will just stay “synced” without my having constantly to re-copy the config. If this wish can’t be granted, could be nice if there was an easier more efficient way to copy config of the model view to several other views. Pleez? :slightly_smiling_fa

Hi, I’m wanting to know if its possible to have a single extension access multiple bases concurrently? My situation involves analyzing more than 50k records at a time and generating a graph based on those records. I will have 15+ bases and each are identical in structure. Each base has 50k records (pro plan). General structure of those bases is listed below (or you can see the base directly). The bases I am sharing just show a few rows (not 50k) to make this problem easier to review. I know a synced table is what would generally allow you to sync multiple bases into 1. I’ve confirmed if I do that I can achieve the desired graphs/extensions in a single base (provided the record limit is not exceeded). But even with a pro plan I am limited to 50k records for the base, even if those records are synced. So this is not feasible. Is there an alternative way that would work better? Right now I am considering using a local database to host and store my raw data.

Hi everyone and thanks in advance for your answers. I would like to create a form that allows the user to add info through an additional pop up form, or something similar. I need to capture my users work experience and education and would like a secondary form to pop up with fields like “graduation year”, “institution” and “qualification obtained”, etc. I would also like them to be able to add as many as they like/need rather than limiting them to a particular number. Below is an example of what I would like to do: After clicking the “Add Work Experience” link, the following would expand: I’m not sure if this is even possible in Airtable, but any help or advice would be greatly appreciated. Thanks again! Natalie

Hello everyone, I have synced two bases with a third one (country stock management purpose). The issue I have right now is that even though my product have the same SKU (primary field here), the stock levels aren’t on the same “line”. I don’t know if I am clear enough. Airtable has automatically created a new “line” so I end up with two “lines” for the same product reference. How can I change that in order to only have one? Thanks a lot for your help, Have a nice day,

Situation The owner of the database has left the company and no longer has access to his account. We need to upgrade our plan to expand the number of entries. But we can’t do it because we don’t own the property. **Does Airtable have the ability to transfer ownership ? ** How can we do this? Thank you in advance, Sincerely

Hi All, I am fairly new to Airtable & Integromat/Make and am having a problem I cannot resolve. I have survey data that I am trying to import in Airtable. The problem is that when applicants select more than one option in a question, Airtable will either say “Cannot parse value” or will combine the select options and make a new select option: As you can see in the above screenshot, it is combining values under the “Program Selection” column. I want it to separate the values “Humanities at Hertog” and “Summer Course.” But instead, it is either putting a comma between the values or just putting them together with no space. I want it to mimic the example of the separated values “Summer Courses” and “Advanced Institute” in the same column. The weird thing is that in the “Alumni Program Type” column, I managed to separate the values of multiple selected opt

There is a table optimiser script. I want a script which does exactly the opposite. I have created the records using junction script. It is convenient to create and update. Can I not do the opposite. This is the help for Table optimiser below - I want to do the exact opposite Use this script to turn a “wide” table - one with individual records each with multiple different associated fields - into a “narrow” one - with a record for each associated field and field value. For example, if your original table looked like: | Product | Jan Sales | Feb Sales | Mar Sales | ------------------------------------------------------------- | A | 32 | 168 | 180 | | B | 24 | 150 | 175 | | C | 64 | 144 | 165 | You could use this script to automatically create a new “narrow” table, th

Hi, I’m trying to send an AMP email from airtable to collect NPS form data and store that data in airtable. This form is embedded in the mail body itself so that the users don’t have to go to another page to fill in the same. Usually, I use cURL in the scripting node to send email campaigns from airtable and the Gmail node for single emails. Since this is a form it needs HTML email, which can’t be done with a scripting node. How can I use airtable to send and receive such form data, is there a solution or workaround? Please let me know if further explanation is needed.

I’m creating an invite-only job application form. When sending it to applicants, is there a way to prevent someone from sharing the form, i.e, restricted access so that only people with the provided email can open the link?

I have a Master Table “Source Table” with all our project tasks. What I want to do is set up is a way that when a task is assigned to a team member that the record for that task ALSO shows up in that team member’s table “Receiving Table” without breaking the link between the two tables so that any updates would be bi-directionally synced (e.g., the team member uses their own table and changes the task’s status from “To do” to “Completed” and that same status change shows up in the Master Table on that same record too). So far, I’ve only been able to ascertain that Airbase can do a one-directional syncing from the “source” to the “receiving” table but not back from the “receiving” to the “source” table. Why not? I’ve also figured out how to set up an automation to copy a record from the “source” table to a “receiving” triggered by a change in the person assigned, but in that case, it creates a copy that no longer syncs at all with the source once it creates the copied record. Help!

I am looking for a solution to implement fractional fields in my table. These would hopefully be also calculable. I haven’t found any questions in this regard but please send me that way if you are aware of the similar topic.

Hi all, I’m puzzled as to why the solution to the following topic, which relates directly to a project I’m tackling, is no longer viewable. Select records email with a form please ?!

All of the sudden this appears on my forms… How do I turn this off? (have Pro Account and AT branding turned OFF)