Try out the attached DB. If you open Scheduleplanner and open the record you will see a new tab called Tab. There you can select a time slot, then select any number of services then click on the Mark Scheduled button and it will change a new yes/no field in Dailyplan called Scheduled from No to Yes.

You can use the Reset Schedule button to change them all back to No and test it out again.

You can ignore the other formula fields. I use many formula fields while I develop scripts to help me make sure my logic is correct and I'm getting the proper dataset.

The hard part was figuring out a way to always get the time slot that covers any time period that is below the next 15 min timeslot.

Kruna said:
1. is it possible to when I chose from dcf ‚select start time‘  eg 9:00 and from dmcf ‚Select Service‘ eg Service xy. Then I Chose another time lets say 10:00 with Service ‚abcd‘.
if I go back to start time 9:00 there should be respektive Service, which means ‚xy‘?
2. How can I have the Service seen in subtable like here.
right now I also entered the Service in  the subtable, but thats kind of double ‚work‘.

 Is 1 and 2 the same question? You want to add the service selected in Scheduleplanner to a service in Dailyplan?

If that is true, since Select a Service is a dMCF then you will need a subtable that can store each service selected for each timeslot.

4. how and where is best to implement an appointment field, so that it will be schown in camendar?

Maybe make a child table in Scheduleplanner that tracks appointments?

3. Can I trigger dcf ‚select start time‘ and dmcf ‚select service‘ to same Dynamic Fields in subtable?

You can, but I'm not sure why.

Kruna said:
I did achieve this by chosing the Services in subtable First and then I have to chose the same Services again in parent table in second step,

I would be careful of using dMC fields to store data. There is an issue with Ninox where dMC fields data gets corrupted when the root table of the dynamic field gets reorganized.

But to answer this question, it is easy to copy dMC selections to another dMC. Assuming the second dMC is pointing to the same table then all you need to do is:

let t := this;
seconddMC := numbers(t.firstdMC)

A way around this would be to create a child table of Dailyplan that tracks how many services are tied to a specific timeslot.

Another challenge for me is to get this to work when there are more employees and each employee has two columns, like button ‚Mark Scheduled‘ , „Reset scheduled“ twice.

I would suggest you add another dC field that allows you to select employee.

Concerning the appointment Field, unfortunately I dont know how to implement it.

The first step is figuring out where the appointment field should live. I don't think it belongs in the Dailyplan table because Dailyplan is broken down by 15 minute time increments and that doesn't fit the appointment format.

My initial thought is to create a table called Appointments. You can make a link to Services and Client and employee.

Seems like Scheduleplanner is really a dashboard. You don't need to create a record for each day. You can add a date field to allow users to select a date to schedule an appointment or to view appointments.

The big thing to figure out is how you want to handle scheduling appointments when multiple services are selected? Is there an order that the services will be handled? Or just that multiple services will be done during that time frame. If that is true then you will need a ServicesRendered child of appointments to track the services scheduled.

Take a look at a possibility for the appointments table in the attached DB.

Found some time. Here is my changes. I only update the button in SchedulePlanner. I don't see how you can add the same button to DailyPlan since you don't have the same information.

I did update the code to update the R@Dienstleistung field in DailyPlan so you can see the services selected.