Value List Based on Field Content Calculation?

[Tony Diaz 0]

I'm trying to make a value based on the content of JSON_cListKeys in this specific record only:

The fields involved:

 

 

I get the "This Value List Won't Work... based on a calculation" message. So I tried to see if looking up the content or calculating the content and using that instead.. um.. no, it's still a calculation.

 

I Tried changing to a calculated text field ... I get no error from the value list creator, but I still don't get actual values in the list.

In order to only get the values from the current record, I created a self join [Items <--> Items_Current_Record] and linked it to itself by the unique ID, and I also tried the JSON_cListValues field for the pair as well. (At the bottom of the screenshot)

 

 

I've found a similar thread but the data it's working with is numbers and increments. It's building that list by multiplication of intervals.

I have a feeling I need to either do something to actually get the $result of the calculation to be text.
The self join, if I understand it right, should limit my results to just that one record at least.

 

Sandbox.fmp12

 

 

Sandbox.fmp12.zip Sandbox.fmp12

Edited July 4, 2020 by Tony Diaz

[comment 1,777]

Your basic premise is flawed. The error message you see does NOT say anything about calculation. It says that the field cannot be indexed. It cannot be indexed, because the calculation is unstored.

If you want your value list to show values from the current record only, then define it to use values from the Items_CurrentRecord::JSON_cListKeys0 field, show only related values starting from Items. And you can get rid of the JSON_cListKeys_Values0 field, it serves no purpose that I can see.

 

[Tony Diaz 0]

Hmmm...  that JSON_cListKeys_Values0 field was because for whatever reason, I kept getting that same error message when I was trying to define the value list, so I thought maybe that it was trying to parse the formula calculation text itself, and not the result.

 

I had the right thought then, at least. The values on the self join table only and the field content is the calculation result. I must have been selecting something wrong in the beginning, before I added that .._Values0 field. 'cause, yes, it's doing nothing.

It's working now. Whatever?!?! I swear this is what I was doing before and getting that error.

...at least that was what I was thinking needed to be done, obviously I must have been picking something else.
Ugh.

Thanks