-
You could also use:
substring(addSeconds(now(), -1800), 12, 5)
-
Hi All
Just thought id update it myself, i have found out a way of working it is:
concat(substring(addSeconds(now(), -1800), 12, 2), ":", substring(addSeconds(now(), -1800), 15, 2))
Thanks
-
For this section of the form, yes. There are other sections where a. will have a different value. If it makes sense, I am creating a custom control for my repeating sections so I can insert it multiple times and then apply the different rules to each section.
-
So - is this going to be static text? any time the letter is "a." it would be Area of Interest?
-
Sorry,
Here's a sample form with what I want to auto fill the first textbox in field1 with based on the expression values.a. Area of Interest.b. Area of Operations.c. Enemy Forces.d. Friendly Forces.e. Interagency, Intergovernmental, and Nongovernmental Organizations.f. Civil Considerations.g. Attachments and Detachments.h. ...
-
I have an external form library. This form library contains Purchase Orders and each of these P.O.s contain repeating tables with multiple rows.
In my new form, I allow users to select one of these purchase orders from a drop-down list. In the same form, I have another (cascading) drop-down list that is filtered by the P.O. selected in the ...
-
I must have been unclear - can you attach a sample form with what you are currently trying? Then I have something I can work from. :)
-
So I have a simple form where a user can select 3 different locations Location1, Location2, and Location3, but there is a maximum occupancy per location.
Underneath I'd like a tally of all forms that have Location1, Location2, and Location3.
So far I've only successfully queried the total count of all submitted forms, but can't ...
-
Please provide a sample, thanks. Can it be tied to the expression box so that when the value of the expression box changes the value changes with the rules?
-
Correct, I'm all set! Thanks a million.