Hi everyone! I'm designing a UXR base and would love advice on how to design an automation that allows me to connect two tables and two bases together. My current base design consists of the following:Table 1: Intake and PlanningPrimary field: study ...
Hi all! I am pretty new to AirTable, and I wanted to ask for advice on creating an automation for an inventory table. I would like to create an automation that:
When something purchased (check marked under the “purchased” field) before is purchased a...
Hello,
I am pretty new to AirTable, and I was wondering if anyone has advice on designing an inventory base/ tables for a small business. Currently, I have three tables for inventory - employee equipment (IT Equipment), supply closet inventory, and o...
Hi Mohamed,
I am hoping that when I click the checkbox under the “purchased” field in the Shopping List table, the “Movement Table” updates that item’s quantity (if it was purchased before).
I would like the automation to update the movement table be...
I have tried inputting a few new records. Since quantity is a rollup field, does this mean the only way to manually update the quantity is by submitting a form that “checks out” or “purchases” the item?
Additionally, I have added a shopping requests ...
This was incredibly helpful, Adam! I truly appreciate the time and effort you put into your answer. I will definitely redesign my existing base with your tips and techniques. Thank you so so much! :blush: :pray:
