In my tasks view, I have three columns that reference my staff table, and these are ‘task by’ ‘assigned to’ and ‘completed by’.
I have attached images of each, for some reason. As I progress through the fields, I seem to loose an option each time. Can anyone suggest why this might be?
I shall magically intuit how your app works from nothing, and…
Nope, I got nothing.
Still trying to fix this and still no luck.
I have a table for creating tasks, within this table, I have three fields, Related Projects, Related Contacts and Task By fields, that are Enum List fields, with a Base Type set to Ref. They respectively reference my Projects, Contacts and Staff tables.
The drop down for Related Projects show 6 of almost 100 projects. The drop down for Related Contacts shows 1 of the almost 100 contacts I have. The Task By drop down displays 1 of the three entries I have in.
This almsot appears to be a bug, I have no clue as to why this could be happening. Happy to add someone with knowledge intot the app to check this out if required.
I can share something I discovered just within the last few days that may be relevant: When using an Enum (or EnumList) of Ref, AppSheet does not automatically list all existing Ref targets, as it does when using a column of type Ref directly. Instead, when using Enum (or EnumList) of Ref, you will have to use Valid If or Suggested values to produce the complete list of possible Ref values.
