Other Questions

Hello all - I am struggling a little with filter condition groups. Basically I want to show records that match the following :slightly_smiling_face: Type is “Travel” Venue is A and Stage is 1 or Type is “Travel” Venue is B and Stage is 2 In other words - only ever show entries that are Type = Travel, then only show entries that are either (Venue = A and Stage = 1 OR Venue - B and Stage = 2) I don’t want to show entries that are Venue = A and Stage = 2 - and I don’t want to show entries that are Venue = B and Stage = 1 This always does my brain in! Any help appreciated - have tried several times!

Here’s the scenario: I have two tables I use for managing volunteer shifts: Roster Vollie Check In A number of people forget to complete the Vollie Check In and I have to chase them up every day. If it was a paid job there’d be the incentive of getting paid only when you complete your check in, but as it’s voluntary I’m left herding cats every day. What I want to do is either: Create a view that filters Vollies who haven’t completed their check in that then triggers a daily automation email reminder, or Skip the view altogether and create an automation that compares the respective Vollie field in each table for Today() and triggers the aforementioned automation. I haven’t been able to find anything to compare records in respective tables in the community forum. Thanks!

I’m not sure this is something that Airtable can do - but let me describe the idea: A customer fills a shopping basket full of items - so one field is “order contains” and it lists all the items contained. The items are in a separate, linked table, and have associated values in that table. I’d like to add up the values of each item so we know the value of the customer’s order. Each customer has a coupon which tells us how much they can spend. In a Best of all Possible Worlds scenario - that calculated value of the order would be compared to another value to determine if the customer overspent their allotted “coupon”. Is this doable? How?

I have seen that many people are requesting advanced permissions but haven’t seen my use-case if somebody could please confirm whether this is possible. I would like to know if you can allow user view/edit rights based on cell value. I’m very new to Airtable so perhaps there’s a good way of doing this without me thinking like I’m working in Excel! I’ll use the most simple example I can think of below. Company XYZ has sales team made up of East and West, users are assigned to each team in a table. Person A - East Person B - West Then there are prospects in a new table assigned to a Team and person. When adding a new prospect, the prospect should default to the team that the sales person is attached to. Prospect A - East - Person A Prospect B - West - Person B What combination of the following can I do please? Make it so that all sales people can view all prospects but only the team who owns the prospect can edit

Hi :raised_hand_with_fingers_splayed: , I need to share some projects with a number increasing of clients. For example, this client give an oppotunity to another. And I need the client could come back and indicates if the oppotunity is finally ok or not. In the long terms, I will have a lot of clients. Could you please tell me which is the more economic way ? Thanks for your support.

I’m struggling to import into tables/sheets that have a lookup field setup. I tried: import from Google Sheets import via copy paste download as csv > import via copy paste The “Account” is always disabled during mapping and has a tooltip “this field type is not supported” I found this similar sounding issue: Bulk upload interactions? Unfortunately I doesn’t specify the answer.

I would like to know if you can transport configuration and other application changes from one (source development) workspace to another (test, production etc) throughout production iterations (versions) without the need to build from the ground up in each workspace copy. Cheers Shaun

@Joe_Hewes saw a thread about sending data fromWordpress. Does Forminator work with attachments? Thanks

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