I need help with displaying EnumList with base type as Ref
I have a field set as EnumList which pulls from
a referenced table so the base type on this EnumList is Ref. This works great in the Form View, however, when I save the form, it displays the keys of the referenced table.
Is there a way to display the Label of the referenced table as it does in the Form View?
Can you copy and paste your base type qualifier text hereโฆ And does it list time table name
โReferencedTableNameโ: โApostlesโ,
โIsAPartOfโ: false,
โReferencedTypeโ: โTextโ,
โReferencedTypeQualifierโ: "{\r\n
โMaxLengthโ: null,\r\n
โMinLengthโ: null,\r\n
โIsMulticolumnKeyโ: false,\r\n
โValid_Ifโ: โโ,\r\n
โShow_Ifโ: โโ,\r\n
โRequired_Ifโ: โโ,\r\n
โEditable_Ifโ: โโ\r\n}",
โReferencedKeyColumnโ: โApostle IDโ,
โRelationshipNameโ: null,
โInputModeโ: โAutoโ,
โValid_Ifโ: null,
โShow_Ifโ: null,
โRequired_Ifโ: null,
โEditable_Ifโ: null}
I dont have a time table
@Aaron_Moolb Everything looks right there. When mine are set-up like that it shows the labels, as CSV, a little wonky looking but acceptableโฆ
@praveen Do you have any ideas?
@Grant_Stead Here is what I did as a work around. Like I said, the form view is awesome. Its the detail and table views that stink. So, I set up a VC that says =SELECT(Apostles[Apostle ID],IN([Apostle ID],[_THISROW].[Saturday Morning Session Apostle ID]))
This takes the Keys of the comma delimited field in the detail view and turns it into a list that is friendly.
I then set up my column structure to not show the real column but rather the VC with friendly views.
Its goofy this way but works.I was just hoping for an easier fix in the UX or something
Not exactly sure what the problem is here on this thread.
Enum or Enumlist with base type REF is always save the key value of the referenced row, meaning it is default behaivor of Appsheet. There is no workaround to save the filed value which is set as label.
If you want to save the label value to the spreadsheet, then you make the label value as Key of that table.
@Aaron_Moolb Agreed, thatโs what you would have to do in your caseโฆ I assume that youโve played with the item separatorโฆ
@Grant_Stead I have not. Have any recommendations?
@Aaron_Moolb Nope, just play with it, and make sure itโs CSVโฆ
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |