Okay, a bit of context for clarity.I have a base that I am using for tracking inventory. We send out the packages of items. Sometimes we have some of the items in stock, and sometimes we need to order more before the package is sent. I am using an in...
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 ...
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...
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 ...
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 ...
Someone else correct me if I'm wrong, but I believe this is happening because DATETIME_DIFF is using months as a unit and is basically just counting in 30 day intervals. So October 16th is less than 1 month from today. Here is how I would get around ...
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...
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...
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...
