How to add a calculated field without unlocking script manager

[Anonymous]

Hi,

It's not obvious for me, so I ask. How can I add calculated data to a table using script editor without loosing the chance to edit it in data manager?

I.e. I have date field DocumentDate and I would like to add another date field that is based on existing DocumentDate field. But I don't want to change and unlock the section generated automatically by data manager. Is it possible in script manager?

Maciek

[mkelemen]

Hi,

use the auto generated table in resident load with the manipulations you need and then drop it.

You need to add new section in the script and move it below the auto generated part and put the script there.

BR,

  Matus

[Anonymous]

🙂 Very tricky, thanks, it solves my problem.

I would like to ask also three questions:

Is it a common situation that auto-generated section is being unlocked or this is a rare case?

It causes new situation when I delete original tables, which I haven't met before, that I can't edit connections between tables in data model editor is it also a common situatution/consequence? Can I edit it in some different way?