# Insert new value into schedule dataset

**URL:** <https://forum.inductiveautomation.com/t/insert-new-value-into-schedule-dataset/81486>\
**Category:** Ignition\
**Tags:** database, perspective\
**Created:** [November 3, 2023, 8:33pm UTC](https://forum.inductiveautomation.com/t/insert-new-value-into-schedule-dataset/81486 "2023-11-03T20:33:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jose\_Quintero](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jose_quintero/32/38120_2.png) [@Jose\_Quintero](https://forum.inductiveautomation.com/u/Jose_Quintero)\
**Post date:** [November 3, 2023, 8:33pm UTC](https://forum.inductiveautomation.com/t/insert-new-value-into-schedule-dataset/81486/1 "2023-11-03T20:33:17Z")

</div>

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)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/5/a528ac5a46bd8242a7ece2ad4ea4eac1f0950300.png)

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?

---

<div class="post-metadata">

**Author:** ![sydney.bosworth](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@sydney.bosworth](https://forum.inductiveautomation.com/u/sydney.bosworth)\
**Post date:** [November 3, 2023, 9:25pm UTC](https://forum.inductiveautomation.com/t/insert-new-value-into-schedule-dataset/81486/2 "2023-11-03T21:25:25Z")

</div>

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.
