Help
Base Design
cancel
Showing results for 
Search instead for 
Did you mean: 

Base Design Activity

BASE DESING ISSUE AND AUTOMATION FOR PERIODIC REVIEW

HelloI'm testing airtable and I want to make a database with all my trial cases. These are cases that we must check  with some regularity, the idea is that each case generates a record and that once the record is created, it will be assigned to a rol...

  • 13 Views
  • 0 replies
  • 0 kudos

Add 'This Year' and 'This Month' to a view's filter

It would be awesome if Airtable added 'This Year' and 'This Month' to the filters. This way, I could create a view of records, like expenses or invoices, that apply to this month or year. I'm actually surprised this is not already a feature. It seems...

  • 56 Views
  • 2 replies
  • 1 kudos

Line Item Support Help

Hello!This is my first post, so I hope I'm posting in the right place.I am trying to use Airtable as a production board for my company. When an order comes through Shopify, I have Zapier tell it to upload the information with Line Items, but my team ...

  • 51 Views
  • 2 replies
  • 0 kudos

Resolved! Performance Rating Form that Updates an Record

I'm having trouble creating a Form that I can use for Performance Ratings, and having that Form's fields update the Record field for the table. I believe I might have this architected in not the best way. Let me explain below.I have a Table that list...

  • 73 Views
  • 4 replies
  • 0 kudos

Dulpicating Table Error

Hi.I have a large table with Approx 110 Fields, 90 Views, 6,500 records and a number of automations etc. The table was created using the Emailed Data Sync as its Source. I need to duplicate this table, delete the records and then start using a fresh ...

Airtable duplication error.png Airtable duplication error_no toggle.png
  • 50 Views
  • 2 replies
  • 0 kudos
Albie by 5 - Automation Enthusiast

Assign a value to first linked record only

When using linked records, is it possible to apply a value to only the first linked record in a cell?So if I have two tables.Table ATable BWith Table A, I'd like to find a way for the Revenue to only be a logged against the first linked record in the...

artichokejoe_0-1696237373572.png artichokejoe_1-1696237431877.png
  • 51 Views
  • 1 replies
  • 0 kudos

Resolved! Bulk Editing Records

Hey Guys! Hoping everyone is well. I'm finding myself wanting to bulk-update records by a specific field and I'm wondering if this is possible? Does anyone know? Is there a script or anything? See the two fields? "Goes out to" and "Status"? Both are ...

Screenshot 2023-09-29 171423.png
  • 101 Views
  • 5 replies
  • 0 kudos

I'm Stumped! Looking for a certain Condition

Looking for a way to use Conditions to view something like this: Where Lookup Field  matches Linked Field I want to show all the date/times from a lookup field that corolate with the same employee who completed a form. Hopefully, the screenshot below...

Airtable Question.png
  • 670 Views
  • 1 replies
  • 0 kudos

Resolved! Airtable Forms for Finance/Accounting

Hello,I'm reaching out for ideas for doing an Accounting Forms (like a Check Request form) through Airtable. I love using forms to reduce data entry, however, I haven't been able to find a form that I can use to complete something as "complex"  as a ...

  • 83 Views
  • 2 replies
  • 0 kudos
M_L by 7 - App Architect
Solved

Solutions needed for 100k+ row Airtable base

upgrading to Airtable's Enterprise plan would remove the base row limits and allow more automations, but as of my knowledge , it is very expensive around 10k$?We have a large dataset that exceeds the 100,000 row limit per Airtable base. We also need ...

  • 63 Views
  • 0 replies
  • 1 kudos

Synced Table from Tableau rounding currency field

I have a table built in Tableau that appears fine on screen, showing the currency fields with 2 decimals.In the past i had to export as crosstab csv and then use CSV import extension to update records in Airtable. Now i want to just use a directly sy...

Screenshot 2023-09-28 at 7.25.10 AM.png Screenshot 2023-09-28 at 7.24.25 AM.png Screenshot 2023-09-28 at 7.24.14 AM.png
  • 45 Views
  • 0 replies
  • 0 kudos

Staff training

I’m creating a database of training staff have completed. I want to be able to cross reference between a table of staff and a table of training so I can:pull up a staff member’s records to see what training they’ve carried outsee the different traini...

  • 56 Views
  • 0 replies
  • 0 kudos

Events CRM - track attendance

Hi Airtable Community!I've been tasked with creating a CRM for Events invites and attendance tracking and would love any input on best ways to proceed. So far I have a "Contacts" table and an "Events" table, which are linked based on who got an invit...

  • 59 Views
  • 0 replies
  • 0 kudos

Simulate an outer join?

I am trying to create a base that tracks documentation-compliance.  Essentially, I have employees that have one or  more licenses, where each license requires the presence of a variety of documents to be in compliance.I created four tables:Employees ...

Employees.png Docuyments.png License Types.png Document Types.png
  • 86 Views
  • 2 replies
  • 0 kudos