setValue in list doesn't work on button.

[wei243]

Hi Experts,

I have a list LIST1 contains 1 column youranswer and 1 button.

I would like to set youranswer value to Yes when click on the button.

But I cannot see any changes on youranswer after click the button.

The code inside the button...

{dialog.object}.setValue('list::LIST1::answer', 'Yes');

Is it anyway to make it work?

Thanks,
Regards.

[peteconway]

Re: setValue in list doesn't work on button.

'LIST::LIST1::answer', 'Yes' - use Ucase.. and see what happens

[Davidk]

Re: setValue in list doesn't work on button.

Case does matter, but in a completely different manner. You can't use .setValue() on a List control in the way you're using it. The List Control is a data control, and so it's "value" is the "Return value type"... usually PrimaryKey or a Field Name. When you use .setValue() on a List, you're selecting a row (or rows)... not setting the value of a column.

There's a lot of information missing from your question... but let's say you have a simple read only List, no Detail View, and you want to change the value of a column in a row. You've not said anything about updating a database so I won't consider that.

Get the List Object, then use .updateRow() on that object. You'll need to know either the row number or the List key value (if the List is configured to return the Primary Key).

var listObj = {dialog.object}.getControl('list1');
listObj.updateRow(3,{youranswer: 'Yes'});

It does not matter what case you use for list1, but case does matter when referring to your column name - it must match your List column name.

This code only updates the data displayed in the List control for the 3rd row (zero based). It has no effect on the SQL Table.

listObj.updateRow('167',{youranswer: 'Yes'});

With the List set to return the Primary Key, this would update the row with the Primary Key value of 167.

If you want to update a table, then your List would have a Detail View and you'd update the List and table through the Detail View controls.

[CharlesParker]

Re: setValue in list doesn't work on button.

This is probably a similar question as it has to do with setting the value of a field in a clicked on row.
I have an image in my list control. When a user clicks the image I want to evaluate the value and change the value of another field. Heres the javascript code I want to edit to work in this context.

var nope = "No";
var tic = {dialog.object}.getValue('tasks_is_complete');	
Switch(tic){
	case 'Yes':
		{dialog.object}.setValue('tasks_is_complete',nope);
		break;
	case 'No':
		{dialog.object}.setValue('tasks_is_complete','Yes');
		break;
	case 'Reminder':
		{dialog.object}.setValue('tasks_is_complete',nope);
		break;
	case 'Flag':
		{dialog.object}.setValue('tasks_is_complete',nope);
		break;
}

Ok, so that's how I would do it if this were in the onchange event of a typical field but this is an image field called 'grpimage'
The onclick event for an image says that I must reference "data.fieldName" to reference the list controls current row data.

Can someone tell me how I can convert my code to work in this context?
I tried 'data.tasks_is_complete' to refernce the setValue field but that didnt work.
not sure of how to make a click event work on an image field.
tasks_is_complete is an adjacent field to the image which is a conditional image based on tasks_is_complete btw.

The idea would be the user taps (clicks) on the image and then sets the status to No
The end goal would be to save the value as well with the click, im just working through the first steps.

[GGandhi]

Re: setValue in list doesn't work on button.

this has nothing to do with what you are looking for but the code can rewritten as

var nope = "No";
var tic = {dialog.object}.getValue('tasks_is_complete');	
Switch(tic){
	       case 'No':
		{dialog.object}.setValue('tasks_is_complete','Yes');
		break;

               case 'Yes':
	       case 'Reminder':
	       case 'Flag':
		{dialog.object}.setValue('tasks_is_complete',nope);
		
}

[Davidk]

Re: setValue in list doesn't work on button.

I've read your post a few times but it isn't getting any clearer. You have a List control with a conditional image field. That conditional image field is based on another field in the List... "tasks_is_complete".

You want to click that image field and change the value of the List field "tasks_is_complete".

If "tasks_is_complete" is "No", then change it to "Yes"... else change it to "No".

Changing the List field value of "tasks_is_complete" results in an automatic change of the conditional image.

Is this what you want?

[CharlesParker]

Re: setValue in list doesn't work on button.

don't you have to finish with "break;" before the closing } ?

[CharlesParker]

Re: setValue in list doesn't work on button.

David that is exactly right

