I need help with displaying EnumList with bas...

(Aaron Moolb) #1

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?

(Grant Stead) #2

Can you copy and paste your base type qualifier text here… And does it list time table name

(Aaron Moolb) #3

@Grant_Stead {

“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

(Grant Stead) #4

@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?

(Aaron Moolb) #5

@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

(Grant Stead) #6

@Aaron_Moolb Agreed, that’s what you would have to do in your case… I assume that you’ve played with the item separator…

(Aaron Moolb) #7

@Grant_Stead I have not. Have any recommendations?

(Grant Stead) #8

@Aaron_Moolb Nope, just play with it, and make sure it’s CSV…