What are
/r/Airtable's
favorite Products & Services?
From 3.5 billion Reddit comments
The most popular Services mentioned in /r/Airtable:
Airtable
Zapier
Notion
Loom
Taskade
Fibery
Supabase
Infinity
Bubble
Dark Reader
Screencast.com
Figma
AppSheet
Product Hunt
Gmail
The most popular Android Apps mentioned in /r/Airtable:
The most popular reviews in /r/Airtable:
>Notion is closest one. Has support for notes and tables, but lacks API, good calendar view and integration.
​
Thank you! This website is https://www.notion.so, was a little tough to find.
You can use the Scheduler app on the Airtable Marketplace. It prevents people from overlapping reservations. https://airtable.com/marketplace/blk57zTNniLeiB8m2/scheduler
If you have any questions about the app, I'm the one who made it so feel free to ask me
Unfortunately, Airtable forms doesn’t have validation built-in for URLs. The best you can do is offer an example of the format airtable.com, www.airtable.com, or https://airtable.com. You can also build a separate column to verify if the address is valid and then use that to pass onto Webflow or other source.
You can do this by using the 'Text Functions' formulas.
The process will be:
Long Adress: Market St. San Francisco, California 94102, US.
1st formula FIND() — find the first number '9' from the Long Adress;
Result: number '9' si the 34th character;
2nd formula MID(): count 5 digits from the result of the 1st formula and extract the text;
Result: 94102
An example right here.
But, it will be easier if have the same structure everytime. If you don't, you could use a combinations of other 'Text Functions' to achieve the same time.
For example, you could star the counting from a specified digit, like the 5th one, or the 3rd one. this just to eventually skip some numbers from the begining. But, no worries. If you take a look at all the 'Text Functions' I'm sure you'll find a way.
Hope it helps!
AFAIK, forms in Airtable function as a way for people to add records to an existing table in a base without needing to pay for another collaborator on the workspace, which is why 3rd party providers have stepped into that space.
There’s an app in the marketplace that might be able to help you, but it might be more of a workaround and less of a solution.
I’m not the app developer, I have no link to the app developer, I am a big fan of the app developer.
For internal use, you could try my app Scheduler. It allows you to pick a record and then only select unoccupied time slots on a calendar interface.
https://airtable.com/marketplace/blk57zTNniLeiB8m2/scheduler
The app itself is free but you need an airtable pro plan to install it from the marketplace.
It is also open source so technically you can install it on a free workspace as well, it just requires a bit of coding to do so.
Airtable has one of the best API docs in the business. They're dynamic and render content based on your own database and account information. The API itself is nothing special but it's more than enough to get you what you need, I just hope you're familiar with Node or ready to get acquainted.
Heyo! Love the usecase! I copied over your base and created a formula that matches the date with "today" checking whether the year, month and day match today(). This is the formula:
IF(AND(YEAR({Start Date})=YEAR(TODAY()),MONTH({Start Date})=MONTH(TODAY()),DAY({Start Date})=DAY(TODAY())),"today","not today")
You can then create an automation when record matches condition of Today? = "today"
Here's base share link with the formula field in it: https://airtable.com/shriYb2vCCEjpZnMu
Hope that helps!
I created a sample base here that separates employees and projects. If you open the blocks panel you'll find a Gantt chart that shows who is working on what project each day. You can import a CSV into Airtable with all 150 projects and copy it into the projects table if you like. Employee could also be a link. You can only assign one project to one person - you can change this if you want.
Check it out - does this work?
I created an example of what I'm talking about here.
This is basically a stripped down version of what I do all the time keeping track of IP Addresses for devices. The first 2 or 3 octets are always the same, (Ex. "192.168.") but when I want to layout a scheme for dozens or hundreds of devices where there's no overlap. It's a whole lot easier to type in the 2 or three characters for the last octet in case I need to shift things around, and having the full IP is useful for sorting and exporting to other workflows.
Each block has a share icon on its top menu:
https://www.screencast.com/t/mKiZCWnv
​
Click on that and it gives details to either share via link, or embed code
​
The only downside, and maybe this is a deal breaker, is that when you embed the block, there is a link to view the data (see the 'Show Data' link on top right of shared block). When clicked, the user will see all the tables and non-private views.
​
I wish that were optional to show the data or not, but currently it is available always.
Miro is integrated with Airtable so might be quicker to set up. Here's more info about it
For PDFs, we have an annotation option in our On2Air Amplify extension
https://airtable.com/marketplace/blkyGU4Ofgq4DUfsq/on2air-amplify
Hello- I use this same concept to track invoices by using the initial invoice date, due date, and I like to know how many days until it's due (or, how long is left from the due date).
​
Initial Invoice: Simple Date Field
Due Date: Formula Field// DATEADD({Invoiced}, 45, "days") - all invoices are due within 45 days.
Due-in: Formula Field// DATETIME_DIFF(TODAY(),{Due},'days') - the days will automatically countdown based on today's date. So remaining days are shown as negative integers, Ie; -30 and counting down until due date. Once the due date has passed, the integers continue in the plus so you also know how many days they're overdue, etc.
​
The specific set of formulas you're looking for is the Day/Time functions which can be explored using Airtables Formula Playground: https://airtable.com/shr7tapg09rjpzHQ0 - you can copy and paste values from that field, or search for the Formula Playground on Airtable and you'll find the opensource version.
​
Hope that helps. Good luck.
That's very kind of you, I'll try to detail it below what I'm trying to do.
I run a large Discord book club server and one of the things that we do regularly are buddy reads where people submit info for a book or series they are going to read somewhere in the server with a group of other people; once submitted a mod approves them and the status is manually input as "soon to start" to indicate that people can show interest and mark their calendars. I have to do a lot of manual updating for these as they move through their life cycles, so I'm wanting two basic automations, based on the information visible in this view.
There are two formula fields for "Start Date Passed" that calculates if the "Start Date" field is populated with a day after today, and the "End Date Passed" field is the same but based on the value in the "End Date" field.
Scenario 1: When a record is in the "Soon to Start" status and the "Start Date Passed" field is "Yes", update the status to "In Progress".
Scenario 2: When a record is in the "In Progress" status and the "End Date Passed" field is "Yes", update the status to "Complete".
It feels more complicated to type out than I feel it actually is, but for the life of me I have never been able to get an automation working to do either of these. lol
Hello guys I'm creating an app that let you create beautiful dashboard just with a few clicks and your Airtable, can you give me feedback and if you are interested here's the waitlist (https://airtable.com/shrGFjdQSzgD4sYMT)
Check out our advanced schemas extension - On2Air Schemas. It will show you all relationships, you can filter by type of relationship, see all formulas, see all fields related to formulas/rollups/lookups, etc. and track schema changes.
https://airtable.com/marketplace/blkPImyxEpdEweMpU/on2air-schema
When you create a form, it does NOT automatically show your Airtable account name or email address. You CAN show that stuff if you like -- you can put any info on the form you want. But info about your account is not revealed automatically or by default. The URL for the form will look something like this:
https://airtable.com/shrfhmmiaUidpqtwz
NOTE: That is NOT a valid link. It's a modified version of a link to one of my own forms. I post it simply as an example of what the link looks like. If the link were valid and you got to the form, you'd see no info on it that I myself didn't reveal on purpose.
But don't take my word for it. Sign up for an account and give it a try.
> https://airtable.com/marketplace/scrwfNRCtO26rogvy/create-child-linked-records
what's the point of linking a record (row) to it's own data? I have only ever linked records across two different tables with the purpose being able to reference, or pull in, data that is not stored in the same dataset.
To confirm this mailing list subscription open this <a href="
1.
Field values
Confirmation form link
"> link</a> and click the Submit button.
https://airtable.com/shrs80Or8omomNaC1?prefill\_RecordID=
1.
Field values
Record ID
​
Neither of these work
I made a thing. You should be able to copy this and use it. Hopefully this gets you in the right direction. Please feel free to ask any questions you have as well!
We have an advanced search feature inside of our On2Air Amplify app. It doesn't specifically use the filter you're suggesting, but it does allow you to specify which field you want to search.
Yes we did launch the integration, but it's not available as a block. The user can sign up and buy a license directly on our website. Here's the link if you're interested.
We've listed our add-on on this list of add-on created by a user, but we don't get a lot (or any) traffic through that list. The most traffic we get is through online ads and through a few posts on the Airtable community forum.
This makes me think that you have 1 of 2 possible problems:
- You're running the automation while you're still inputting data. AT is not a huge fan of that.
- Your field formats don't match.
To solve problem 1, I would suggest using a very simple form to populate your Purchase Log table and change your trigger to "when a form is submitted." That way all the data is plopped in all at once.
To solve problem 2, I would suggest using number formats for your months in both the Purchase Log and Reports tables. You can use the Month() formula to pull the month number out of your date as a number and then it plays nicely with everyone else.
Your trigger is "when a form is submitted"
Table = Purchase Log
Your action is to update an existing record
Table = Purchase Log
Record ID = Record from Step 1 (click Continue), Airtable record ID (click Insert)
Field = Months (that's the link to your revenue table)
Inside the Field Box = Month as a Number
Link to form here.
Link to read-only base where you can see your entry and the automations here.
Could you just use the Airtable API for this? https://airtable.com/api
You need user to add their airtable api key on your web app, and that would give access to all data in given base. I think. :)
I've built a base that identifies the differences between two lookup columns using an automation. It may need some adjustment to suit your particularAirtable lookup compare automation use case though.
No, Airtable is really good when a item comes into view you can send a slack notification with a link. For what you’re trying to do, you’re talking about monitoring slack messages for specific words and then when that happens make a ticket. Id use Zapier and then make a new item/request in Airtable
Here’s a link of something I found that would be similar: https://zapier.com/apps/magnetic/integrations/slack/15106/create-magnetic-tasks-from-slack-messages-with-mentions-of-keywords
Be careful, and plan for all scenarios or you’ll have a million requests.
I think you can solve this through automations and structuring your database to separate the things you sell - products (which may be single components or assemblies) and the things you stock - the individual components.
BUT
The practicality of this and the way to approach it depends on how many parts and how many assemblies you have and how often they change
For instance you could create an automation that reduces component stocks when a product is sold - in a specific way - ie Minus 2 component 1 and 1 component 3 when Assembly one is done
You could create the number of components of each type as fields in a product and do something similar.
You may also have joy with this app
No. Tables are where data is stored, Views are a mechanism to display that data with settings for filters, sorts, or layout (I.e on a Calendar, Gantt, or simple grid), and Pivot Table is an app. Apps are a premium feature. You cannot have a base without tables or views; as in they are required integral features.
Well I made an app that's supposed to make linking several records together quicker. Junction Assistant would allow you to go to your Assets table and select the 20-50 items (using the checkboxes at the left of the primary field) and in three clicks link all those records to a new kit.
Totally, that's a lot of steps.
Is there a limitation with using Zapier to connect Airtable/Xero? (https://zapier.com/apps/airtable/integrations/xero)
Here's what I would do: https://www.loom.com/share/7d138894ab5a49edb99b1cc370628de2
Just look at using a long text "Note" field instead of comments, as it's a little clunky to capture that data. But this can be done directly in automations.
Nice comparison. I wrote very similar that compares Airtable and Fibery last year
https://fibery.io/blog/fibery-vs-airtable-we-connect-your-bases!/
I have not done it, and I'm not sure exactly what you mean by "sync". But if you're asking if Tadabase can connect and share data with Google Sheets, answer appears to be yes.
https://zapier.com/apps/tadabase/integrations/google-sheets
And same thing seems to be true for Knack:
https://pipedream.com/apps/knack/integrations/google-sheets
Actually I suspect there are multiple ways to do this with each of these platforms, and which would be best would depend on your exact requirements. And if you were to suggest a Google Sheets "pipe" to Tadabase, there's a non-negligible chance that they might actually create one for you.
This is one of the newer scripts that Airtable allows: https://airtable.com/marketplace/scrnxRnrzNkHidGmD/convert-attachments-to-urls and https://airtable.com/marketplace/scrkPFUb7UtqFRXSP/convert-urls-to-attachments
Hey! For the projects you use airtable on, is it sales based? Do you do any use of a data visualization type reporting apps, or apps that can import new leads from a google sheet and update to airtable? If so, please DM me your rate for something like that!
I want to mold my structure similar to this (a step up from my personal one that currently links leads to contacts and clients) https://airtable.com/universe/expLpOufs5M3HyF2U/sales-crm-dashboard
I'm getting stuck with automations (Zapier?) and migrations from the external teams google sheets system (it's just creating new sheets vs integrating it).
As a dad with two boys who is just waiting until I can get them to mow the yard for me, I love this idea. :)
I took a look at the Airtable Universe (love this place) to see if anyone had already created something similar and found this Family Chore Tracker example. I'm not 100% sure if it solves all the things you were hoping to achieve, but I thought the views by kid as well as the chore point tallies were handy. At the very least, maybe its something to borrow some inspiration from.
Check out On2Air: Amplify - https://airtable.com/marketplace/blkyGU4Ofgq4DUfsq/on2air-amplify
It has views that can do something like that
It looks like Airtable doesn't have any advanced filter API in its metadata API. Also, there is no particular trigger that Zapier might be using based on the metadata API.
Meta API docs: https://airtable.com/api/meta
I’ve modified the base in that example I linked to do what you want (I think). This is definitely one of airtable’s big limitations and I don’t think there’s much of a way around it without the “smoke and mirrors”.
This is a great use case for Airtable, actually. Here's a link to an example of this: https://airtable.com/shr3MfDzAhH7yrKBB.
You'll need three tables: one for Applicants, one for Jurors, and one for Ballots. Create a linked record field from ballots to both of the other tables, then add a rating field to the ballots tables. That's all you need structure-wise. Add a form view to the ballots table that you'll send to jurors. They'll select their name, then the applicant's name, then a rating.
Finally, you'll need a rollup field (or two) in the Applicants table. Link it to the Rating field of the Ballots table, then select AVERAGE(values). This will average all ratings for each candidate. I added a "# of times rated" rollup using the same links but with COUNTA(values). That way you can see how many people rated the candidate. Where you go with those numbers is up to your org.
If you want the candidates to submit a form, just add a form view to the Applicants table and whatever fields you want them to fill out.
Happy to elaborate on any of the above, not sure how much experience you have with Airtable.
It might be helpful if you check the browser's console logs https://zapier.com/help/troubleshoot/behavior/view-and-save-your-browser-console-logs
Look under the `Network` tab when you open your console and see if any you see any requests to Twitter or Instagram with 4XX error codes. If you don't see any requests that match, try refreshing the page with your Network tab open.
Assuming you can find relevant requests, share the contents of that request's `Preview` or `Response` tab here. Usually, this will show an error message.
Just make sure to remove any info you want to keep private before pasting :)
As others have pointed, Airtable has a REST API that you can use. It might be sufficient for your personal use, but if you plan on scaling it, know that it has rate-limiting: 5 requests/second. Airtable also has some interesting features like Scripting (an app within Airtable where you can use Javascript), and Custom Apps (customized applications you can build within the Airtable environment).
Better? Not quite right yet, but getting there?
https://airtable.com/shrLt89DFfcBPIAG1
Is it not possible to post images in comments? There's no button for images, and when I drag-and-drop into the edit box, nothing drops.
I will want to add fields like "# of followers" and "commented", as well as logos of the brand (and perhaps the social media sites too), so I think a relational database will ultimately be better than a spreadsheet. I want to embed the View in a (self-hosted) WordPress website.
The fact that each brand has multiple social media accounts and each social media site has multiple brands doesn't change the fact that it's a 1:1 relationship. Is that right?
I will want to add fields like "# of followers" and "commented", as well as logos of the brand (and perhaps the social media sites too), so I think a relational database will ultimately be better than a spreadsheet.
Another user made a set of recommendations which I implemented:
https://airtable.com/shrLt89DFfcBPIAG1
I was pasting screenshots here but the page kept freezing when i clicked to post.
Thanks.
Do I need to populate the linked field? The linked field in both tables is blank.
In a copy of the database, I did everything you suggested. Is this what you had in mind?
https://airtable.com/shrqIgKOtLTyTkCcf
I think you could make something that suits your needs in airtable.
I have a base for random software I want to check out (I got a similar feel with the toolsformalers.com)
Here is a gallery style page.
https://airtable.com/shr6NE8R3TIEluCGq/tblTJe1wKWVk80JMN
Also, with the same data I messed around with another no code environment and have this....
(For whatever reason, the logos are not showing anymore.
After some great feedback from this community, I've now launched Data Fetcher on the Airtable app marketplace.
Features:
• Use values from your base in the request URL/body/headers
• GET/POST/PATCH/PUT/DELETE methods all supported
• Import requests from cURL commands
• JSON/ XML response to Airtable transformation
• Response field types are inferred. e.g. dates in API response become Airtable date fields
• CORS proxy for all requests
• Schedule requests to run hourly/daily/weekly
Any feedback or questions feel free to post here or
Yes, Not with 'Shortcuts' obviously but with a dozen other apps including , Tasker or http request shortcuts
this is helpful! do you mind taking a view of this ~3 min Video going through the issue to see what I am doing wrong?
​
I really appreciate your help!
We have a fixed Word doc that comes from our client, and we just upload that to HelloSign and we send the URL to the recipient with this automation.
However, I just saw this on Zapier becasue you asked
And it looks like there’s a Zap that’ll send a doc when there’s a new record in a view for signature and update slack. I’m going to play with this, might not be any easier for us than just sending an URL to the signature page in general, since our new records in our main views are everyone. I’d have to make a view that populates with only the people we want to send an NDA to, whereas right now i just select two checkbox choices and off it goes.
Can't see to get the target URL to work. The link function works as desired, but the view does not become filtered when I go to:
https://airtable.com/ABC?blocks=hide&filter\_Organization=Lemonade
If I understand your problem correctly, I think I got it working. I copied your formulas into a base and made sure they were working using 14 character random alphanumeric "Referral Codes" I generated. Then I created a 3rd Column and stacked your formula. I played with the syntax a little until I got it to work. the Formula that ended up working is
SUBSTITUTE( SUBSTITUTE( SUBSTITUTE((UPPER(MID({Referral Code},4,5))),"I","T"),"2","Z"), "O", "B")
This 'Combined Formula' Column is producing the same result as your 2 formulas at least in my testing.
Here's a link to my testing table. Feel free to copy one of your Hashes into it to see if it does what you want.
I don’t really understand what you’re asking but I think it’s too non-specific. In any case, I’m sure you’ll find something which will get you closer to what you need by looking here. https://airtable.com/universe
Honestly, I've never heard of AirtableKit before. If you don't mind me asking, what are you using it for?
From the documentation, it looks like you can also use the BaseID rather than the base name, which you can get from the airtable.com/api page for your specific base. I'll be the in the Omnibar it looks like app[GIBBERISH HASH]
From my understanding. It's best to keep things that have the same attributes in the same table (phone numbers, addresses, related people), and differentiate them with a field (company type)
So I'd recommend putting all of your companies in one table, and use a field (single select or even formula) to determine which type of company they are: client or target.
You can accomplish the latter question "Which companies on our "Current Conversation" list also shows up on a partner's "Target List" through a conditional lookup. I think this could help. https://airtable.com/shrGrylU9l46fBqGe
Oohh, I'd love to see an answer to this as well. I've been using a Kanban view for my book club to keep track of our daily reading schedule of "War and Peace" this year, and the past days are hidden, but the stacks for them remain.
Not sure if I have come close to what you want but have a look at this Base Note that you have to make each recipe with IF and SWITCH formula... if you have lot of products recipes it’s going to be tough.
Don’t feel dumb... my bad it is a beta feature. I’m including the Airtable beta request. I never had to wait much before getting enrolled after requesting. In fact a lot of cool features are under beta because Airtable wants to release polished updates only. Beta Request
For an easy way to get data into Sheets automatically, check out SeekWell. You can query Airtable with SQL and send the results to Sheets, or via email and Slack. This process can be set up to repeat daily, hourly or every 5 minutes.
Doesn't jotform have it's own database tool?
Not sure but looks like this one. https://www.jotform.com/products/tables/
On another note I use Qualtrics too, but the setup is not all that smooth. It makes you work for it but so far it has worked smoothly. I'd suggest OP to check available integrations Airtable has with form builders.
There's a few ways you can achieve this off the top of my head.
1.) Airtable Page Designer App
2.) Airtable + Zapier* + Google Docs
3.) Airtable + Figma + Airtable To Figma Sync Community Plugin (Found Here: https://www.figma.com/community/plugin/741940457537193498/Airtable-to-Figma)
*Note: Zapier can be interchanged with any API/RPA that can host the integration.
If you're talking about pm you might want to check out Taskade, it's designed for remote teams. Another thing to consider is budget. My small business has less than 10 employees so using Taskade was the natural choice because it's completely free
I use airtable for my daily tasks but when it comes to the gym I use Taskade because then I communicate to my gym bro what we're doing today or something like that. It's free so maybe give it a try.
I did. Basically, because the linked record is from another table, its value shows up as a record ID and not the actual values. So I created a new Lookup column to turn that linked record into an actual value.
Reference - https://zapier.com/help/doc/common-problems-airtable
You could connect your Airtable to Zapier. Then connect Google Docs as well. Then build an integration that fills in a Google Docs template from your Airtable data passed through.
I don’t think you’d have to have a paid Zapier account for this. Neither Airtable or Google are premium integrations.
Yes. Airtable is a relational database and will be super helpful here. Also, you may want to think about how your data is structured. Why do you have so many columns? What can be captured in separate tables? Usually people have multiple columns for years (2020, 2021, 2022, etc) which is better served in a separate table all together like this example.
This system is released to Airtable universe now. https://airtable.com/universe/expizvNexF1xVefdf/covid-19-financial-assistance-system-tracker
Maybe take a look at https://airtable.com/templates/sales-and-customers/expZZ5ibXnHHPUYF9/business-development-crm, to give an idea of a set of linked records that isn't too far from what you are looking for. Your data analytics should serve you well as you structure it, since you are already thinking through what dimensions you need to be able to report on. (I also heavily use lookup fields, record grouping, and multiple views to make what you might consider ready-made reports.)
It sounds to me like you'll have tables for [Software], [Client], [Experience/Past Engagements], and [Internal Team/SME] to start. Maybe more depending on what a financial report might involve, or what information you want to be part of the [Experience/Past Engagements] Table, etc.
Good luck!
From what I found in the Airtable Universe, I think these templates could potentially be your answer! I would copy these templates to your base and play around with them
Design a Better Sitemap - Does not have a calendar view but has an Org Chart with the status of various pieces of info (ie, "Live," "Needs to be updated," "Staging," etc.)
Klipfolio's Content Calendar - Again doesn't have a calendar view but could easily have one added, and has a view where it looks like things are broken down by who tasks are assigned to. I think this would be good for the people that are new to the team like you mentioned to make the process more clear
I'm not sure if this will work for your particular application (in case you have privacy concerns) but you could include a Collaborator field and require that the user select themselves when submitting the form. It's not automatic, but it could at least potentially save a step.
Alternatively, I found this article on prefilling a form that might offer a solution if your team is smallish and the same people are using the form repeatedly. Add a Collaborator/Submitter field and make your share URL something like this:
https://airtable.com/shrFoRMuRlhERE?prefill_Collaborator=ADRASSA
Then each user can just bookmark a different form URL for repeated use, which will at least pre-fill that part of the form with their info.
I would recommend having the simple Contacts and Activities table structure to start. This allows you to take better advantage of Airtable’s linking capabilities. You can create views to filter and sort chronology for individual contacts...although users can only create views manually, and that would be a huge pain to create one for each contact.
IMO, Airtable isn’t best utilized for that kind of individual table per contact setup. I’m not entirely sure the max amount of tables it can support.
Overview of Airtable plan limits — https://airtable.com/pricing
The Pro Plan allows up to 50K records per base, but it is fairly easy to duplicate a base to use as a static archive, then clear out the active base and continue plugging away. Perhaps you could do one a month, or one per section of clients.
Really I think the viability of Airtable for you depends on the specifics of your use case — might be worth reaching out to them about the Enterprise plan to see if they can address your volume needs.
You may want to consider re-designing the database. I use Airtable for my personal finances as well.
Accounts table - each record is a different account (cash on hand, bank, credit card, accounts receivable, employment income, groceries expense, etc.). It has a one-to-many relationship between Accounts table and Transaction Line Items table, since an account can have many transaction line items, but each transaction line item can only have one account.
Contacts table - each record is a different contact (vendor, customer, employer, employee, etc.). It has a one-to-many relationship between Contacts table and Transaction Header table, since a contact can have many transactions, but each transaction can only have one contact.
Transaction Header table - each record is the header for a transaction (date, reference number, contact, memo, transaction number, etc.). It has a one-to-many relationship between Contacts table and Transaction Header table, since a contact can have many transactions, but each transaction can only have one contact. It also has a one-to-many relationship between the Transaction Header table and the Transaction Line Items table, since a transaction can have many line items, but each line item can only have one header.
Transaction Line Items table - each record is a transaction line item (account, amount, memo, subaccount, reconcile date, etc.). This is a join table. It has a many-to-many relationship between Transaction Header table and Accounts table, since an account can have many transactions, and each transaction can have many accounts.
See an example of the accounting database available at https://airtable.com/universe/expE8ozujutLf2fNh/accounts
Yep that's what I did recently. I made the field a linked field, creating a new table (in your case it would be a list of employees), then I did a rollup field to count them.
https://airtable.com/shr3ckZhqTKNpRXk1
I also have a tool that uses the API now that does this for me, might publish it later.
They do. checklist template be sure to look at the template universe because someone else probably already built something that you can customize!
Something like this:
https://workflowy.com/s/airtable-convo/2KNwXCrqUau0yCSk
I did this in 5 minutes but the idea is that you use look up fields and a formula. Let me know if you don't understand, but I'll probably answer tomorrow (GMT).