New fieldtype / ghost fields

Scriptcase 8 Suggestions
#1

There are situations where you want to be able to have a non-editable grid, form, or editable grid form, to click on a field an start another application. This is not a problem if you link two forms together with an application or a field link. BUT both fields must have a connection based upon a database table. This principle will not work if you want to start a tab application, a container, or another form without database fields.
,
There’s an ajax event on fields possible, but if the field is not in edit mode then the contents of the field is not shown. It has no database connection!

A nice solution would be to allow a new field added without a database connection, give it type button or link, and alow it to be added to the grid or form. In case of a grid you get a column of all buttons. Add an event onclick to allow adding a piece of code to move the keyfields of the clicked record moved to a global variable(s). Redirect to the application (of type whatever, but here container/tab). This application contains subapplication which will be able to load data passed by the global variables using on-load.

It would solve a very common problem of having some data on the form in a non-updatable mode and be able to link to somewhere else.

I made some progress though. On the onLoadrecord I fill a ghost field with the value ‘link’. This way it is shown on a read-only form. But as the field cannot be of type ‘button’ or ‘link’ I cannot click it, so I cannot use the ajax onclick event.

#2

Re: New fieldtype / ghost fields

Hello,

I didn’t understood you fully, could you perhaps show a few screenshots to explain what you are trying to achieve, or wants SC to achieve?

It is possible to create fields that doesn’t exist on your table. You can also change connections, enabling you to call another form that uses another connection.

regards,
Bernhard Bernsmann

#3

Re: New fieldtype / ghost fields

I would like to have a column of buttons or links in a grid. This button will link to an other application, preferable a tab or container application. This is now not possible because SC needs a dataaware field. Point is that I add several applications into a container or tab application, but the tabapplication needs to be called.

If you have a datagrid then klicking on the the row button needs to be bound to an event to allow to pick up the correct row and appropiate data to pass to the application being called.

I hope I made things more clear now because I cannot make a screenshot because It cannot be done now.

Perhaps the next will make things even more clear:

add a field and make it of type button or link (new fieldtype)
genate a grid application or a form editable grid application.
this will show all records with a column containing a button (every row has it’s own button)
bind this button to a row number of the result dataset to be able to retrieve the correct data

Since container and tab applications do not have keyfields you need scripting to pass data:

create an ajax event on the button onclick
create an sc macro to retrieve the row data (new macro?)
in the onclick you can move the data into global fields
then call the application.

The applications added to the container or tabs have an onload event where they can pickup the keyfields and show the correct data

b.r. Albert

#4

Re: New fieldtype / ghost fields

Hello,

It is possible to do that with SC. Create a new field on your grid application, set its type to HTML Image. Create a link on this field passing the registry ID as parameter to another application.

regards,
Bernhard Bernsmann