Calculated column in a grid section

[gcjm]

How can I insert a calculated column with left(xyz,80) in a grid section with a memo column xyz?
Thanks Georg

[yvonne.milne]

Hi Georg,

Can you give more details on what you are trying to achieve?

Regards,

Yvonne

[gcjm]

WebApp, Grid section, Memo field:
My memo field is displayed in the table as "Memo". I can view and change the entire content in a split field.
For a quick overview of the table (up and down with arrow keys) I would like to initially only display the first characters of the Memo in a row.
Only when I find an interesting row do I open the memo in the split window.

[yvonne.milne]

Hi Georg,

I would put a small related webview section (drag and drop the memo field onto the page) under the grid section.

Regards,

Yvonne

[gcjm]

Good idea!
But:
Which type of webview section?
Where should I drag and drop from? (from table column names it doesn't not work with a empty webview section)

[yvonne.milne]

Hi Georg,

Drag and drop the table column name into an empty area of the page - that will automatically create a data-bound webview section. Then use the relationship builder to link the grid section to the new webview section.

Regards,

Yvonne

[gcjm]

Magic ;-)

Unfortunately, the grid doesn't work in the webapp like it does in the deskapp.
Desk: I can use the arrow keys to go through the grid
Web: I can't

It would be good if I could display an image from the data table in the (magic ;-) WebView section too. But how?

If I use a canvas section instead of the WebView section, I can display both memos and images (blobs) beside.
However, I can't move up and down in the grid using the arrow keys.

[yvonne.milne]

Hi Georg,

Use a form section instead of a webview and you can drag and drop memo and image into it (Rich Text Editor gadget and Image gadget).

To move through the grid you need to click or touch on the rows or the navigation buttons in the actionbar.

Regards,

Yvonne

[gcjm]

Use a form section instead of a webview and you can drag and drop memo and image into it (Rich Text Editor gadget and Image gadget).
To move through the grid you need to click or touch on the rows or the navigation buttons in the actionbar.

I also tried a form section (instead of a small automatic WebView section) in addition a canvas section too. With the latter, I can display several fields of the data set next to each other in the desired size.
I tried all the options for my purposes and stuck with the WebView section.

WebApp: What doesn't work:

- If you switch actions like "forward and bck" in the action bar at the bottom, the rows are not selected accordingly in the Grid section, but only the WebView section switches.

- While in the DeskApp you can display both the text content of the memo field and an image from a blob column optionally in a split window,
in the WebApp, when you click on "Edit", only a split text window is displayed.

It would be very good if DeskApp and WebApp had the same options.

In addition, Grid rows and WebView should be positioned synchronously.
I think "parent" and "child" are correctly related (by "datum" index).

Thank you very much!
Georg

P.S: By the way: Can you really not use calculated columns in a Grid section?

[yvonne.milne]

Hi Georg,

If the 'Pagination' attribute is false for the Grid Section, the arrows at the bottom of the Grid Section (not the Page) can be used to move first/previous/next/last row.

In the Assistant, set 'Show Tabbed Grid on Web' to see the 'Edit memo/varchar list' and 'View Image list' fields in their own tab.

Do not specify 'Parent key' and 'Child key' as the related sections are from the same table.

You can use calculated fields in a Grid Section - fields specified with a Calculated Column constraint / Calculated by column attribute in the Table Designer.

Regards,

Yvonne