repeat selection breaks custom javascript code

I have a page where a user enters rows of data into a database using a web-form. The user has to enter a variable amount of data rows which is determined by a database value.

I have two alerts... One shows if they still need to enter a certain amount of data rows... and another if they have entered a sufficient amount. Because there needs to be a calculation to determine what alert is shown I have used a piece of javascript with data bindings to achieve this.

here is the code for the alerts and the javascript that performs the function.

<p id="incomplete" class="alert alert-warning incomplete">You need <span id="remaining"></span> more consenting leaseholders to qualify.</p>
<p id="qualify" class=" alert alert-success qualify"><i class="fas fa-thumbs-up fa-2x"></i>You have a sufficient amount of leaseholders to qualify for Right to Manage.</p>

<script>
var f = "<?php echo $row_rsCurrentUser['total_flats']; ?>";
var c = "<?php echo $row_rsCount['count']; ?>";
var r = Math.round(f / 2) - c;
var rq = f / 2;
document.getElementById("remaining").innerHTML = r;
document.getElementById("required").innerHTML = rq;
</script>
<script>
if (r <= 0)
{
$('#qualify').show();
}
if (r > 0)
{
$('#incomplete').show();
}

</script>

My problem is when I place a repeat selection to a form option field. It breaks the javascript and both the alerts show and the one which has a dynamic value in it is also not calculating.

I have other repeat selections on the page which don't effect it. Only when I add this particular repeat selection

I've attached the page if it helps. its possible you'll require remote access.

Thanks in advance

I'll need FTP access, a URL to see the problem, and steps to reproduce in order to help debug something like this.

Thanks Ray. See PM

Debugging custom code is a bit beyond what I can do over the forums. If you want help with this, please sign up for a premier support ticket.

Ray I eventually solved the issue, not quite sure why but it was an issue with the recordset being used for both the select field and the repeat region. I created a separate recordset for the selection field and it solved the issue.

Unfortunately I'm still having a problem with an update behaviour which uses the select field in the form.

The Update behaviour is triggered by an access rule ( named "multiblock" that is dependent on a URL parameter value ( blocks=2 ). The update behaviour is triggered but the binding used does not seem to work. the binding uses the value from the selection field “block” ( which is chosen by the user ) from the “consent_collation” form . The selection field uses a repeat region to display all the options ( there is currently 2 - ‘Block A’ and ‘Block B’ ). I wonder if its an issue with the options within the repeat region!

Its an issue with the binding in the option selected. Because if I just put in a static number in the “Binding Value” it works.

You can use the same access I gave you in the previous PM.

Ive put database access in this PM if you need it.

Thanks in advance.

How is the blocks url parameter added to the URL to initiate the insert? My guess is that the form isn't being posted when that happens, so the binding doesn't have a value.

Ok.. So Its added from other 3 update behaviours that sit before that add the email. Email value uses 3 update behaviours because the email owner differs depending on other form selections. the 'blocks URL parameter' is added to the redirect URL in these three behaviours.

So if it is part of a redirect then the form POST values won't exist after the redirect. The best option would probably be to add the "block" form post value to the redirect as well and use $_GET to reference it, or save the value to the SESSION so that it will persist after the redirect.