Tony Diaz 0 Posted July 4, 2020 Share Posted July 4, 2020 (edited) 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 Link to post Share on other sites
comment 1,777 Posted July 4, 2020 Share Posted July 4, 2020 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. Link to post Share on other sites
Tony Diaz 0 Posted July 4, 2020 Author Share Posted July 4, 2020 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 Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now