I need a bit of help, cant quite figure out how to set-up this (or if its possible at all).
I have 2 tables that I made quickly to illustrate this.
In first table we track sales with all the standard columns and information but also this small addition on picture where we want to track machines that are involved in their project and quantity.
Second table is kind of support table where we enter model of machine and quantity and I have display column as formula which use concatenate() to put this 2 information together and display it in sales table.
In the Sales table (first picture) we have button that adds new row in 2nd table where user can choose model and quantity (open row for editing option), and that information is automatically stored in Machines column (auto linked with Results Column option).
That would be perfect if we only had one type of machine per “Sales Project”, but since there can be multiple we couldn’t figure out how to setup button to keep previous link, and just add new one. Instead it adds new row but link is overwritten with newest one.
We need it to be like this (and then keep adding new ones if needed):
But the older link is always overwritten with new one, although we allowed for multiple links in linked field settings. Is there a way to configure button or some other workaround to keep previous value and add new.