Base Design

How do I revise this formula so that it gives me both the week # and the range of days in that week? DATETIME_FORMAT({Date to work on it},‘ww’) Also, is there a week to do a week number that doesn’t start over at the beginning of the year? All I really want to do is be able to create either a chart or a pivot table that gives me the sum of an integer weekly over about eight weeks. Thanks!

I have a base that has a table for tags, a table with a list of clients, and a table with images in the images table I have images, a lookup field for the tags from the tags table, and then a lookup field for client client A’s red tagged images are image 1 and image 4 client B’s red tagged images are images 2 and 3 in the client tag sets base, I specify which tags belong to each client (tags can overlap) client A: red, green client B: yellow, orange, red both client A and B have images tagged ‘red’ in the tags table, it shows each of the tags, the images containing each tag and the client tag sets I’m having trouble figuring out how to create a grid view within the tags table that will show the images tagged ‘red’ but only if their client is client A. and then another grid view that shows images tagged ‘red’ but only if their client is client B.

I’m currently trying to create a database of insurance companies and the benefits they offer. Each benefit can be offered by several vendors, but I want to be able to have the linked “Benefits” record for a specific vendor expand to show the details specific to that Vendor. Initially, I had a column called Benefits that was a multi-select, and I selected the relevant benefits for each insurance company. When I realized I can create columns that reference other columns, I converted my multi-select column to a linked record column, and had it reference a list of benefits that I created in another table. However what I didn’t account for is that while the Benefits buttons are now clickable for each insurance company, they will all reference the same singular record. Ex: Insurance Company A, B and C all have deductibles, so each will have the “Deductibles” option under the Benefits column in their row. However Company A has a $500 deductible, Company B has a $1000 deductible and Company C

Hey! I manage a large, complex content planning/recording Airtable base. We have a table of content campaigns that are linked to specific deliverables records that live in their own table. Each deliverable has a unique publishing date, which means that a single campaign might have multiple publishing dates, or a campaign may not have an associated deliverable published for a long interval, but would need to be resurfaced when a new deliverable is added. Is there a way to create a calendar view that would display the content campaigns based on the dates in the linked deliverables (with the caveat that if there were multiple deliverables on the same day, the campaign would only appear once)? As an example we might have: Content Campaign A [Table 1] Twitter Deliverable (Scheduled for 11/23/22) [Table 2] Instagram Deliverable (Scheduled for 12/15/22) [Table 2] Site Deliverable (Scheduled for 03/02/23) [Table 2] I would want a calendar view of [Table 1] that surfaces the Content Campaign

Hello, I am looking for a free form software that will integrate with Airtable that I can put on my website. Many of the form softwares that I found either cost money or have branding on them. Does anyone know of a software that is free without branding? Thanks!

I am building an archive of the activities of my amateur theatre company. The main table is productions - for each production I have a number of fields that relate to people - Author(s)/Director(s)/Cast/Crew. These are linked to tables so that I can see all directors and what they have directed, all authors and what they have written etc. Now, in this group, someone might write one production, direct a different one, act in another and be backstage crew in another. I would love to be able to have a People table where it shows that Joe Bloggs as an actor in XXX, crew in YYY - so you get an overview of everything Joe has done across all productions. At the moment Joe is listed once in Actors and once in Crew. Any suggestions as to how I do that? The Base is here: Airtable - Brussels Amdram Theatre Archive

I’ve tried to demonstrate what I’m looking for in this video: Loom | Free Screen & Video Recording Software | Loom

Hi Airtablers! I’m new to airtable and trying to figure out if it will be a suitable tool and I could really use some input from people who know more than I do… I’m trying to build a stakeholder register that has a RACI breakout for each stakeholder BUT it gets a bit complicated because: Each stakeholder may be a part of multiple projects Each stakeholder may have different RACI assignments for each project Each project can have different stakeholders I also want to use an exported .csv to include details about each stakeholder for easy reference, and use a lookup so that I only have to enter the stakeholders name and their details autopopulate (this part I do have working). In terms of reporting, I need to be able to see at a glance: Which stakeholders are involved in each project, and their RACI assignments for that project All projects that each stakeholder is involved in (since many are involved in multiple projects) Any insight/tips would be greatly appreciated!

I have an Admin Base that has all of our user data. We have three different types of user data stored in our Admin Base. I love the Sales CRM Base Template from Airtable and am trying to figure out how to sync the data from my Admin Base into my Sales CRM Base Template. Does anyone have suggestions or ideas on how to do this? All of the fields in the Sales CRM Template are hard coded, so they have to be input directly. I’ve started creating synced tables and mimicking the formatting of the template, but now I’m just recreating the template with my synced data tables. This feels inefficient and like poor design on my part (or worst case scenario, a limited template capability). I thought about downloading my Airtable data into Excel, reformatting it to fit the Sales CRM Base, and then reupload it there, but that sounds awful and it wouldn’t sync in the future. I could create automations to sync the data from them on, but the number of automations necessary would be terrible to write (fr

Hi! Thanks for your help. I’m creating a database with multiple select and single select columns. I want the “answers” / “tags” (aka what people can select) to be generated when my team fills in a form for this database. As an example, I want the form users to be able to enter 5 keywords for a particular person’s interest, and have these keywords automatically become the options for new form users to select from in addition to new form users being able to enter new keywords (adding to the growing list). Or, I want them to be able to enter an organization’s name on the form (free writing it) and have that name automatically become part of a single select column for organizations on the back end. Is this possible? If so, how do I make this happen?

Hello!! Hope anyone can shade a light here. Here’s some preliminary information to help you understand what I’m trying to achieve… I have 3 tables within one base: Inventory (primary field: Product_ID) Packs (primary field:Pack_ID) Sales Orders (primary field: OrderNo) The “Packs” table holds packs that are made of one or more products from the Inventory table. The Inventory table holds the individual products used to make packs. I’d like to count the total quantity per item in the inventory table that has been sold, in other words the qty “out” from the inventory. Sales orders are registered in its table and each sale is done by pack.

Hi all, I need to find a simple solution for working with 2 columns with Single select. For example: Column 1 - there are two options - car or house Column 2 - there are four options - fast, slow, small, big If I choose the car in column 1 - It should be only 2 choices in column 2 - slow, fast. Options small and big are not available in this case. Thank you, Monika

Hello, I am looking for a way to display my airtable data in a graph. I know that I can use a block, however, I am looking to take the chart and post it on my website. I can use an iFrame, or something similar, I just want to be able to show the graph somewhere outside of Airtable. Any assistance would be greatly appreciated! Thanks!

I have a table - ‘Main table’ - where new initiatives are created and Jira tickets are generated through an automation when I click the button ‘Create Jira ticket’. The Jira issue key is then returned and populates the column ‘JIRA code’ as part of the automation. I want to automatically pull in the statuses of those tickets from Jira when they change, so I can see the ticket Issue Key and the Jira Status in the ‘Main table’. In order to do this, I have created an entirely separate second table ‘Jira tickets’ that pulls in tickets from JiraCloud (synced) - that have ‘Issue key’ as the primary key: Now that I have a column in my ‘Main table’ with the Jira Issue Key, and a second synced table ‘Jira tickets’, how do I pull in the status from ‘Jira tickets’ based on the Issue key column in the Main Table? I’ve tried all the different linked records I can, but no lunch so far.

Hi - I am trying to make a public base (that I can send to our customers) that would list all of our products. Then each one would have a call to action button that would email the right person. Example: Description of Product A - the row has a button that sets up an email to Salesperson A and says they are interested in Product A

I am trying to create a form to make it easy for a user to enter inventory for a list of items in another table. The goal is to make it easy for them to enter inventory for all the items without missing an item. It is possible to make a form for the inventory that lists each item in the items table as form items? Thanks.

We schedule people to work at many locations. Each location has a unique target number of employees for that day, as well as subtargets for specific roles. For example, a location may need a supervisor, assistant supervisor, three generalists, a specialist 1, and a specialist 2. We created an employee table and a locations table. The employee table has a position field. The employee table links to the locations table to create the work assignment. The problem is that you can end up assigning two supervisors or no supervisors, or too many or not enough of any position. We could create role target fields in the locations table and then count the number of employees assigned to that role in that location, but it’s a whole lot of work. I can’t think of anything more elegant or streamlined. Ideas welcomed!

I have too many columns in my table and would like to move this data to a different table. How would I go about doing this while still retaining a reference to the old rows? Current Name Data 1 Data 2 Data 3 - To be moved Data 4 - To be Moved Desired Name Data 1 Data 2 Link to row in new table Data 3 Data 4 Link to row in previous table Hope that makes sense! Thanks!

Hi, I need tips on how to set up an automation (or anything that works) that updates the status of a task based on another in the same project. For example: If Campaign - Copy task status is In Review Then Campaign - Copy For Review task status should automatically change from “Not Started” to “Ready for Review” for the reviewing manager.

My team has a base where we track all our projects which is linked to a another base where we are doing all of our capacity and velocity tracking/forecasting. In the capacity tracking base, we have hours of work associated with each of our project types (e.g: Project Type A, Project Type B, Project Type C). Those project types are correlated to the same project type classification in our project tracker base. In order to accurately calculate the amount of time per project type, we want to have a field that references our project tracker base and counts the number of each type of project and automatically populates the field. In the image - ‘Current Projects’ column should be referencing our project tracking base and counting how many records match what’s listed in the ‘Engagement Type’ column. Then populating the appropriate number. This is currently all manual. We’ve looked through a bunch of documentation on roll-ups, counts, formulas etc. and feel like we’re missing something. Any b

I think I should be able to do this but I’m not sure how. (I’m definitely an AT beginner!) I have a base for managing summer rentals. I’m pretty much treating it as a spreadsheet with each record a tenant name and then a bunch of info in fields… Lease, total rent, deposit, deposit received, etc. I’ve used this base for two years. I have a formula for figuring the lodging tax BUT it has changed this year. 1) I don’t want to change the formula since that will impact my records for the last two years 2) how do I set up AT so that I can reflect changing tax rates over the years? I think I should have a another sheet that calculates the tax and then pulls it into my main sheet based on the year I’m working in. create a table for the taxes and then a lookup formula? I’m not clear on how to do that. On the main sheet is a column that is empty which is where I think I should be pulling in the tax info…?

