Base Design

Hey friendsI want to build a content plan for social media according to dates.So:I have several tables for each platform:1. Facebook2. Instagram3. Tik Tok4. Email marketing.In each such table I have the topic (story, post, etc.), the upload date, the content itself and status.I also want to have a master table that will actually contain date, status, comments and also contain a Facebook, Instagram, Tiktok and email marketing column (linked columns).I want the main column in the master to be the date and actually when I write a certain date it knew to pull me to my linked columns what needs to be uploaded each day according to each platform.For example, I will choose the date 05/18/2023 - it will automatically fill in the Facebook column what needs to be uploaded that day, in the Instagram column what needs to be uploaded that day, etc.I tried to automate it but I'm completely lost 😞In addition, I want to create an automation that will know that if the tasks of that day have bee

Hey friends, maybe salvation will come from here.I try to do progress tracking for my students - that is, if a particular student wrote that they are "doing well" or "need help".Now - I want to find a way to tell Airtable to update the next empty column using an API CALL but I can't figure out how to do it.For example, in the picture I attached - if user1 called "זרם" gives his answer it will be updated in week3 but on the other hand if the other student writes any answer it will go into the week1 column.Does anyone have an idea?thankss

I'm currently facing an issue and would appreciate any insights you might have. Here's the situation:I have two tables: a main "Companies" table and an "Updates" table. In the "Companies" table, I've created a Linked Record field for the "Updates" table. My goal is to have a list of all updates for each company displayed in the "Companies" table.Previously, I had a setup where this worked. The ID field was structured as [Name of Company + Date], and it showed all the related Updates for each Company. However, in my new "Updates" table, the ID field is an Autonumber, and each record has a Link to the corresponding Company from the "Companies" table.With this new setup, the linked updates are not showing up in the main "Companies" table as they used to. I'm unsure if the change in the ID field structure could be causing this issue.(Snapshot of my previous setup for reference)How can I set this up? Is there any workaround? For context, the end goal is to be able to show a quick list of up

TLDR; how to I grant 'conditional' creator permissions within a paid workspace?I've built up some pretty robust Bases for my company to track our projects.  We're using airtable as a stop gap solution on the way to a larger ERP software rollout.  I built an interface for every department to use that allows them to view and update relevant information (process tracking, shipping address etc etc), and prevents them from viewing sensitive information (employee addresses etc etc).  No one has access to the Base except for me, everything is done through the interfaces.All of this is happening through a paid PRO workspace, everyone with interface access is a billable collaborator on my workspace.  It just so happens that we've hired a guy who's very fond of airtable and wants to build his own base for his own workflows, and sync a selection of my tables into his base.  I'm fine with that, but I'm not sure how to grant him creator access to the workspace (thereby givi

Hello everyone,I'm looking to build a base to collect a long list of songs that our team members play during the day. A team member is a member of a group, and some groups have several members who play multiple songs during their work schedule. I have explored various solutions online, but it appears that the solution we need is more advanced.Any assistance would be greatly appreciated.Best regards

Hello, Is it possible to have numbers in a base with more than 8 significant figures? We sometimes work with very small numbers ranging from -E10-11 and the current method rounds the numbers/cuts off at 8 decimal points.  Thanks

Hi guys! I was just wondering what is the maximum fields in Airtable (Enterprise or Pro)? I heard that the number is 500, but this is too small for me. I would like to import more than 100.000 products (in records) and for each record I want around 1,200 fields (columns). Does anyone know if this is possible? 

Hi! I want to build RMA base and I'm struggling with the basics.. do I create one base with multiple tables or just one table? Can someone share their template which can help me build the structure?Thanks.

I've got a table with People informationNameGenderEthnicitySallyFemaleBlackJohnMaleWhiteMarkNon-BinaryWhiteAnd a table with events:EventDateParty2022-01-02Service Project2022-02-03And a third table with lookups that pair people with events:Master ListIDEventPerson1PartyMark2PartySally3 Party John4Service ProjectMarkSo, what I need is a way to summarize the attendees, like how many white people were at the Party.Seems like I should be able to do that with rollup fields on the event (since it's linked to the people on the Master list) but while I can get a list of the "person"s who were at the event, and get a list of those on the "event" table, I don't see how to probe the people table to get the info I want...Do I need another table?

I have all my Raw data going into one table, and then I'm syncing it to another table to customize it so it looks more ... understandable, with Dropdown and colour codes and such.  If I change the field types in the Second Table, will the syncing from the Raw table still populate?example: the status field in the second table will be a single select (New, Old, or blah), when a record is synced with a status of 'New' (or dare I dream 'new', will the status be the single select choice of New be selected?Also, what happens if there's an option that isn't in the list?

HiI would like to know how to save images into airtable field while saving data from a webapp UI (build using nocode tools like bubble). Unlike other data fields this image field is not getting saved by following standard approach of mapping table column to the webapp user interface's field's  value.Should scripting extension be used to achieve this (having an url and saving url to image?). Or Am I missing some thing. Please suggest.ThanksSri

