0

I have a sharepoint list setup on SP2013, 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
  • Since capabilities can vary greatly between versions of SharePoint, please make sure to always tag your post with which version (2010, 2013, etc.) of SharePoint you are using.
    – willman
    Mar 8, 2020 at 20:18
  • Thanks, added the version in the post
    – jangovin
    Mar 9, 2020 at 3:32

1 Answer 1

0

You can check this similar post for a sample script: how to Display additional lookup columns in NewForm.aspx after selected indexchanged.

  1. Add two lookup columns to display the Session Name and the relative Session Booking Count in List A.
  2. Add the custom code with a Script Editor web part on the NewForm.aspx page in List A.

And for the column validation: how to validate a column using jQuery.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.