cancel
Showing results for 
Search instead for 
Did you mean: 
FlorianZ17
Nintex Newbie

Make calendar entries visible depending on their status.

Hello everybody,

 

I have the following fundamentals:

  • A SharePoint calendar in which I can enter lecture slots.
  • In a second SharePoint list I have the fields Speaker, Topic and Appointment.

 

My first steps:

  • I have linked the SharePoint calendar to the SharePoint list.
  • Now I can use a lookup field in a drop down to display the appointments I have previously created in the calendar.

 

What I am missing / my question to the community:

  • How can I build a filter that only allows me to see the available dates of the SharePoint calendar?
Labels: (1)
Tags (1)
0 Kudos
Reply
12 Replies
Highlighted
Automation Master
Automation Master

Re: Make calendar entries visible depending on their status.

how do you determine 'available dates'?

0 Kudos
Reply
FlorianZ17
Nintex Newbie

Re: Make calendar entries visible depending on their status.

I have set that when you select a date from the drop down, the status changes to Booked.

I want that the drop down list only shows the not booked dates.

0 Kudos
Reply
Automation Master
Automation Master

Re: Make calendar entries visible depending on their status.

create a view on the list that show only not booked items.

configure the view name into 'Source view' lookup control configuration option.

0 Kudos
Reply
FlorianZ17
Nintex Newbie

Re: Make calendar entries visible depending on their status.

The problem is that when I work with a list lookup I always get an error message.

Fehlermeldung.PNG

0 Kudos
Reply
FlorianZ17
Nintex Newbie

Re: Make calendar entries visible depending on their status.

  • I'll try to explain it better.
  • I have set a look up field on a calendar in the form for the appointment selection, so that in a drop down all appointments I have created in the calendar are displayed.
  • In addition, I have specified that each appointment can only be assigned once, as you can see from the error message.
  • How do I get it that only those appointments are displayed in the drop down that have not already been booked? 

Fehlemeldung.jpg

0 Kudos
Reply
Automation Master
Automation Master

Re: Make calendar entries visible depending on their status.

have you seen my previous post, I think it satisfies your requirements.

or doesn't it suit you for any reasons?

0 Kudos
Reply
FlorianZ17
Nintex Newbie

Re: Make calendar entries visible depending on their status.

Thank you for the information that works. Smiley Happy

 

In a second step, how can I arrange that the selected date from the drop down will change after saving the form the calendar appointment automatically to booked?

0 Kudos
Reply
Automation Master
Automation Master

Re: Make calendar entries visible depending on their status.

create a workflow that strart on item create and that updates respective entry in calendar list

0 Kudos
Reply
FlorianZ17
Nintex Newbie

Re: Make calendar entries visible depending on their status.

I tried it, but it always updates the first item and not the selected date.
Testkalender.PNG

0 Kudos
Reply