Jump to content

UPDATE validate portal field by calc NOT


s_t_e_v_e

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

Recommended Posts

  • Newbies

Hello

Here is some new info from 1 day of trial and error and 2 min FM tech support (I wish they did weekends!):

I am trying to validate a portal field using a calculation that sums the value of same field over the number of records created in the portal (using a self-join relationship). SPecifically, I enter a percent in each record, and the sum of all the percents must be 100. The calculation doesn't occur until after the portal record changed or portal exited, so validation doesn't occur properly.

FM says only by using a script (hence, an uwieldy button) can I get this to work. I found another ugly workaround: I validate from another portal on the same layout. It's a bit confusing to user, being prompted to revert or change the value of a field that is not the field being validated, but still better than a button, since most of the time 1 single portal record will be created and it defaults to 100.

I have, and I encourage anyone out there to submit a request to FM to allow scripts to be run in a calculation (just like all those other functions in there).

Barring that, I have heard of the Events plugin from Waves in Motion, which lets you trigger a script on exiting a field. May relent and buy in the future once this solution is installed.

Thanks,

Steve B.

Link to comment
Share on other sites

Barring that, I have heard of the Events plugin from Waves in Motion, which lets you trigger a script on exiting a field. May relent and buy in the future once this solution is installed.

Look at the attached file (URL to its source is dead)

Link to comment
Share on other sites

This topic is 7592 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.