Hi all!
This is really annoying as it is a simple task, and yet I am not getting Appsheet to fill anything in. There are 3 tables in question:
Tasks - Represents a job for a client, and I want to pull the icon of the main task service (if multiple)
Task Services - Joins a Service to a Job, and pulls icon from Services, and has a boolean if row is the Main Service of that task
Services - Listing of all available services, with a Service Icon
Task Services correctly pulls the icon using [Service].[Icon], but when I try to use Lookups or Selects from the Tasks table, it doesn't pull anything. This is what I have tried:
ANY(SELECT(Task Services[Icon], AND([Task ID] = [_THISROW].[Task ID], [Main Service?] = TRUE))
Any thoughts as to what I am missing here?
LinkedIn
Twitter
