Get the selected record number from an Editable Grid View

Scriptcase 9 General
#1

I have two Form applications:

  1. An Edit form which shows the details of a single record.
  2. An Editable Grid View form that shows all of the records.

I selected Editable Grid View as it provides some additional formatting and behavior that I do not get in Grid applications.

I have a button on the Edit form that opens the Editable Grid View form that shows all of the records from the table. What I want to do is to have a link field or button shown for each record that when clicked will re-load the Edit form with the selected record from the Editable Grid View.

How do I get the selected record (number) from the Editable Grid View? Thank you in advance for the assistance.

#2

By record number, do you mean the primary key in the table definition?

#3

Hello lewis200,

Let me dive deeper into this. The records when shown show their ‘Sequence’ number (Record Number), name and a description in the view. I want to be able to return the ‘Sequence’ number when I click on either an HTML image field (that I add for each record or via the URL field I click on.

Here are two possible ways I could use to get the ‘Sequence’ (Record Number) that I have tried. I am still playing around with these.

When I use ‘URL’ for the ‘Sequence’ field I do see the underscore link and get an error indicating that the URL is not found. So I need to build the URL but where exactly? In ‘onRecordLoad’?

When I add a field to the view as an ‘HTML Image’ I can specify a target, but the problem is that I can’t seam to use an Ajax events to get the correct record number ‘Sequence’. I always seam to get the number ‘1’. So with this method how would I get the ‘Sequence’ value to provide in the Application Link?

#4

In a grid sc_seq_register will do the work, but I am not sure that it will work in an editable grid view

You can create a counter yourself

onScriptInit
[curRow] = 0;

onRecordLoad
[curRow] += 1;
1 Like
#5

Got it! Thank you very much!