I have a form with 77 triggers . . .

Forums Classic DFFS I have a form with 77 triggers . . .

Viewing 1 reply thread
  • Author
    Posts
    • #9127
      chgrnet
      Participant

      It also has vLookup and tabs, are there any tips to speed up the load time? I know vLookup does affect it when there are more items, but if there are any tips and tricks to follow to streamline, I would greatly appreciate that information.

    • #9130
      Alexander Bautz
      Keymaster

      Hi,
      When you have this many rules, you should use the “No reversing of this rule” for any rules you don’n want to “reverse” if they do not match. Use the “Stop if this rule = true” and maybe the “and jump to” to skip rules that does not have to be validated.

      If you don’t use these options, all 77 rules will be evaluated when you load the form.

      Also you should put vLookups in separate tabs to prevent them from loading when the form loads. If you do this, the vLookup will only be loaded if you click the tab containing the vLookup.

      Hope this helps,
      Alexander

Viewing 1 reply thread
  • You must be logged in to reply to this topic.