Newbie Questions

Re: using check box to automatically input text

fallaway — Mon, 29 Dec 2008 20:23:42 GMT

Thanks for the quick reply - and darn, so much for that nice easy solution. Is there another way to pull a user's name? I want to record the user and date/time when they check a box, and this would be for about 6 check boxes, each potentially with a different user checking them.

The list of functions is quite limited!

Re: using check box to automatically input text

warrtalon — Mon, 29 Dec 2008 20:14:42 GMT

Yes, that is not a function in IP2003. Also, it's userName() (in IP2007). Instead of typing things out manually, it's best to choose the function in the wizard so that you don't make any syntax mistakes at least until you master it.

Re: using check box to automatically input text

fallaway — Mon, 29 Dec 2008 19:00:53 GMT

When I try those formulas, I get the error:

---

'username' is not a valid XSLT or XPath function.

concat(substring-after(xdDate:Now(), "T"), " ", xdDate:Today(), -->username()<--)

---

Is this because I'm using InfoPath 2003? TIA!

Re: using check box to automatically input text

bill_fmi — Wed, 03 Dec 2008 16:28:42 GMT

Thanks for the help and info, we decided not to go with this option.

Re: using check box to automatically input text

jrudolph — Tue, 02 Dec 2008 20:02:48 GMT

On the first part of your question. I dont think this can be done without using managed code or without creating a ton of rules that have different combinations of the items you want displayed.

Another option since you are using a "Read Only" text box anyways is to create a "section" and make the border of the section be a thin line, to emulate what a rich text box would look like. Then create 10 Text boxes with the default values set to what you desire inside of them. This method might allow you to add the bullet with some formatting. Then make it so that the text boxes are hidden unless the check mark is = True, using conditional formating. This method is probably better only if you are not extracting the data for use else where.

I may be wrong and would like to know if anyone else has a better way of doing it myself.

Hope this helps.

Re: using check box to automatically input text

bill_fmi — Tue, 02 Dec 2008 18:28:17 GMT

its always the darn cat; I thought something looked amiss, that is working, thank you! next question is There are about 10 Check boxes is there formula to add to what we have now so that it will start a new line in the Rich Text Box,

Also and less important than the above is there a way to make the text box default to using bullets?

Re: using check box to automatically input text

Hilary Stoupa — Tue, 02 Dec 2008 18:09:53 GMT

You are missing the concat:

concat(substring-after(now(), "T"), " ", userName(), DAY_TEXT_1.0)

Re: using check box to automatically input text

bill_fmi — Tue, 02 Dec 2008 17:59:47 GMT

Here is what I am trying to use but I know I am doing something wrong with the syntax. Sorry I am just learning all of this.

substring-after(now(), "T"), " ", userName(), DAY_TEXT_1.0

What I am wanting to see is when a user checks the box I get Time (MILITARY) Username What ever was in the text box that they checked. We I trying to ad some you uniformity and accountability to our NOC and this will be a Daily Turnover & Duties log

Re: using check box to automatically input text

jrudolph — Tue, 02 Dec 2008 17:40:26 GMT

Yes this is true, thanks Anuma.

Also remember as Anuma has displayed above, feel free to use " " or " _ " or any variation similar to Excel formuals to seperate the fields as much as you want.

Re: using check box to automatically input text

Anuma — Tue, 02 Dec 2008 17:33:23 GMT

Hi,

If we add the Now() and Today() functions, then date will be displayed two times.

Try this.

concat(now(), " ", userName())

concat(substring-after(now(), "T"), today(), userName())

Re: using check box to automatically input text

jrudolph — Tue, 02 Dec 2008 16:09:24 GMT

Use a rule on the check box that is triggered by the check.

Ex: When Check Box Condition = True

Add Action:

Set Rich Text Box Default Field Value to " concat(now(), today(), userName()) " format accordingly.

Hope this helps.

using check box to automatically input text

bill_fmi — Tue, 02 Dec 2008 15:20:37 GMT

I am wondering if there is a way that once a user selects a check box, I can have the data it is representing input with a time/date/username stamp in the rich text box that is read only?