Row make clickable to redirect

Applications Grid / Reports
#1

Hi,

Is there a way in scriptcase that each row(grid) in a table is clickable that will redirect to different applications.

Thanks
ishey

#2

Re: Row make clickable to redirect

Dear Ishey,

Yes you can using macro sc_link.

http://www.scriptcase.net/scriptcase4_en_us/doc/manual_mp/80-Apendice/08-Programacao/01-Macro_sc/00-macros_sc.htm#sc_link

to make all row click-able, you need use this macro to all column.

Regards,
Jos? Arteiro Teixeira Cavalcanti.
Support Netmake.

#3

Re: Row make clickable to redirect

As mentioned, you can use the sc_link, but for each link in each row to a different app, you will have to setup a condition in the OnRecord event
based on a KEY value

If ({key_value} == myvalue) {sc_link(…)}
elseif (…)

Regards,
Scott.

#4

Re: Row make clickable to redirect

Hi,

Thanks for replying… I have 2 other questions anyway…

  1. What would be the value of my key?

  2. How do I get the current row number being pointed to by the mouse pointer in my grid?

Thanks a lot!
ishey

#5

Re: Row make clickable to redirect

The value of your key would be a unique/primary value in the table for each record.

If you have a unique key in your table, and you should (create one if you do not), then you really do not need a row number.

Regards,
Scott.

#6

Re: Row make clickable to redirect

The onRecord event will get the clicked row.

V?tor Jamil

#7

Re: Row make clickable to redirect

Thanks…

but what if the link is calling only 1 form…but with different primary keys?..

I already tried it, yet it’s only getting the first row

thanks
ishey

#8

Re: Row make clickable to redirect

I think you should use “Links>>New Link” option. Then select an Application link or Field link.

#9

Re: Row make clickable to redirect

Hi,

In sc_link the parameters i am getting it from tables.

I could able to Redirect Dynmically using sc_link.but i have another constraint while passing the parameter
I have formname and parameters in the database table.Let us say
$pagename =dataset[0][0];
$param = dataset[0][1];

Now I am using sc_link macro in the OnRecord event to convert the field as a Link.
I am passing sc_link parameter as follows
sc_link(Fieldname,$pagename,$param,“Test Hint”)

the $param is not accepted since it is a string. but when i give the parameter as direct string it accepts

sc_link(WFI_RefCode, $pagename,v_pono={WFI_RefCode},“Open and check”,“grid_WF_view”);

Anybody can help…?

Thanks & Regards
Dhana