Base Design

I have several survey forms, and they shares some duplicate questions. Moreover, one participant can fill the form multiple times. Is there a way to achieve as many of these bullets as possible? There is a way to aggregate answers of different forms of one participant into a place Each participant doesn’t have to answer the same questions in different forms (if a participant has already answer those questions in form A, then they won’t be shown in form B, or already has the answer) Whenever a participant redoes a same form, then I can track the changes in their answers

Hi, I’m trying to be smart about setting up a base design, but might be overcomplicating it: I have 9 product teams, who at the end of each sprint will send out a form to their respective partners, asking them to review the working relationship and progress (so two parameters). I have set up a base for a single team with a form collecting the reviews in one table and an other table calculating the average per parameter, per sprint. Ideally, I’d like to have all of the teams in one base, since I can’t sync more than 7 on the pro plan. Is there a good setup for this? The product teams need to have separate forms, as they have different partners and different sprint dates. Could I potentially have all teams in the same base, and let them send out their survey from their respective table? I’m afraid it’ll be a mess since I want the product teams to feel ownership of the reviews, but perhaps I could create different table permissions? Thanks in advance!

I am trying to create a base to track contributions. I am tracking the contributors, different funds, and the contributions themselves. Each is in its own table and I am cross-linking the Funds table and the Contributors table in the Contributions table. I also have a roll-up for total contributions for each contributor and I have a roll-up for the total amount received per fund. I then created a form to input. This works pretty well. The problem I am running into is if someone contributes to multiple funds then you have to submit a single form per fund. I would like to be able to enter the amount given to each fund in one record. That could be done by just making a field for each fund type in the contributions table, but that prevents me from being able to get a roll-up of the total contributions to a specific fund in the Funds table at least as far as I can figure out. Is there a way to give the end-user inputting the data the ability to input all the funds being contributed

Hi all, i run a maintenance company and we are looking for a solution that allows us to assign a large amount of tooling out to each team/individual. There was a previous topic titled “help tracking check in/out equipment for our small video studio using barcodes” this was helpful but i need to be able to do a bulk scan rather then input each item separately. for example, team one come to the tool container and grabs 20 items of tooling each has its own barcode assigned to it. ideally we open up a table named team 1, quickly scan all 20 items and they appear in that table. upon return they are scanned again and removed from that table. this is just my initial thoughts, maybe someone has a better idea on how to set it up, it just needs to be efficient as a lot of equipment will be signed in and out daily thanks heaps !

Hello all, I have created a base with 2 tables. Table 1 is the Sign In Table. It is fed from a form as I cannot allow students access to the table. Also, due to HIPAA, I cannot allow a list of their names to appear in the sign in form. This means they have to type in their names manually every time they sign in. This leads to typos, errors, irregular spelling, etc. All in all, it is sloppy. The form is updated every day with fresh typing and fresh errors as we cannot have folks viewing other names. I also have a sign out form that feeds to Table 2. The same issue happens about typing & new dates equals new input & new errors. I am relying on the hope that they can get their birthday typed in correctly so I have something I can work with which will appear in both tables. Here’s what I need: A way to see who has signed in but not yet signed out. Due to variations in poor typing, I cannot trust anything they type into the form so am hop

Hey folks! Having a rollup issue. Using rollups to aggregate outstanding debts. The rollup is conditional based on a multi-select for “debt” the first two records sum up fine, however the most recent addition is not being aggregated in despite satisfying the conditional. What am I missing here? Thanks for your help!

Hello AT Community, I am a bit stuck on understanding if this is something I am doing wrong or a system limitation. Here is the scenario: We have a CRM in AT that classifies a parent company as an Account and a member of that parent company as a Contact. Basic logic, and we have a linked relationship between both. When our marketing people go out and meet someone, purchase something for a client (lunch, etc.) we want them to update AT with what they did. This works fine when the Account and or Contact is already in AT. When it is not, we want to be able to add the new Contact and or Account on the fly off of the form and limit them going inside AT if possible. This scenario can exist when we have a new Contact that we have not had in our base, nor their parent company (Account). When we are adding the new Contact it is coming in from the form as a new field - which is what we want. The problem comes in when the person using the form realizes that there is

why does the URL have a space to be completed? I only want the link and the description. See attached screenshot.

I am creating a base for tracking students through coursework in a program. I have a one-to-many relationship between students and the courses that they have taken. All the available courses are in a separate table. For each student in the program, I have a field called “Courses Completed” and there I pull in, from the available courses table, all that the student has taken. My question is, if I want to add the grade the student received or each course taken, how can I do that using the one-to-many structure I have set up.

Hello, I’m not a formula expert and I need your help. I created a table with a Suppliers, Products, Inventories/Stock, Sends/Packaging table. In my product table: This is the finished product (ex: a table) but which is composed of (a shelf and a foot) these are the components of my finished product. The product table will be directly linked to my billing. In my Inventory/Stock table: These are the components (ex: legs, shelves, etc). This table is linked to my supplier table. I would like to set up stock management, supply, classic in the inventory/stock table as well as an alert system when my stock is empty, etc. The question is: I have created a total quantity column in my inventory/stock table (supplier order) and a quantity column in my product table (customer order). I would like to be able that when I apply a quantity in relation to an order (finished product: ex: a table) in my product table that it be deducted from my stock (compound produc

I’m working on building a central product roadmap for my team. I know how to link records from one table to another, but I am struggling to link records from multiple tables to one single table. If I try to do it for the second table, it would just add another set of fields to the main table. Could anyone point me in the right direction? Thanks.

Does anyone know how someone would delete a record? I don’t want our team to be able to choose certain record options and want to delete them. They’re meant to link so that if someone looks up “City, State” only one shows up, but right now there are about ten for some options. I want to delete the other 9 options.

Hi all, I have been playing with Airtable for a while now but not high level enough to figure out scripting yet. I’m a farmer and I’m looking to make an Airtable solution for my spray applications. I’ve got a few tables that hold the general info: ‘Blocks’, ‘Chemicals’, ‘Applicator’ I’ve got another table that is my ‘chemical manifest’. This one grabs the particulars from ‘Chemical’ and I add the particulars such as purchase date, amount etc… The ‘JOB’ table is the workhorse. It allows me to record the ‘Blocks’ being treated with the ‘Chemical Manifest’ with which ‘Applicator’. My limitations are: Sometimes I add one chemical to a job, sometimes I add ten. I don’t want to add 10 sets of fields related to each ‘Chemical Manifest’ My application rate’s are sometimes different than the general label rate on the chemical,

I suspect the answer to this question is no, but I’ll ask anyway. Is there a way to auto-sort tables within a base according to usage? So, for example, I click a button or enter a keyboard shortcut that sorts my tables from left to right based on activity within the tables. They would be sorted based on activity since the last time I ran the sort feature. So those tables with the most activity (new records and updates to records) would be sorted to the left while those with little or no activity would be sorted to the right. For those with the same level of activity that would sort alphabetically. Thanks!

Is there an easier way to move a table from the end of a base (right side) to the front of the base (left side) without having to click & drag? Thank you!

Hi, I am looking to take multiple tables (one from a survey, one from back of house inputs) into a third table which includes approved survey responses and in house data to then visualize. I am having trouble adding data from multiple columns into the same one as well as conditioning the data to only sync from the survey if marked “approved.” I’m new to Airtable and a bit lost. Thank you for the help in advance.

Hi everyone, I have created a scenario that connects EVERNOTE to AIRTABLE. When I import notes into airtable however the text results without formatting and I lose a lot of spaces. Consequently I can’t extract the mails contained in the text. How can I maintain the formatting in Evernote in the airtable DB? Thank you all for your answers.

Hi, I need to create a form for our sprint reviews, in which our partners can anonymously rate their confidence and commitment to the development. I have created the form with no problem, but I would like to track the average rating per question and per sprint, so I can follow the progress over time. How do I calculate an average grouped by the specific sprint?

Hi, Is there an good workflow to keep track of items in one table for different types of items / options. For example i have small woodworking shop and would like to keep track of - -screw and bolts many sizes and length -plywood etc. and it comes with different thickness / size / etc. So in the end there would be option fields that doesn’t make sense for bolt category and vice versa. Should i keep each big category in different table? Thanks!

hello everyone, I would like to change the primary field in the formula but it is grayed out and not editable, sorry but i can’t find the solution anywhere

Hi all, So I’m new to Airtable and things seem very different to what I am used to in respect of MS SQL Server as a former software developer and DBA where I would write endless complex stored procs and triggers etc. Now a restaurant owner, I decided to write a basic recipe and pricing calculator to help me with the ever changing prices of stock since covid-19 but am already stuck so I’ll simplify an example of what I’m trying to do with a with a minimum amount of tables and fields for now as per below diagram of 3 tables: So the first table ‘external_ingredients’ contains products bought from suppliers with the cost and the weight of the item in grams in this case. The ‘internal_ingredients’ table contains the recipe of external ingredients used to make the internal ingredient, and the percentage of the cost per ingredient based on the weight of what we nee

I don’t know if some of you already faced this, but 2 days ago I was not able to modifies my select fields and multi selects fields due to the zoom increase of page navigator. For those who are facing this, you just need to go to the zoom setting for your navigator and put the zoom lvl at 80%.

Hello Community, First time here. My database has supplier_table and item_table with pricelist_table as a junction table to create pricelist history between supplier, item, and date field. I create po_table to record purchase order and want to have a field to link to pricelist_table, but only link to the records that have the lastest date of matched supplier_id and item_id in the po. For example,

I track project sales leads. Every lead has the potential to turn into a project, so when I enter the lead, I also enter an estimated value. If it does turn into a lead I want the estimated value to go into the correct field depending on the status of the lead/project (Sales Status Multiple Select). Field: Estimated Estimated value goes into this field when the Sales Status is ‘Lead’, ‘Warm’ or ‘Scheduling’ Field: Booked/WIP Estimated value goes into this field when the Sales Status is ‘Booked’ or ‘WIP’ Field: Invoiced Estimated value goes into this field when the Sales Status is ‘Invoiced’. Of course, when a value goes into the correct field, the field it came from gets zeroed out. Right now I have to manually move that amount between fields depending on the status of the project. Sometimes I forget, or I put a value in one and forget to delete it from the other, which artificially inflates the proj

For some reason, I’m no longer seeing the “Add option” button when setting up a Multiple Select field. Instead, all I have is the “Add description” button. See screencap below. What gives?