I'm still working with the scenario from my last post, but with a different problem. Here's the scenario this time:
I have a 'listitem' table with two rowlink fields: one linked to the 'list' table and one linked to the 'item' table. I'm working on a screen that creates rows in the listitem table - adding a predefined item to a working list.
My screen has a screen-level variable that holds the id of the list that I'm working with. There's a 'List' section of the screen that has rows for each candidate item. There's a button on each row that allows the user to select a specific item and create a listitem row that links that item to the working list.
All of that works just fine at this point. Here's the problem: When a user adds an item to a list, they should also be able to specify a quantity (among, perhaps, other things). The quantity has to go in the listitem table. However, the 'List' portion of the screen is displaying rows from the item table instead. I need to have a 'quantity' field that the user can edit, and it should be in each row of the list on the screen. I've attached a screenshot showing what I think it should look like. The problem is that Honeycode does not allow variables in list sections - only columns from the table being listed.
Any suggestions?