Base Design

I have a client who is having folks apply to submit products for an online store. The applications are entered automatically from a Jotform integration into the “Sellers” table. The Sellers then begin submitting products through another Jotform. I do not want them having access to the other sellers data, or picking something incorrectly, so I have them enter their email address again and that is entered into the “Products” table. Is there any way to automate linking the Product to the Seller using their email address? When I try to use a lookup field its only showing me a separate “linked” fields as an option, and I can’t look up the email field. Thank you in advance. Open to reworking this as well of course if someone has more elegant ideas.

I am so sorry if this is the most insane question…I am still VERY new and trying to get my bases/tables designed to work for my business as a bridal designer. I need inventory, then projects that pull from inventory as well as customers that may pull from both. Also hoping for social media tracking, etc. I am still trying to work it all out in my head…but what is the purpose of the “form” I do not plan on, at the moment at least, having anyone else use my database. I have looked at the info on it here and still a bit ??? Would it be used as a faster way to input say client info or should I just forget it is there being the sole person using this? So sorry for the long question. Madicyn

Hey guys, So the application I’m trying to build needs to render HTML code. In specific, I have email content that is being sent into the base and I need the Email’s HTML to be rendered in order to view the mail in its true essence. I have tried using a rich text field but it does not render the code. I’m looking to build a mobile app for newsletters that I’ve registered to with Airtable as my dB. Any way to accomplish this?

Is it possible to use a wild card search when you make a selection from a linked record list? e.g. search on a field which is shown but not the primary field in that list?

Hi, I would like to have only unique values (email) in my Primary Field. So If users will try to add an already (in the table) existing email, they should not be able to save the record (line). Is it possible?

I have one table of bugs for Software A. Software B, with its own table of bugs, depends on software A to some small extent. Sometimes bug blockers for Software B are in the Software B table, but sometimes they’re in Software A. I need a field which can accept either. Is this possible? It seems a field can only link to records in one table, not many. But this can’t be true, can it? It’s a pretty basic function. I am aware that the preferred way to deal with this is to contain all these entries within one table and use views to differentiate, but it really doesn’t make sense in this case. In fact, these softwares are so different that I had them in separate bases, until I realised that there was no way to access the data (prior to sync) from one base in another. These records also have very different fields, so if I were to represent them in one table, I’d have extraneous fields for all the records.

Hello there! This is my first post ever here, so I’m excited to start contributing and hopefully get some advice! I’ve been browsing the community for similar topics but couldn’t find anything similar so far. Here’s a bit of context to begin with :slightly_smiling_face: I buy pantry items from an online store once a month. For me it can be a pain in the neck to find items I’ve already bought and liked, save items I’ll want to try and shop later, all the while making sure they’re the right price and format, and that I’m ordering them in the right quantities based on the stock I currently have at home. So I created a base to keep track of my current stock, what I bought in the past and how I liked it, the goal being to ease the decision process and spend less time browsing the store’s website and comparing items. Now in my base, I have quite a lot of tables, but the following 3 are those most relevant to my question: Products on the market: actual p

"how do I sum the values of a linked record that came from a Form submission from another table in the same Base - (in this case, its a Count from 2 separate Plant-out recordings, but I want these 2 records to add up so that the total value, 13, can be subtracted from the Nursery inventory) and is it necessary to create a Nursery (main inventory database) AND a Nursery Outflow table? I basically want recording of Planting-Outs from Nursery to Field to be super simple for my team - they should just fill out a simple form of what, when, and where they planted, and then have their response flow back to the Nursery database. Similarly, when seedlings Enter the Nursery, they can fill in a inflow form that updates the Nursery database. Any suggestions on keeping it simple when each batch of seedlings (say 50 Limes will be planted out in 5 batches, and therefore 5 recordings)?

Dear “Airtable” community, how should I interpret the maximum 1200 registrations for free accounts? If I have a database with 3 tables and none of them exceed 1200 records, is it okay? o The sum of the records in each table must not exceed 1200 records? From already thank you very much!!!

I’m creating a base for managing contacts and people and am torn between creating a table for companies and another table for People or whether to put Companies and People on the same table. Here are what I see as the advantages of putting Companies and People on the same table. The Companies and People share many of the same fields (name, address, phone, email) and so there are efficiencies to having both on the same table. You can also do links to the same table so you can show a linked “Works for” field if you want to track what people are associated with the Companies in the table. Lastly, if you have another table that needs to reference contact info from either People or Company, referencing a single table seems much cleaner than have a separate reference field for each table and then another that tries to parse each field column to figure out which value to take. When I look at other CRMs, I often see People and Companies as

Hi there, excuse my ignorance! I am very new to Airtable and I am trying to set up a simple inventory system of moving hundreds of items (Props for a film) from one location to another. I have fields set up for the various locations as a checkbox. ie. “PROPS STORE 1”, “PROPS STORE 2” etc… If I move a prop from “PROPS STORE 1” to “PROPS STORE 2” - is it possible for the “PROPS STORE 1” box to automatically UN-check? Basically, I am trying to make it so that only ONE of the check boxes can be checked at any one time. So it is not possible to have an item in two places if a crew member forgets to uncheck a location box. By default the system will only allow you to choose one check box. Many thanks for any advice!

I have a table with about 1000 rows of contact leads from 35 websites, and want to somehow show which websites had no (or the least number of) leads in the last month. I’ve tried Rollup fields and Lookup fields in another table, different views and blocks and read community posts 2 days straight, but i’m not getting anywhere. I’m kind of fumbling in the dark. Hoping the community can lend a hand. The resulting view should give an overview of which websites I need to focus on to boost leads. How do i go about this? I’m happy to put in the reading time and work if you can post a link with an explanation or such. /Vibus

Hi, I am trying to have a row added every week automatically, and then when the field End of testing hits today - 1 day it would send an email notification.

I have a base with columns (fields) in a given order horizontally across the page. I want to move some of these columns so that the are in a different order across the page. How do I do that?

Small bug in the user interface: Can’t sort the list of workspaces in the left column (the list is under “Find Base and Workpace” field on the left). I try to drag up and down workspaces (dragging the name) but it refuses to stay where I drag it. The list is not alphabetical but I want to sort it in my own order. The 6 dots ::: show and allows dragging but the order goes back to previous order or the order becomes completely mixed up. The issue is same online (Chrome) as it is in the app (MacOS)

Can’t copy the setup of the SUMMARY bar (or whatever it’s called) across views. I have a few views in my base. On the bottom there are totals (or sum, max, is-empty etc counters). I want to copy the confirmation between views. Is there a check box I mised? I don’t want recreate views and they are all different. But the bottom totals are configured in the same way across the views.

I’m planning on creating a newsletter with different categories and I’m looking for advice on how to allow users to: customize newsletter by selecting what categories they would like to receive first customize newsletter by selecting the order of categories they would like to receive them I have 14 categories and I want to connect this database with Mailchimp to automatically send the content to subscribers weekly. Is this something I can do with Airtable and Mailchimp?

Hi All, I am trying to build out an automated(ish) roadmap and resource planning base that will schedule features based on sprint start/end dates and resource availability. I used this base as a starting point: Resource Planning - Airtable Universe Linkk to a testing base with my setup: Airtable - Testing This google sheet is the auto-scheduling functionality that I am trying to mimic. The sheet takes in to account available headcount and automatically schedules dates based on availability. I’d like to accomplish something similar in airtable , but using the sprint table start and end date data to drive roadmap dates and assign features to the team based on availability.

guys, why did the empty post appear?

How to clone a base along with its blocks and everything ?

Hello all, I’ve been fiddling with the Inventory Tracking template to see if Airtable will serve our needs and could use a little guidance. We distribute food to a number of food pantries and keep a monthly inventory for all of them, tracking what is transferred into and what is transferred out/distributed from each inventory, along with the current inventory levels. Hopefully that makes a glimmer of sense. Is there a way to accomplish this without setting up a separate base for each pantry and entering in purchase/sales orders into each one? Many thanks!

I have a question for a base design to track locks and keys. I have a table for locks, a table for keys and a junction table for locks_keys. In the junction table, the locks column can have many locks that can be opened by a single key. I have a composite primary field concatenated with the lock and key values as the primary key. Issue is that the primary key is really long on some records where 1 key can open 5 locks. Would creating a surrogate locks_keys_autonumber primary field work in place of using the natural keys?

I am trying to create a formula for renovation of flipping houses. My scenario is this: I have a purchase price. I also have 8% commissions coming out of total sale. I want to be able to input value x (possible total sale price) - 8% then - again the purchase price which would give me a field with a possible renovation budget. So it would look something like {(enter any number value x) - 8%)} - purchase price = new value

I have encountered an contradictory issue wherein two schemas which are topologically identical are treated differently; one works fine and the other throws a circular reference error. I have distilled the issue into a very simple example base. Here’s a link: Airtable

Hi - Has anyone created a base to track applicant diversity or created a base for OFCCP auditing? If not, any suggestions for modifying an existing base? I’m looking to track the applicant diversity mix for various jobs, the diversity mix of those we hire, then layer that against our overall employee diversity percentages. This would be a year-by-year comparison, so I’m thinking will need to involve several tables. thanks!