Table view - show placeholder values for group aggregate as '0'

[Tom_uncoded]

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.

[TeeSee1]

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.