display logical field as checkbox in a list control

[kingcarol]

Re: display logical field as checkbox in a list control

Attached is my dumbed down component and a way-scaled down Access mdb with a table and a query (view). The list control in the component is connected to the view because that view includes a field to use as logical for changing the field PAID_STATUS back and forth between TO PAY and UNPAID. The checkbox shows checked if PAID_STATUS = TO PAY and unchecked if PAID_STATUS = UNPAID. Basically, my users are selecting bills to pay with the check box. They don't see that PAID_STATUS field.

I have gone ahead and included my test button at the top of the component that loops through the list control and gets primary key values for the checked and then for the unchecked checkboxes, then does an ajax callback to an xbasic function that updates the table accordingly. For testing, I have a couple of text boxes on the component to show the primary key values (entry numbers) that the javascript looping captures.

Just as an aside, you will see that I am capturing errors when connecting, or running the sql statements, and then calling a js function that has a nice message box with info about the error and what the user should do. Just as a point of curiosity, you might want to try making the connection or the sql statements fail and check out the message.

CHSTestCheckbox.zip

[Davidk]

Re: display logical field as checkbox in a list control

The only change is to the List Layout for PaidStatusYesNo... adding in the stopPropagation stuff.


ZZZ_TestCheckboxesInListControl_1.zip

[kingcarol]

Re: display logical field as checkbox in a list control

Thx, David. I am away from computer and may not try it till tomorrow morn and will let you know.

[kingcarol]

Re: display logical field as checkbox in a list control

David, it's better now on Ipad, but it is unstable. By that, I mean I can click the checkboxes and they respond for the first couple, sometimes more, and then they quit responding to clicks OR there is very random response. Also tried it on Windows 10 touch screen, and it does not do well there using touch.

[Davidk]

Re: display logical field as checkbox in a list control

Hey Carol,

I'm not seeing any unusual behaviour.

Unsure what you mean by better. Did it work at all before? Before the use of $e.stopPropagation() there was no response at all. It's possible that the setTimeout value needs to be adjusted for your use... or your iPad... unsure.

I just hammered away at the checkboxes for a couple of minutes and no issues. If I miss tapping the checkbox control, the row gets selected... but that's me not hitting the checkbox control.

Maybe Selwyn can help you out further.

[kingcarol]

Re: display logical field as checkbox in a list control

I will mess with the timer and see what happens.
By better, I meant that it did not work at all before. Anyway, it works great on pc, so I will probably advise my clients to use the feature on pc's, and maybe give them something later for their touch devices. Will probably end up leaving my previous grid in place and give them a choice between the grid (if on touch) and ux (if on pc), blah, blah.
Thanks so much for your help, David.

[Davidk]

Re: display logical field as checkbox in a list control

I probably wouldn't use a Checkbox control on a mobile device. I'd use a Switch Control instead... but I'm not sure what is available to you at your Alpha build level.

[kingcarol]

Re: display logical field as checkbox in a list control

I don't see anywhere on my build to put a switch control on a list control. It is not in list of input types that drop down for a template, and it is not in the list when you click Add Item on the fields tab of the list control. Do you have the ability to put a switch control on a list control in your build, David?

[jgrannis]

Re: display logical field as checkbox in a list control

I believe that being able to easily put a switch control on a list control was added to some build at the end of August or September 2017. I remember because it was related to a feature request that I submitted to Alpha shortly before.

[Davidk]

Re: display logical field as checkbox in a list control

I don't see anywhere on my build to put a switch control on a list control. It is not in list of input types that drop down for a template, and it is not in the list when you click Add Item on the fields tab of the list control. Do you have the ability to put a switch control on a list control in your build, David?

Yes... actually you can apply a Control Type to a Field in the List Control... and that Control Type can be RadioButtons, CheckBoxButtons, Switch, etc... and their use and selection depends on the data type in the field.

But... that's why I wrote that I wasn't sure what is available to you at your Alpha build.

[kingcarol]

Re: display logical field as checkbox in a list control

Yep, I see the info about a switch control in a list control in this video: https://www.ajaxvideotutorials.com/V...ntroltypes.swf

It IS in a later build than I have so maybe I'll bit the bullet some day in the future and update when I am in a less bizzy condition. Thanks!

[kingcarol]

Re: display logical field as checkbox in a list control

David, I just went to look at the timer in my javascript function clickCheckbox on my real component. I realized that my real component is different from one I sent you in one way... I have an additional line in the function that sets the value in a textbox to Yes, so that I can detect if user has clicked checkboxes and make sure the update gets done before user moves off the component. I had that line at the first of the function, so since I was thinking about timing, I moved the line to the end of the function after the If stuff. Then I tested on ipad and the checkboxes seem to be behaving perfectly. Does it make sense that moving that line of code could make the difference?

Below is my js function now. Previously I had that last line as the first line of the function.

function clickCheckbox(row){
	var currState = $('checkbox'+row).checked;
	
	{dialog.Object}.__checkRow = row;
	
	if (currState == true){
		setTimeout("$('checkbox'+{dialog.Object}.__checkRow).checked=true;",50);
		
	} else	{
		setTimeout("$('checkbox'+{dialog.Object}.__checkRow).checked=false;",50);
		
	}
	
	{dialog.object}.setValue('NEEDS_CHECKBOXES_UPDATE','Yes');
}

[jgrannis]

Re: display logical field as checkbox in a list control

Here is a solution for a "switch" (but it is actually a stylized checkbox to be made to look like a switch) in a list.
I don't believe you would need to update your build version.

checkboxTest.a5wcmp

The included products list is based off the Northwind.mdb

[Davidk]

Re: display logical field as checkbox in a list control

Unsure... I don't know what else is happening regarding the setValue.

Did the component I sent back work for you?

[kingcarol]

Re: display logical field as checkbox in a list control

Here is a solution for a "switch" (but it is actually a stylized checkbox to be made to look like a switch) in a list.
I don't believe you would need to update your build version.

[ATTACH]44725[/ATTACH]

The included products list is based off the Northwind.mdb

Hi Jeff, I downloaded your component. Thanks! That looks great if using the Detail View for a list control and I'm going to keep your example. Thanks!
I'm not using the Detail View in the list control I'm working. My users just want to run down my list very quickly, and do check marks and not have any delay to do a callback, or a submit, before they do the next check mark. So David's solution for that 'live' checkbox is a good one for me.