Newbie Questions

Re: Filling day names in textbox

Alec Pojidaev — Sun, 01 Mar 2009 01:07:57 GMT

Raajkumar:

Hi,

It is working fine but this is like hard coding the date. Is there any way to automate the dates for all the months in a year just like date picker property.

Because the user may want to select a different month and year so in that what could be done?

Check my article about date calculations.

http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

Re: Filling day names in textbox

Raajkumar — Thu, 08 Jan 2009 04:44:16 GMT

Hi,

It is working fine but this is like hard coding the date. Is there any way to automate the dates for all the months in a year just like date picker property.

Because the user may want to select a different month and year so in that what could be done?

Re: Filling day names in textbox

swathip — Wed, 07 Jan 2009 13:25:17 GMT

Hi,

If you want the day names to be displayed in the different text boxes then use the following xml.

<Weeks>

</Week>

</Week>

</Week>

</Weeks>

Save the above as Weeks.xml.

Now take a receive data connection to retrieve the values.

Go to drop down properties.

1. Select Look up data from an external data source.

2. Select the weeks data source.

3. In the entries box, select number.

4. Click Rules button.

5. Click add button. Then click add action button.

6. Select set a field's value in the action drop down.

7. Select first day text box field in the field.

8. Click fx button beside the value.

9. Then select dayName in the weeks data source then click filter data.

10. Click Add and select number from weeks data source in the first drop down, is equal to in the second drop down and the drop down field in the third drop down.

11. Click ok. In the Insert formula window click Edit Xpath check box. There change the Day/ with Day[1]/.

12. Then click ok until all the windows gets closed. The expression will look like

xdXDocument:GetDOM("weeks")/Weeks/Week/Day[1]/@dayName[../../@number = xdXDocument:get-DOM()/my:myFields/my:field4]

13. Do the same for other text boxes (add another add action to set the second text box value. The only change is add day[2] instead of Day[1]. For third text box Day[3])

14. Do the same for date (Repeat step 4 to step 13).

Re: Filling day names in textbox

Raajkumar — Wed, 07 Jan 2009 11:54:20 GMT

Hi,

Yes i want to auto populate the day name.

how can i do that without using any code behind

Re: Filling day names in textbox

Raajkumar — Wed, 07 Jan 2009 11:27:40 GMT

I tried but the problem is like all the day names are getting populated in a single text box itself

so is there any way to filter it to display only one day name per textbox

Re: Filling day names in textbox

swathip — Wed, 07 Jan 2009 10:57:24 GMT

Hi,

You said that you are using a drop down list for week names. Specify the rule for that drop down.

Re: Filling day names in textbox

Raajkumar — Wed, 07 Jan 2009 10:40:40 GMT

Hi,

First of all i need to thank you.

Could you please explain me more clearly beacause i am new to Infopath.

so from which drop down list i need to have the specified rule?

Re: Filling day names in textbox

swathip — Tue, 06 Jan 2009 12:53:06 GMT

Hi,

If you are hard coding the values then just place the week name and the date and day values in the xml as shown below.

<Weeks>

</Week>

</Week>

</Week>

</Weeks>

Save the above as Weeks.xml.

Now take a receive data connection to retrieve the values.

Go to drop down properties.

1.    Select Look up data from an external data source.

2.    Select the weeks data source.

3.    In the entries box, select number.

4.    Click Rules button.

5.    Click add button. Then click add action button.

6.    Select set a field's value in the action drop down.

7.    Select day text box field in the field.

8.    Click fx button beside the value.

9.    Then select dayName in the weeks data source then click filter data.

10. Click  Add and select number from weeks data source in the first drop down, is equal to in the second drop down and the drop down field in the third drop down.

11. Click ok until all the windows gets close.

12. Do the same for date (Repeat step 4 to step 11).

Re: Filling day names in textbox

Raajkumar — Tue, 06 Jan 2009 06:04:05 GMT

Yes, it is like the timesheet should be filled on weekly basis. So i need to associate the dates and daynames properly such that one textbox will have dayname and other will have date.

My timesheet will look similar to this,

29 30 31 01 02 03 04

Monday Tuesday Wednesday Thursday Friday Saturday Sunday

here i am hardcoding the day names and the dates of the week should be populated.

Re: Filling day names in textbox

Anuma — Tue, 06 Jan 2009 05:41:35 GMT

Do you want to autopopulate the day name in Text box or is that value coming from any xml?

Re: Filling day names in textbox

swathip — Tue, 06 Jan 2009 05:36:23 GMT

Hi,Do you want to display all the day names? If so, just add a rule to the drop down to set the day names in the text box.If the day names are different for each week then prepare an xml and using a rule by filtering the value in the drop down you can populate the value in text box.

Filling day names in textbox

Raajkumar — Tue, 06 Jan 2009 04:56:49 GMT

Hi,

I am creating a timesheet infopath form in which the day names should be shown atomatically without using code behind.

There is an dropdown list which will have values like, Firstweek,secondweek... and based upon that those day names should be display

Please help me