Share
Report
65Hey all,
I realize I've probably made a boo boo building this app and not using a choices column for the options, but in the form the data wouldn't display nicely, it was just a solo sentence of the choices and not very user friendly.
So instead I put a dropdown in the app and then set the Update value to '"Concat(ComboBox3.SelectedItems,Value&"<br>")" so that it would add to the theme column in a nice order and on the view screen show the data in a list format instead of a solo string.
This leads me onto my next issue, I am now trying to report on the column, we will call it Options. The drop down in the app has 19 different choices in the drop down, multi select is also on.
After some thinking I decided for the reporting I would use CountIf to search the column for each possible option, like such (any improvements greatly appreciated as it is a bit long for each option!):
"Option 01: " & CountIf('Visit Details', Find("Option01", 'Options v2') > 0 And Created >= DatePicker2.SelectedDate And Created <=DatePicker2_1.SelectedDate) & Char(10) &
"Option 02: " & CountIf('Visit Details', Find("Option02", 'Options v2') > 0 And Created >= DatePicker2.SelectedDate And Created <=DatePicker2_1.SelectedDate) & Char(10) &
"Option 03: " & CountIf('Visit Details', Find("Option03", 'Options v2') > 0 And Created >= DatePicker2.SelectedDate And Created <=DatePicker2_1.SelectedDate) & Char(10)
Once I figured CountIf would give me what I need, I added two date pickers so you can filter the data between two dates, however I am noticing that the CountIf will not return entries for todays date?
For example I have an entry from yesterday (22/06) for Theme01 and if I set the from date as 20/06/2021 and the to date as 22/06/2021 it wont return the result, however if the date is set to 23/06/2021 it will show.
I did want to have this data fire in a monthly report but it seems I can't achieve that as when I try do a select from the data in flow it just returns it all in HTML.
Any help as always is much appreciated.
All responses (
Answers (