Hi there. I am trying to work out how to compare data across several different projects. My specific need is as follows, hoping someone has a quick solution to this :slightly_smiling_face: I have a primary table with hundreds of records (let’s call it “master data”) I have many offline spreadsheets for different projects with content that matches the fields in “master data”. I want to find a way to import the spreadsheets so that the following is achieved. For any existing records enrich with extra information (multiple-select) For missing records create a new record Do not replace the original data in master data (only add to it. Can this be done?

Hello, I’ve been using Airtable as an API with NodeJS and Netlify. I’m working on a project and don’t even know if this is possible with Airtable. Let’s say I have a guitar. It has a manufacture, model name, price, etc. I’m all fine with that, BUT…it also has a number of descriptions such as… Smooth and fast playing feel enhanced with Fret Edge Treatment, Recessed control knobs stay out of the way of your picking hand, Signature pickups in HSH configuration offer everything from snappy cleans to screaming leads, Push/pull volume control gives you access to coil tapped tones too, Is there a way to have all of these descriptions in one table? I would call them up in the API and then map through them. Contentful has something for this called ‘extras’ that allows one to enter the data as a JSON entry. I don’t know, maybe this can’t be done in Airtable. Thanks in advance.

Any tips on how to set up a database to do QA (Quality Assurance)? The main issue is that every project has different requirements and questions, so using one table seems like a no go. What is constant The only constants in the whole database are three: Customer, by this I mean that a Customer is the owner of one or several projects, Platform (example “Desktop”, or “Mobile”), and Type of questions* *(But, content of questions changes from project to project) What changes from project to project Everything else requires a unique ID Testers’ IDs (they are anonymous) Questions Number of questions Content of questions Its attachments, if any Type of attachments, if any Should I create a different table for each new project? Thanks

Hi there, I was hoping to get some guidance on time logging with my bases. In short: We use Airtable to track projects end to end. I have multiple tables set up that are all linked and cover the project, tasks (each project will have a unique set of tasks which we create a record each for), capacity, priority etc. I have set it up in a way that allows us to attribute any month to a task to which it will be worked on, the est hours we will spend, and the amount of hours we have spent. (All linked through multiple tables). It is a patchy set up and has multiple issues when a task is being worked on over more than 1 month. The time tracker plug in is not suitable as we will often retrospectively update a project/task with hours we have worked on it for that day/week etc. Is there any insights you can give or template bases which are set up for this kind of project tracking? Many thanks in advance. Best regards Seamie