Unlock data source

[giovanni]

I downloaded a template from the Office website (the "Time Card" one) and I
would like to see how some of the formulas have been written, but it seems I
cannot do so because the data sources are external (i.e. there is an icon of
a small lock near the data source).

Is there a way to unlock these? There are no external referenced files and I
don't understand why the locks are there. Thanks

 

[Ben Walters]

Hey Giovanni,
the locks on the Main data source indicate that the form was built from an
"XSD" schema the structure is locked to ensure the schema is not violated.

This shouldn't however prevent you from seeing any formulas behind the form.
could you post a link of where you got the template and I'll have a look at
it

Cheers
Ben Watlers

 

[giovanni]

Ben,

Thank you for your reply.

I downloaded the template from the MS Office template page
(http://office.microsoft.com/en-us/templates/TC010785231033.aspx?CategoryID=CT101172771033&av=ZIP000).
Is it possible that I cannot see the forumal because the template was created
in InfoPath 2003 and I am using 2007?

Another question: how do you save formulas with XSD schemas? Is it possible
to re-save them without the locks?

 

[Ben Walters]

Hey Giovanni,
I've had a look at the template, and I'm assuming you're trying to find the
time calculations that are used to determine the total working hours.
This is calculated using jscript not the declarative logic engine (rules).
You can access this file by Clicking File>Save as Source files, this will
save the contents of the xsn in the selected directory so you can open the
script file.

Now if you're planning to have users access this template using the browser
then you will need to rewrite this code in .net, if you are planning on
having your users access the form using the InfoPath rich client then you
can keep the Jscript file intact.

Hope this helps
Cheers
Ben Walters

 

[giovanni]

Thank you Ben, this explains everything.

Best,
Giovanni