Having issues with something, and it must be my expressions… This is a little squirley…
I have a table DEV that is recursive in nature, and the following columns [dev_id] which is UNIQUEID() [dev_category] which is an enum [dev_image] which is REF back to DEV
the goal with [dev_image] is to get the [dev_id] for the associated image record. (long story) So, I filtered in the Valid_if which works fine=FILTER(DEV, [dev_category]=QaAfpcTD)
which gives me a good list to select from.
Now I wanted to set the initial value. This is where i’m having issues.
IF [dev_category] = QaAfpcTD THEN I want [dev_image] to initialize as [dev_id] This will create a circular reference, is that an issue? I’m using this, and nothing initializes: =IF([dev_category]=“QaAfpcTD”, [dev_id], “”)