Filtering - Forums

he

healyhatman 18 Apr, 2018

Answer

I have a CCv6 connection showing all the time sheets entered by my workers. I want to be able to click on a worker's name to show just the timesheets for that user. Same for the client - click to filter by them.

By default, all entries should be shown.

EDIT: never mind.

Column view: user.name:{view:filter_by_worker}
filter_by_worker: Content-> {var:timesheets_list.row.user.name} URL -> worker={var:timesheets_list.row.timesheet.user_id}

Read data:
timesheet.user_id:{data:worker}/-
timesheet.client_name:{data:client}/-

the /- after means skip the condition if empty.

st

stikkimorey 19 Aug, 2018

That works really well Thanks.

All the available assets are now coming into the repeater area and I have a book it button on the repeater, but the value from that row is not going into the datbase. what do I put in the value box of the button so that it knows how to save the asset_id from that particular row.

I tried {var:area_repeater69.key.row} and {var:area_repeater69.key.row} but this is not working.

he

healyhatman 19 Aug, 2018

look at your debug. Make sure you named the fields correctly

he

healyhatman 19 Aug, 2018

Are you talking about a CC TABLE or about a CF REPEATER AREA?