Yuto Tsujimoto
In the process of developing a repair application using Stackby, I've come across a limitation that hinders efficient workflow. To optimize the user experience and improve data input/output efficiency, there's a need to be able to add/delete child records (and any other records linked further down the path) directly from any given view.
Current Behaviour:
When creating a record, it's currently not possible to simultaneously create linked records across multiple tables using a single form.
Desired Behaviour:
  1. From any view, users should have the ability to add a parent record and simultaneously add child and grandchild records.
  2. Similarly, from any view, users should have the ability to delete a parent record and have the option to simultaneously delete its linked child and grandchild records.
Use Case:
Consider the tables - RepairRequest (Parent), RepairProduct (Child), and RepairPart (GrandChild). If a user is in the RepairRequest view and wishes to add a new repair request, they should be able to:
  • Add a RepairRequest entry.
  • Directly add a linked RepairProduct entry without having to navigate away.
  • Further add a linked RepairPart entry, all from the same form/view.
Benefits:
  1. Efficiency
    : Reduces the steps needed to input related data across multiple tables.
  2. User Experience
    : Provides a more seamless experience for users by preventing the need to switch between views/tables for related data entry.
  3. Data Integrity
    : Reduces the possibility of orphaned records by ensuring that all related records are added or deleted as a coherent group.
Conclusion:
The ability to add/delete linked child records from any view will significantly enhance the user experience and data management efficiency for applications developed in Stackby. This feature would be particularly beneficial for complex data models with multiple linked tables.