-
I see. May I know how you are specifying which document to update? or is this already fixed by setting each submit to a File Name - where File Name is equivalent to the previous month? If so, you may use the formula:
substring(addDays(today(), -30), 1, 7)
-
The substring function returns a specific part of a text string. The first argument defines the text string, the second argument defines the starting position, and the third argument defines how many characters to include.
So if the function today() returns a value of 2014-02-04, the value for substring(today(), 0,8) now will be:
2014-02
Where ...
-
Hi jjsmith,
If you are working with InfoPath Filler Forms, you can make use of a Scrolling Region. This control works like a section, except that they are not compatible with web browser forms. If it's not found at the controls section, you would need to convert your form at the Form Option to an InfoPath Filler Form type.
-
Hi DaveThomas,
I'm not sure if this is possible with InfoPath alone, fortunately, I found a blog post on How to Enqueue Submits While Offline. I haven't tested this approach yet but I'm hoping that I'm pointing you toward the right direction here. Hope this helps.
-
Hi venkatkbv,
Here is a link for basic formulas which can help you get started. For the IF related calculations, you can make use of conditional rules which you will find on the Rules task pane if you click on the Manage Rules button under the Home tab. So instead of using a default value calculation, you can add an action rule that will set a ...
-
Hi ichfopath,
This is probably happening because the drop-down list uses an internal value for the Value and a different display name. Would it be possible for you to add a Lookup column to SharePoint? This should display the matching Display Name to the internal value. Hope this helps.
-
Hi Barry,
Yes, this is possible. You can make use of qRules' ClearErrors command which allows you to clear the error table in order to allow submit even if some fields are not valid. Pease check this blog post for more information. Hope this helps.
-
Hi zaca011,
If you are using today() in your formula, then it would return the date today. What you may need to do here is to substitute today() with a field where it will specify the file name of which ever document you wish to update. Your formula should look similar to this:
substring(field1, 0, 8)
I suggest using another control such as a ...
-
Hello,
There was a previous reply by Jo-Anne which discussed filtering and querying secondary data connections in detail. Let me know if it works out well or if you need further assistance. Hope this helps.
-
Hi rlntel,
You may use a count(row) formula for counting the number of existing rows (where row is the repeating group). As for the additional control, could you explain it a bit further? Or simply attach a copy of your form so I could get a clearer idea.