I'm using groceryCRUD for file routing purposes.
My database looks like this
parties // just basic information about parties in the system
flows // this table connects parties
sender (fk to parties.id)
receiver (fk to parties.id)
Ie, one party in the system sends to another, in a specified direction.
Now, I'm trying to add enveloping to the routed files (the user is configuring one envelope per flow);
flow_id (fk to flows.id)
Now - here comes the problem. How the heck do I get this to work in groceryCRUD?
I wanted to get the flow name, ie "Sender -> Receiver (Direction)" which works if I do a SQL query. But can it be done with set_relation or _n_n?
I've tried so many different variations, but still doesn't get it right.
The most important thing is to get the flow name for the dropdown when adding new envelopes, instead of having to input a flow_id. That would of course work - but is not user friendly.