Using a certain ritual of of button clicks in FileMaker Pro 7.0v1 schema, you were able to create unstored calculation that were equally global. It makes me think about global unstored calculations a few years ago. I don’t want to spoil the fun here, but unfortunately it’s not documented by FileMaker, and you even get a warning dialog that this will not work *read: is not supposed to work*. Quite easy to setup and lots of applications. I just created the bare bones version for myself to find out when exactly this “feature” becomes available. However, the value list grabs the first value then comes back for the second value, so what I get is this: This properly splits the field calculation into two lines. Substitute ( GetValue ( $$value Get ( RecordNumber ) ) “,” ¶ ) Then, when defining the field I’ve tried this In my ExecuteSQL() I’m using the default separator of the comma to separate the name and address. However, I’m curious if I can display the info in multiple lines. I know I can show multiple pieces of information on one line: Clicking on the name goes to a list view of all those people with the same name and has more info to help the user differentiate the results. Currently, if I have two people with the same name it shows up once in the value list, as expected. What I’m trying to accomplish is search for people. Is it possible to have multiple lines inside each value? For instance, I’d like to return a name and address as follows:
#HOW TO REFRESH A SUMMARY FIELD IN FILEMAKER PRO 6 HOW TO#
I have a Demo file.But I don’t know how to post it. To show the value list are available.We can use radiobuttons,checkboxes,dropdown list,accordion panel,etc….įrom Filemaker 12 we can use fmp:// technique.Now webviewer is interactive.There are great possibilities in the Filemaker – Webviewer interaction,I believe. We can use a webviewer as a selection tool.Pass the resultset of ExecuteSQL function to the webviewer.In the webviewer,many techniques of the web Using conditional formatting,you can turn on/off check mark. Prepare 2 repetitive fields.one for the value to show,and another for the mark “check”.Then put one over another in the layout mode. To point out the selected item,you just turn the color of the text or background by using conditional formatting. So this technique comes from that.I wrote “Make the repetitive field seem like checkboxes or radio buttons…”,but you don’t have to do it necessarily. There are so many variation of the value selection style in the world of the web.I think Filemaker also should have the ways to do that. GetValue($$resultset Get(CalculationRepetitionNumber)) If you use the ExecuteSQL function in the onlayoutEnter trigger script and put the resultset into the global variable($$resultset),it works faster.(maybe…)
I use WHERE clause to filter the items to show in the ExecuteSQL function #1 how to restrict the members of the value list to show Tagged Conditional Value List, Filtered Value List, Value List So it turns out that it isn’t “impossible” after all, and since I was at DevCon I took the opportunity to ask one of the FileMaker engineers about this behavior, and he assured me that while the behavior is undocumented, it “works as expected” and is not likely to go away any time soon.Īnd since Andries was in the audience during the session, and since he had a long flight home to Belgium a few days later, he was able to put together the MagicValueList demo, and suggested that FileMakerHacks might be a good place to showcase it.Īndries has done a superb job of explaining the intricacies of this technique, so really there isn’t much else for me to say except thank you to both Andries for the demo, and to John Ahn for the revelation that what most of us thought was impossible… isn’t. Here’s a value list definition from John’s demo:Īnd here’s the field the value list is based on: