One-time slot selection field for requests

[TraKill]

Hi everyone,

Is there a way of a selection field in Workfront forms, where when user 1 selects time slot 7:00 am, it is not available for user 2 anymore in the selection of different time slots? (similar to booking time in a calendar but via requests)

[monicacardoso]

Hi @TraKill, 

Thank you for your question! Unfortunately, Workfront does not support real-time field locking or dynamic field filtering across users in custom forms; so what you're asking for (exclusive time slot booking in a dropdown field) is not natively possible with just selection fields in a request queue.

However, you can build a workaround like this:

1) Use Workfront Fusion

• Have a dropdown field for time slots in a request form (eg. 7:00 am, 8:00 am, etc) 
• Use Fusion to monitor submitted requests:
  • When a time is booked, mark it as “unavailable” in a separate data store or object
  • When a new request comes in, Fusion can reject or flag it if the time is already taken
  • Not truly dynamic in the form, but enforces uniqueness after submission

2) Use a Calendar/Booking Tool Embedded in Workfront

• Use an external booking tool like Calendly, Microsoft Bookings, or Google Calendar
• Embed the booking form or link in the custom form or request instructions
• When users submit, the selected time is blocked externally
• Then collect only the booking confirmation ID or time in Workfront

- Monica

[TraKill]

Interesting! I assumed it would work via Fusion and an API call to make the field hidden, but I don;t know what to put in the API call...Thank you

[monicacardoso · Accepted solution]

Hi @TraKill, 

That sounds like a good idea. However, Workfront’s API does not currently support modifying form field visibility in real time or changing a dropdown’s available options after the form has been rendered to the user.

You can use the API to update the entire custom form’s dropdown list options via POPT (Parameter Options) updates, but this would affect all users and is not typically recommended for real-time booking logic as it could pose issues if 2 users rendered the form or booked the same slot at the same time. 

https://developer.adobe.com/workfront/api-explorer/ 

- Monica