Sharepoint Cascading Dropdowns - Show Default Value from List B in List A

[jangovin]

I have a sharepoint list setup for employees to make reservations for a training session. There is also a linked list where count against each session is updated when someone books a session, which has been completed using Nintex Workflows. So in effect:

List A Cols Staff Name - Session Details

List B Cols Session Details - Session Booking Count

What I am trying to do is have the Session Booking Count shown on newform of List A if user selects a specific session, and to write a validation to show error if Count > 10.

I have tried to setup a cascading dropdown option using jquery, and this does show the count of each session, however default value is coming as "(none)". User has to click on the drop down and select the count figure manually.

Is there a way to change this so that by default the count is shown?

The sharepoint I use does not have SPD or Infopath.

[#2]

@jangovin  which version of SharePoint are you using? It doesn't like SharePoint Online (Office 365) as you would be able to do this with Power Apps and/or Power Automate.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

[#3]

@RobElliott  Honestly I am not sure. Sharepoint is from my office, and I believe its either 2013 or 2016. They did not provide SPD, Flow, Infopath, or PowerApps.

Nintex is an option, but unfortunately this particular site has not been enabled with nintex forms at the moment.