[CharlesParker]

Re: setValue in list doesn't work on button.

So I looked at the xbasic generated it's as follows:

dynamicImage.onClick = <<%str%
var nope = "No";
var tic = {dialog.Object}.listGetValue('tasks','tasks_is_complete');	
Switch(tic){
	       case 'No':
		{dialog.object}.setValue('tasks_is_complete','Yes');
		break;

           case 'Yes':
	       case 'Reminder':
	       case 'Flag':
		{dialog.object}.setValue('tasks_is_complete',nope);
		
}%str%

so just like the conditional image itself it needs to be in string format - this is where I am lost as how to write it. The help section does say to use data.fieldName
soooo, it could be like this?
{clientSide}data.tasks_is_complete=='Yes'|{dialog.object}.setValue('tasks_is_complete','No');

[Davidk]

Re: setValue in list doesn't work on button.

I think you're getting wrapped around the axle a bit.

If what you're presenting is actually what you want to do, then a "switch" statement isn't really needed. You're showing a simple if...then...else... process. If No then change the value to Yes... anything else change the value to No.

The Dynamic Image in the List control has an OnClick event. And a "Stop event propagation" property. If your List has onClick or onSelect, etc. event code, then you'll need to decide if you want to stop propagation is the Image OnClick event. That's up to you.

The code for the Image OnClick event is...

var tic = data.tasks_is_complete;
if(tic=='No'){
	listObj.updateTableRow(rowNumber,{tasks_is_complete: 'Yes'});
}else{
	listObj.updateTableRow(rowNumber,{tasks_is_complete: 'No'});
}

The OnClick event provides 'listObj' - a pointer to the List control... and 'data' - a JSON Object of that row's data.

You'll need to turn on the List property 'Has Detail View'... but you don't need to add any Detail View Controls.
You'll need to add a Synchronize button... or automatically sync the changes back to the table.

[CharlesParker]

Re: setValue in list doesn't work on button.

Ok, interesting. I did read the "updateTableRow" methods a little while ago and wondered if that was the way to go, but not knowing would've been a huge dart thrown in the dark for me.
I do have a detail view and syncs auto so that should work out. I will try to figure out the stopped prop on the click event and post back. Thanks for the advice, I wonder sometimes though how the hell you know all of this, nevertheless, I am REALLY glad you are such an active part of the community.
~Cheers

[CharlesParker]

Re: setValue in list doesn't work on button.

Ok, so that is working quite nicely - of course, I have other edits now that I have the method. When the status is changed to "Yes" meaning the task is complete, I also update the calendar color which is also a else if scenario based on other fields (calcolor1 and calcolor2).
This is actually a calendar event using Jims Calendar that changes color based on the status. Users can look at their calendar and quickly see the status by color, however when a tech is in the field he gets an Agenda (List) that he can just tap the image to mark as complete, if he wants to create a report or add images etc he can go to the detail view with a double tap.
I think it would be really helpful if AS would include a code snippet in there, such as what you provided. I think I can figure it out now.

[CharlesParker]

Re: setValue in list doesn't work on button.

So far this is what I have:

var tic = data.tasks_is_complete;
if(tic=='No'){
	listObj.updateTableRow(rowNumber,{tasks_is_complete: 'Yes'});
	{dialog.object}.saveListEdits('TASKS',{rows: 'current'});
}else{
	listObj.updateTableRow(rowNumber,{tasks_is_complete: 'No'});
	{dialog.object}.saveListEdits('TASKS',{rows: 'current'});
}

This works great, as DK pointed out you might want to sync the edits! Since I did not know the correct syntax for that, I just let Alpha create the button to sync then copied the code.

[GGandhi]

Re: setValue in list doesn't work on button.

don't you have to finish with "break;" before the closing } ?

The point was not that
You have same end point for 3 options if so you don't need to write them out separately you can list as I did
And you don't need break for the last statement since it will fall off after that.

[CharlesParker]

Re: setValue in list doesn't work on button.

Ok, just asking. As you can see, I had my head wrapped around the axle as DK said anyways AND this has been sorted. I also think it will help others out as the help section in that area really doesn't explain it near as well as DK did in his example. Thanks for the expert adive on the JS though as well because I actually write the whole thing out every time.