Hello! I'm an artist using Airtable to keep track of each artwork that I create. I currently post some artworks on sites that allow me to promote them with affiliate links. Here's what I want to do - if I indicate in my multi-select status field that an artwork has been posted to an affiliate site, I'd like that artwork record added to a new "Affiliate Table" that includes a field for affiliate link. This way I can track individual artworks and larger page section affiliate links on the Affiliate Table. So... how can I do this?

I need to create a private table in a shared based where only select users can VIEW and EDIT. Is this possible? Any extension that could help do this? 

Hi! Wondering if anybody has an idea for this:I've set up a form for my company in which they can submit a contract request for a talent, and if that talent has an agent ; they can then submit the agency name, contact & info as well. The form entries are set up as a "single line text" because we're constantly working with new talent & agencies, so i don't want to limit managers to a "single select" option, if it means they can't input a new talent/agency.Now what I would like to do is create a tab of all of the agencies we've worked with across the organization, and be able to easily pull together their talent roster. I've tried syncs and linking to fields, but if we work with the same agency more than once - it just creates an all new record, instead of adding their talent to the original record. Has anyone worked out a problem like this before?

Original base primary field was not useful [Newbie design]. It is 312 records. The data will not change and no records will be added or deleted.I copied data from another field (same field type - single line text) which will also not be changed. I did a copy & paste from the second field to the primary field. The data copied from the second field has dependencies.Question: Can I change the dependencies from the second field to the primary field or should I just 'Hide" the second field?

Hi all,Wondering if any one has experience of syncing Airtable with JIRA Cloud, I've setup a sysnc'd table in Airtable to pul our service desk data so I can build a dashboard, however some of our custom fields have not been pulled though one example is Organisations, this is a key field I need to build a useful dashboard. Any help would really be appreciated. Thanks in Advance Matt

Base A has two tables (table 1 &  table 2)table 1 has a "link to another record" field to table 2 is it possible to sync both tables to Base B and keep the "link to another record" fields intact so that data will continue to sync? or is this something that can only be done with the ability to 2-way sync in the enterprise plan? 

Hello, Our Marketing team uses Airtable to manage tasks and campaigns across functions. These bases sync to a single base that marketers can use to view all their tasks across different bases. My question is: can we manage and process these tasks from the consolidated synced base? Doesn't seem so...all we can create are views and if we want to update the task and/or import documents, we have to go into the source base from which the synced task originated from. Is there away around this? Can we open permissions to all updates to the task in the synced base that will carry over to the originating base?

@WilliamPorter thank you both for your answers. I guess my question here is pros and cons of email vs. Full name as Primary fields. At first i had emails, which is very useful as i tend to link my calendar instances using "attendees" field which then links with contact email address. But the cons was whenever i searched i want to search for a contact, i can't do so using their name. (in forms etc, linking manually in other tables etc). Now i switched the primary field to full name, but then i am unable to auto link my calendar instance using Attendees field. So my question here is: what is best practice? is there a way of keeping email, but being able to find contacts using their name rather when searching? alternatively, is there a way of linking record to table using a defined field than automatic? thanks 

Inherited this position.  Not getting much help from my predecessors.   I learn best If I can talk to you share my screen et.  al I am willing to compensate  My issue will be trite to you I am sure.Some of my questions:my predecessors created new tabs. How did she move the names to them from the main data base? We have a  column set up that when you type in the category the name moves to the designated section. I did it and it created a new section?I get multiple notifications of a new prospect. Where is the notifications or is that a google thing?  pretty essay stuff, but if you have no clue not so easyDankeRodney membership@pnboa.org 

HiI have a list of business divisions (business divisions table) within an organization like, 'Large Projects', 'Innovation', 'Small Projects', 'Government Projects' etc.There is a employee master (employees table) where in each employee is mapped against a business division. One division can have multiple employees linkedThere is a need to create new project(projects table) for a division  and select an employee for the project. While selecting the employee (a linked field in projects table pointing to employees), is there any way to restrict the employees that are belonging to the business division selected (a linked field in projects table pointing to business divisions table)If there are any alternates please suggestThanksSri

Hello Community,I need to have an address table that deals with some people having different street and mail addresses and some having only a street address. How can I structure the table to allow for both while being able to filter for a list for mailings? Any thoughts would be appreciated.Thanks, Scott

Hi, I am new to Airtable, so apologise if this is basic. I have records: CR001 record detail CR002 another record detail is there a way to auto fill CR003 if i add a new record? Thanks, Simon

Hi All -  I'm trying to get a better understanding of the Google Calendar Table Synch. Goal: Add attendees one by one to a Google calendar event as they RSVP through a front-end system that uses Airtable as the backend. Current setup: Events Table that is synched to our GCal, second RSVP table that connects 'Members' to 'Events' Every time I try to find a workaround I ended up running into another issue. I'm not able to edit Synched Tables directly and there isn't a two-way table synch, so I wouldn't be able to add Attendees directly in the Airtable.Automations worked almost perfectly, but you aren't able to add attendees, you can only replace all attendees. The problem here is that I would create so much email spam if every time someone new signed up for an event, we send all previously RSVPd guests another email.  Are there any Airtable native solutions? Is Make.com or Zapier the only way? Am I missing an understanding of the Synch works? Any input

I have a look up field set up with a condition, but i want multiple records that meet the same condition to also populate.  how do i do this?