General

Re: Is it possible to update the year on a form in the title of the form automatically?

luke20 — Thu, 15 Nov 2012 15:12:57 GMT

thank you, this helps alot :)

Re: Is it possible to update the year on a form in the title of the form automatically?

Hilary Stoupa — Wed, 14 Nov 2012 20:34:21 GMT

Here's a simple sample form that uses a rule on form load to set a field to the label values based on the date the template is opened - change your system date to check the returned value before or after 8-31. This should at least give you a few ideas. You'll want to save the form linked in the heading of this post locally. Then right click it and select Design. From there, you can preview, look at the form load rules, etc.

Re: Is it possible to update the year on a form in the title of the form automatically?

luke20 — Wed, 14 Nov 2012 16:11:59 GMT

Oh sorry, the date should change on the 31st of August every year. so for example, from now it should say 2012/ 2013, next year on the 31st august it should change to 2013/ 2014 and so on

Re: Is it possible to update the year on a form in the title of the form automatically?

Hilary Stoupa — Wed, 14 Nov 2012 16:01:13 GMT

Yes, I understand that - what I'm asking is what should the logic be? When should the label say 2012/2013? At what point should it change to 2013/2014? Does that make sense?

Re: Is it possible to update the year on a form in the title of the form automatically?

luke20 — Wed, 14 Nov 2012 15:39:44 GMT

at the moment its just a label that does nothing, a label with the default value set to 2012/ 2013

Re: Is it possible to update the year on a form in the title of the form automatically?

Hilary Stoupa — Wed, 14 Nov 2012 15:29:21 GMT

You should be able to use a calculated value for this - what is the logic that determines the date range?

Re: Is it possible to update the year on a form in the title of the form automatically?

luke20 — Wed, 14 Nov 2012 15:19:40 GMT

Hi, attached a snapshot of it - its the title within the actual form

thanks

luke

Re: Is it possible to update the year on a form in the title of the form automatically?

Hilary Stoupa — Wed, 14 Nov 2012 14:54:30 GMT

I'm wondering if you mean the title bar of InfoPath itself (the caption)? Or some displayed info in your form? Can you attach a screenshot under the Options tab in a reply?

Re: Is it possible to update the year on a form in the title of the form automatically?

luke20 — Wed, 14 Nov 2012 14:02:01 GMT

Thank you Patrick

Re: Is it possible to update the year on a form in the title of the form automatically?

Patrick Halstead — Wed, 14 Nov 2012 13:28:31 GMT

Hi Luke,

You can update the form's title automatically using qRules. Check out Qdabra.com and look at qRules under Tools and Templates.

Best,

Is it possible to update the year on a form in the title of the form automatically?

luke20 — Wed, 14 Nov 2012 13:03:26 GMT

in my form i have the accademic year at the top and this needs to update each year (eg from 2012/2013 to 2013/2014 or maybe 2013 to 2014 to 2015) is this possible to do in anyway? i dont want to have to keep going to the form template each year and updating it - not only this but then i think it will also update the years/dates in the forms that are already submitted.

thanks