Hi there,
I'm sure others have come across this. Not sure if most Workforce Admins are populating their assignments by FME or the Python API, which would easily solve this.
I want our data created in the Workforce web app interface to eventually populate a dashboard. I'm unable to add filters for the AssignmentType and WorkerID field. I think because they are GUIDs. I've also added them into a table, but they show as GUIDs, not text, which is not useful for the end user, which isn't me. Is there any easy way to change this?
Some ideas I've thought of are:
- use FME or the Python API
- create two new fields and convert the AssignmentType and WorkerIDs to text here
- create a list in these two fields with the GUID as the code and text as the label (will this mess up the project by adding in new stuff to the existing fields leading to offline area sync issues?). Upon checking there isn't a list option for these.
- in dashboard, go into the table's advanced formatting and write if or when statements to replace the GUIDs with labels
Just wondering how everyone else is getting around this, if there's best practice for this or if there's an obvious way I'm missing. I'm still working on my first Workforce project.
