Refresh calculations without opening the form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martyn Lawson - 27 Sep 2005 11:04 GMT

Hi,

I have writtien a new form based on the Absence Request sample that
calculates Bradford Score. This calculation is based on the number of
absences and amount of time off.

However, the calculation only uses the absences within the last year. The
problem then comes when the form hasn't been opened for several weeks and the
information published back to the SharePoint list is out of date.

Is there a way opening automating the opening and refreshing of data within
an infopath form?

Kind regards,
Martyn...

Reply to this Message

Jay W - 27 Sep 2005 12:42 GMT

The InfoPath SDK contains information about automating InfoPath so you could
write a program that would open the form and refresh the data. Just be aware
that if there are a large number of entries this might not perform very well.

HTH,

Jay

> Hi,
>
[quoted text clipped - 11 lines]
> Kind regards,
> Martyn...

Reply to this Message

Martyn Lawson - 27 Sep 2005 13:35 GMT

Hi Jay,

Thanks. That sounds like just what i'm after. However, i've had a quick look
in the SDK and cannot seem to find anything useful. I found information on
command line parameters to open the file, but not how to save it. Also, I
think that command lines might be a little old-hat.

Can you point me in the right direction.

Cheers,
Martyn...

> The InfoPath SDK contains information about automating InfoPath so you could
> write a program that would open the form and refresh the data. Just be aware
[quoted text clipped - 19 lines]
> > Kind regards,
> > Martyn...

Reply to this Message

Franck Dauché - 27 Sep 2005 15:05 GMT

Hi Martyn,

Have you looked at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ip2003_tr/h
tml/odc_INF_Lab_01.asp
to start?

Franck Dauché

> Hi Jay,
>
[quoted text clipped - 31 lines]
> > > Kind regards,
> > > Martyn...

Reply to this Message

Martyn Lawson - 28 Sep 2005 10:24 GMT

Thanks Franck - I now have a schedules task that loads the forms and saves
them. This is ideal.

Cheers.

> Hi Martyn,
>
[quoted text clipped - 39 lines]
> > > > Kind regards,
> > > > Martyn...

Reply to this Message

Franck Dauché - 28 Sep 2005 15:47 GMT

Hi Martyn,

I am glad that Lab 16 on External Automation could help.
If my last post was useful, don't hesitate to rate it.

Good luck with your InfoPath developments.

Franck Dauché

> Thanks Franck - I now have a schedules task that loads the forms and saves
> them. This is ideal.
[quoted text clipped - 44 lines]
> > > > > Kind regards,
> > > > > Martyn...

Reply to this Message