Jump to content

Runtime Problem - Calc Field with Value Lists


This topic is 7476 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello everyone,

I've created a runtime solution with FM Developer. Everything is fine except for one field, and this problem is consistent between platforms.

The field is a calculated text field, which uses the ValueListItems function on a value list that is populated by a relationship.

In FMP, the text field is properly displayed on the layout (as a merge field), but does not appear on the layout in the runtime solution.

Any ideas would be tremendously appreciated. Thanks!

Link to comment
Share on other sites

Is the related database that populates the value list part of the runtime?

Did you set password permissions in the runtime? I got in trouble with one of mine by not being careful about which fields and layouts to give the user access to. It's not just the user that needs the access, it is also scripts and calculations.

Steve Brown

Link to comment
Share on other sites

Hello Girwin,

The ValueListItems( ) function requires two parameters, one of which is the name of the file in which the value list resides.

The most likely reason that the calculation does not work in the runtime version is that the names of the files have been changed at the time of binding (eg the extension was .fp5 but is now something else...).

If the calculation field is in the same file as the value list, then the simplest solution to this is to supply the filename dynamically, using a status function, rather than specifying it as a literal value - viz:

ValueListItems(Status(CurrentFileName), "YourListName")

- rather than ValueListItems("YourFile.fp5", "YourListName") etc. wink.gif

Link to comment
Share on other sites

Thank you both for replying. My headache is over!

It turns out that, as Cobalt suggested, I had removed the extensions and therefore changed the filename during binding. Your suggestion of calculating the filename dynamically works like a charm.

Thanks again!

Link to comment
Share on other sites

This topic is 7476 days old. Please don't post here. Open a new topic instead.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.