Insert new value into schedule dataset

Hello everyone, maybe this question is simple but so far I can't figure it out.

I have a dataset that I am using for a schedule object in perspective and I want to perform the following action:

I have a calculated value based on a record within a database table, the calculated record works properly but I need to generate a new calculated record for a specific field (add 1000 to the startDate in the schedule object)

Below the record shaded in blue I need to generate a new one by calculating adding 1000 to the startDate

I have been trying to make a transform but without success so far, has anyone worked with this type of alternative before?

1 Like

I would probably start with a named query to insert the row you want. Just pass the selected rows values as params into the named query.