Hi,
My goal is to have the count of the Placeholder state ABC and Placeholder state XYZ as 0 instead of 1.
I require this as users select an item from this table view then create a new record under that group, prefilling the 'State' field with their selection on a form view. It's useful to show the two empty groups as it indicates to the user they're available for selection when creating a new form.
I have a Table view that has group by and group aggregate (COUNT) configurations.
In my datasource, for the time being, I just have manually created the two placeholder records to display within the table view.
Note: this is just a sandpit app I've used to reproduce my issue.
Any help or suggested workarounds appreciated, thanks.
Thanks.
An idea...
Create a table with two columns - [state] and [record_count].
You show in [record_count] the count of the records you have created in the 'real' table.
Create an action using LINKTOFORM to navigate the user to the FORM related to the "real" table with [State] (and whatever else) prefilled and fire it on the select row event of the table view of this newly created table.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |