Home      Members   Calendar   Who's On

Welcome Guest ( Login | Register )
      

Home » Skelta Workflow Net » Skelta Workflow Net » Application Development » Form Lookup Link


Form Lookup LinkExpand / Collapse
Author
Message
Posted Friday, July 17, 2009
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: Wednesday, November 24, 2010
Posts: 6, Visits: 56
I have an Payment Voucher form that will list several Invoices for payment. A user select the Vendor to Pay then selects one or many invoices from that vendor to pay and applies GL codes. Selection of the Invoice fills in the Amount and PO fields Please see attached screen shot of the form.

I would like to create a hyperlink in each row of the grid for the invoice to call and external web program. The link would be the string addition of a fixed URL with the Purchase Order number at the end. Such as http://ImageView/PONumber=1111.

I can create this using a text field value but not a hyperlink field value. A text field shows the proper combined URL. I used the same type of script that fills in the PO and Amount fields to create the URL. The hyperlink value update produces a script error.

This is the psudocode I use on the Invoice Data changed script.

Control.FindRelatedRecordControlById /*Link*/'2aa0802263684467be4655098023b44d').Value =Control.FindRelatedRecordControlById /*URL*/'2aa0802263684467be4655098023b44d').Value + Control.ExtendedInformation.FindByDBColumn('APInvLookup','PO').Value;

How can I do this?

Thanks;

Rich Jones

  

Rich Jones (EMC)

Post #1457
Posted Monday, July 20, 2009
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, January 07, 2010
Posts: 17, Visits: 36
Jones,

Will check this and let you know at the earliest.

-Chitta

Post #1461
Posted Wednesday, July 22, 2009
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: Wednesday, November 24, 2010
Posts: 6, Visits: 56
Thank you for the assistance.

Any update on this yet?

Thanks;

Rich Jones (EMC)

Post #1470
Posted Wednesday, July 22, 2009
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Thursday, February 10, 2011
Posts: 28, Visits: 47
Hi Jones,

We are co-ordinating with our engineering team on this and will update you at the earliest.

 

Regards

Saravanan

Post #1471
Posted Thursday, July 23, 2009
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Monday, December 21, 2009
Posts: 102, Visits: 124
Hi Rich,

1.  Verify Mapped XML Node is available for the hyperlink control. 

2.  Also send us the Form exported information (Export your form as an xml file) in order to analyze the issue.

Note: Btw, if you are collecting/gethering information from the lookup control, please ensure that it's selected before the hyperlink is clicked.

Thanks, Sri

Srinivasa Rao Pentapati

Post #1473
Posted Thursday, July 23, 2009
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: Wednesday, November 24, 2010
Posts: 6, Visits: 56
Ok, the selection is the problem. It works if I first lookup the GL code. At that point it commits the Total calculation and then enables the proper hyperlink URL.

I have seen that on other forms also where there are calculations in script and they do not commit until the submit button is selected.

How do I select the hyperlink in order for it to update properly, other than adding another control like the GLcode looup?

Rich Jones (EMC)

Post #1476
Posted Friday, July 24, 2009
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Monday, December 21, 2009
Posts: 102, Visits: 124
Hey, that's great!

Regarding the follow-up query,  Submit button can be customized…. You can create a button of type custom and in the click script property , write the calculation logic, and on the fly change the behavior from Custom to Submit…

Sample script code in click script :-

 /*

Calculate and update total logic to come here.

*/

CurrentBehaviour = ‘Submit’;

 

Thanks, Sri

Srinivasa Rao Pentapati

Post #1478
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
-
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.

All times are GMT -5:00, Time now is 10:03am

 
Execution: 0.156.10 queries.Compression Enabled.

Copyright © 2002 - 2009 Skelta Software. All rights reserved. Tel: 1 (678) 306 4110 | Email:sales@skelta.com
Skelta - A BPM Workflow Software Company