Update Form Set Field Blank

[ChristianM]

I have an Update Form which has 2 fields:

Stock # (required)

Lot # (required)

After a user changes the Stock # for a record on the Update Page (but before submitting), I would like to set the Lot # field to blank. Then, because Lot # is required, a user would use a dropdown to select an updated Lot #. Currently, when a user changes the Stock #, the Lot # is already populated and users sometimes to forget to change that value as well (because it is already populated).

However, I am a bit stumped as to how I can set a field to blank in an Update Page. It doesn't look like I can set default values in an Update Page either. I cannot use Cascading Text Fields (table connecting Stock # to Lot #) either as this Lot # is routinely inaccurate and requires users to call specific facilities to verify the Lot #.

Has anyone ever run into this issue before?

Thank you in advance.

[futurist]

Hi @ChristianM,

COuld you try this instead?

 

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
    document.querySelector("[id*='EditRecordField1']").addEventListener('keyup', function() {
        document.getElementById("EditRecordField3").value = "";
         });
});
</script>

 

Replace the Field1 and Field3 with your Stock and Lot field, respectively. You don't have to separate them with underscore just like how you did with your last response for "EditRecords_Stock" and "EditRecords_Lot_Location". If your fields are named Stock and Lot_Location, they should simply be just "EditRecordsStock" and "EditRecordsLot_Location"

 

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
    document.querySelector("[id*='EditRecordsStock']").addEventListener('keyup', function() {
        document.getElementById("EditRecordsLot_Location").value = "";
         });
});
</script>

 

This should work. If it doesnt, change the keyup to change

[futurist]

Hi @ChristianM,

So basically what you need is, whenever a new value is selected in the Stock field, the Lot field should then be empty and user would have to select option in there too.

 

You can use the following script on the Footer of the DataPage:

 

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
    document.getElementById('EditRecordField1').addEventListener('change', function() {
        document.getElementById("EditRecordField3").value = "";
         });
});
</script>

 

make sure to replace "Field1" in "EditRecordField1" with the name of your Stock field, and the "Field3" in the "EditRecordField3" with your Lot field.

 

On your Lot dropdown, you would also have to add another option there with a blank value

[ChristianM]

Hi @futurist

Thank you for your response!

I added the suggested code to my Footer and replaced the fields with my Stock and Lot Location fields.

 

 

I went to update a record to test. The original Stock and Lot location:

 

 

When I changed the Stock, however the Lot Location did not go blank as expected:

 

 

I did add a blank option to the table to select from

 

 

Any issues you can see?

 

[futurist]

Hi @ChristianM,

I thought your Stock field is a dropdown as well. It seems like it's a text field, so you can use the following:

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
    document.getElementById('EditRecordField1').addEventListener('keyup', function() {
        document.getElementById("EditRecordField3").value = "";
         });
});
</script>

 

I used the keyup event instead of the change for the eventListener.

You would also wanna make sure that you have an option in the Lot Location dropdown whose VALUE is empty

[ChristianM]

@futurist thanks again for the code. Sorry that I didn't clarify that before.

The Stock field is an AutoComplete that pulls from a table.

The Lot Location field is a Dropdown that pulls from a table.

I realized that I had erased the "EditRecord" in my original code and have included it below in the Footer along with the two fields:

 

I can confirm that a null VALUE exists in the Lot Location dropdown table:

Unfortunately, after changing the Stock, the Lot Location is still staying as the original value.

Any other ideas you might be able to think of? I greatly appreciate your assistance.

[ChristianM]

@futurist

My field names are [s_Stock] and [s_Lot_Location] which is why I included the underscores.

The following code worked perfectly. When the Stock field is altered, the Lot Location field now becomes blank.

<script type="text/javascript">
document.addEventListener('DataPageReady', function (event) {
    document.querySelector("[id*='EditRecords_Stock']").addEventListener('keyup', function() {
        document.getElementById("EditRecords_Lot_Location").value = "";
         });
});
</script>

Thank you so much!