-
I wasn't clear, sorry. Is there information in your form you can use to determine what rows you need from the list? Like - the user selects a department, and you know you only need rows that match that department? You aren't currently querying for all 8000 rows, are you?
-
Can you add an index to the list? I've found that on a list that exceeds the threshold, if there is an index, and if I use query fields to limit the number of rows returned, I can get past the list threshold.
-
Here's a simple sample that uses secondary data connections that are XML files in the form. Save it locally, right click and select Design to view in design mode and then you can preview, etc.
-
In your rules, try changing the first dropdown to "any occurrence":
-
So- the checkboxes have values of true and false. I think I'd add a field to the form called "Subject" and use that field for the email Subject (walk through the data connection and select the field for the formula for the subject). Then add logic to the checkbox fields to set the Subject field as needed. Make sense? For ...
-
You've put the rule on the Topic field, right? Rules only fire when the field they are on changes.
-
Okay, right click the link in the post heading, and save the file locally. Right click the saved file and select Design to open in design mode. From there you can preview, enter repeating rows, and for at least one row, set date to today and Box 1 to 0. Then click the button. There is a helper field in the repeating group that has rules and ...
-
Hey, Adam - I deleted the duplicate post. The SetValue approach you are using is actually from a third party tool (which my company created) called qRules. There is a way to do this without it, tho - I'll work up a sample here and attach it to another reply, okay?
-
Check the value for your calculated value field, under the properties. Sometimes when I copy / paste them, they lose their text or data source and then conditional formatting doesn't work (but in the case of text, the value still shows, which is SUPER WEIRD).
-
Right - in the default data you can set hard coded values in the different field instances, but can't use formulas....