Title
Moving calc definition from direct Let statement, to string in a field?
Post
I have a web viewer that I had been defining w/ calculation. It involved a let statement and a bunch of CSS, HTML and Javascript. However, I want to use this web viewer in a number of locations, so I would like to put that string for the calculation definition into a field in a table, so that I can make updates to them all at one time.
But, my initial attempts to do so aren't working. I just copied the calculation text from the WV to the text field (made one record in the other table). I made a text field in another table (unrelated), used an ESQL statement to grab it. But my web viewer is blank.
I tried using "Quote ( ExecuteSQL (...) ) ", didn't work. I tried "Let ( a=1; Quote ( ExecuteSQL (...) ) )" but that didn't work.
Any ideas?
- J
When you put the URL into a text field, the contents of that field are not being evaluated. If you have text such as:
http://forums.filemaker.com/comment/269272
in your text field, there's no expression to evaluate and you can set up the web viewer to directly reference the URL entered in the text field.
But you have an expression entered in the text field.
So you'd need to set up the calculation in the web viewer as:
Evaluate ( textfieldRefGoesHere )