How can I perform an advanced find to obtain all the appointments. that do not have a value in the organizer field?
The attempt below does not show all the records as there are many more whose Organizer Field is completely blank.
How can I perform an advanced find to obtain all the appointments. that do not have a value in the organizer field?
The attempt below does not show all the records as there are many more whose Organizer Field is completely blank.
Hi Partner,
We could not fetch Appointment by organizer in Advanced find directly, the conditions as you set is useless.
You could try this way.
1.Create a new option set field name ifOrganizer to check if the organizer contains data and set its default value to true.
2.Create a new workflow based on Appointment and add a condition to check if the organizer contains data.
3.If the organizer does not contains data, then add an update action to update the isOranizer field to false.
4.Then you will be able to fetch out the appointments without organizer by the isOrganizer field directly in Advanced Find.
Regards,
Leo
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,430
Most Valuable Professional
nmaenpaa
101,156