Jeff_Hladek - profile

Jeff_Hladek · Jul 26, 2024

I need some help with something. I am building out a project management system for my team. Our projects tend to be pretty big, so each project has it's own base. But, we need a project overview base to allow leadership to see the status of projects ...

Jeff_Hladek · Jul 22, 2024

Probably a simple solution, but I can not figure it out. I am using the following script to try to get a list of all of the records in a specific table.let table = base.getTable("Codes");let query = await table.selectRecordsAsync();console.log (query...

Jeff_Hladek · Jan 25, 2024

I am using a form with some prefilled fields. It works great as long as the item name doesn't include certain special characters. For instance, if it includes an "&" anything after the "&" won't be prefilled. So "Mop & Broom Holder" prefills as just ...

Jeff_Hladek · Dec 11, 2023

I am creating an inventory management system for a warehouse team. I have a table that tracks the current inventory level and a linked table that operates as "transactions". So the "transactions" table keeps track of added and removed inventory. The ...

Jeff_Hladek · Dec 07, 2023

Hey All!I need some help! I'm relatively new to Airtable and currently diving into setting up an inventory/project management system for my team. Our approach involves utilizing Airtable as a combined solution for both project and inventory managemen...

Jeff_Hladek · Jul 29, 2024

I am using synced bases, but it is a similar problem to Brian's solution. On the team plan, we can only sync 10 tables per base. We regularly have 10 is projects going at a time. On occasion we might have more, so it would be a challenge to sync ever...

Jeff_Hladek · Jul 29, 2024

I have thought of this, but our projects include products that we purchase. Each project can have up to 3500+ records including items to be ordered and tasks. We have the team subscription, so the max records per base is 50,000. That means we can onl...

Jeff_Hladek · Jan 25, 2024

Thanks, I was able to take this and adjust it a bit to make it work for our situation. I created a button in the project-specific bases that lead to a form in the Inventory base. I set up the form to prefill based on the data input in the project bas...

Jeff_Hladek · Jan 25, 2024

I figured this out like 5 minutes after posting this.For anyone else running into this issue, the solution is to use ENCODE_URL_COMPONENT() in the formula. i.e ...?prefill_Name='& ENCODE_URL_COMPONENT(Item)&'...This changes the URL to ...?prefill_N...

User Statistics

User Activity

Automatically update overview base

Scripting help

Prefill forms with the "&&" character

Open a form with the name field auto populated

Seeking Advice on Syncing Airtable Bases for Seamless Project and Inventory Management

Re: Automatically update overview base

Re: Automatically update overview base

Re: Seeking Advice on Syncing Airtable Bases for Seamless Project and Inventory Management

Re: Prefill forms with the "&&" character