Fields positioning when using html templates in grids

Scriptcase 8 Discussion
#1

When using own html template in a grid for the grid body you get a different interface in the menu fileds positioning.
You can also add new fields in the grid manually and they appear then in fields positioning menu where you can configure them.

Is there somwhere a help file how to use that interface?

Any help would be appreciated :slight_smile:

Joe

#2

Here is the official manual from Netmake.

http://www.scriptcase.net/docs/en_us/v8/manual_mp.htm#tools/layout/templates

Regards.

#3

Thank you for helping.

It is the last sentence in the help file what makes me confusing.
"Now associate the template variables with the Grid fields. (Grid>>Select Fields)

Format the fields and Run. "

This is where the help file ends.
In my template I like to show some fields from another table. So I tried a grid lookup that didn’t work.
I have a user table with user_id and a ‘name’ field and a data table also with user_id and now I would like to show the user’s name in the data grid.

How would be the select statement in this case?

Joe

#4

I use VIEWS in this case. SQL Bulder is helpful for building queries based on more than one table. Try it - the you simply Copy/Paste the SQL code to the SQL screen for the App.

Arthur