Pass variable for insert record page using URL

I have an insert record page that I am using for a client who enters data into a database for multiple clients. I gave them a dropdown to use, but I am being told it is too time consuming to select the right client from a list of 50 or so, and they typically enter hundreds of records at a time for a single client.

Is there a way to pass the client name via URL so that field is automatically filled out?

Yes, just pass the school id in the url and then go to bindings and add the url parameter to your bindings. Then you can go to the dynamic button in the select list's properties panel and use the interface to set the default selected value in the list to the url parameter you have added to the bindings.

I'm struggling with this a little bit. I've added a URL Variable called "School", and have added that binding to the text on the page so I can see if it's working, and I can see whatever I place in the url on the page. (URL Below)

I have added that same URL variable in the bindings tab of my insert record server behavior (<?php echo $_GET['School']; ?>), but the school name is not being inserted into the database.

Am I missing a key part of the URL variable, or have I gone astray elsewhere?

Also, how would I alter the redirect to simply reload the original url with variable

You would want to save the school name from the URL into a hidden form element in the form, so that it would still be available after the form submits like:

<input type="hidden" name="School" value="<?php echo(htmlspecialchars($_GET['School'])); ?>" />

Then in the insert server behavior you would use: <?php echo $_POST['School']; ?> since it is now part of the form.