A spreadsheet is fed from a form which records supplier bills that are entered by users posted at project sites. The columns include (Date, bill number, supplier name, project name, amount) and a hidden (Paid?) column that takes initial value as FALSE.
Now what I want is take one or more of those bills from one supplier, sum the amount in them and take that summed amount and navigate to a company expense form with supplier name, that amount and a few more fields pre-filled.
For starters, I have created a slice with condition ([Paid?]=FALSE) and have made a table view with that slice. How I want it to proceed is that there should be provision to select multiple bills from that and sum the amounts in them and proceed to a different form.
In order to achieve that, does making a ‘table’ view help at all? I mean a ‘form’ is needed in this purpose, isn’t it? And it should be pre-filled in the columns of [supplier name], [date] and a checkbox drop-down menu to choose the bills from, by their number, if I guess correctly.
How to achieve this? Is there an easier workaround?
EDIT: I researched and realised that SELECT() expressions might be of help here. But I need proper directions on how to use select() to select values that are already there. Please help.