Calculated column in a grid section

[gcjm]

After trying out the WebView, Form and Canvas sections and nothing worked satisfactorily, I wanted to try out the "calculated column".

Original column = beschreibung, Memo
Calculated column = besch80, char80, data source: left(beschreibung,80)

This works in the App Builder, but not with WebApp.
Server Error: The server failed to respond
and
F12 results in:
GET http://localhost:8001/odata/?$eval=left(beschreibung,80)&$app=events&_=1732226 418648
404 The requested page was not found

[yvonne.milne]

Hi Georg,

Sorry, I was mistaken - that does not appear to be supported.

Regards,

Yvonne

[barrymavin]

Look at example_smartgrid.

[gcjm]

Thank you for the good example for me, Barry!

To recreate the example, it would be good if I could output all attributes as files to compare what I should set.
Is that possible? How do I do that?

[yvonne.milne]

Hi Georg,

Have a look at the App Doc.

Regards,

Yvonne

[gcjm]

oh, why didn't I know that sooner! Thank you, Yvonne!

[gcjm]

Everything is not working the way I need it to.

I need a table for several thousand records (grid section?) with a date per row and a short excerpt from the memo field (e.g. left(80). Above that grid there should be a narrow (canvas?) section that contains the entire memo field in a scrollable manner and a small image if the record contains one.

Should I post this again in more detail under "tickets" because I have tried various combinations but mostly haven't gotten a working result for my web app.

[yvonne.milne]

Hi Georg,

In your scenario, you will have have 2 sections bound to the memo and this will cause an error.

I would use the following on the Grid Section:
- Split Grid
- Edit memo/varchar list (so you can view the whole memo)
- Edit memo/varchar editors (so you can edit the whole memo in your chosen editor)
- Show tabbed grid on web (to show the tabs)
- Show memo/varchar inline (to see the memo as you scroll the grid)
- View Image list (if you want the image in the grid tabs)

and experiment with
- Web grid row height

To show the image in another section, create a Form section and add an Image gadget.

Regards,

Yvonne

[barrymavin]

You can display anything in a grid cell using a custom renderer.

https://www.lianja.com/doc/index.php...Custom_Editors

You would reference the varchar column like this in javascript.

var text = Lianja.getCursor(“employees”).getData(“notes”)
return text.substring(0, 80) // return first 80 characters