Updating only one field when changing record

[den1s]

Hi,

I have a grid with 3 radio buttons and a 3 Date and Entered By fields. When a user makes a selection in radio_button_1(Stat1), i update the Date and Entered By field with the users name value. When a user makes a selection in radio_button_2(Stat2), i update the Date2 and Entered By2 field with the users name value.and so on....

The problem with the code i am using is that if a 'different user' selects one of the radio buttons, 'all' the Date and Entered By fields change to the current user and current date. I need to prevent them from changing if its specific radio button remains unchanged.

select
    case DataSubmitted.Stat1="No"
		DataSubmitted.Date1=""
		DataSubmitted.Entered_by1=""
	case DataSubmitted.Stat1 ="Yes"
		DataSubmitted.Date1=date()
		DataSubmitted.Entered_by1=session.__protected__metUserName
end select

select
    case DataSubmitted.Stat2="No"
		DataSubmitted.Date2=""
		DataSubmitted.Entered_by2=""
	case DataSubmitted.Stat2 ="Yes"
		DataSubmitted.Date2=date()
		DataSubmitted.Entered_by2=session.__protected__metUserName
end select

select
    case DataSubmitted.Stat3="No"
		DataSubmitted.Date3=""
		DataSubmitted.Entered_by3=""
	case DataSubmitted.Stat3 ="Yes"
		DataSubmitted.Date3=date()
		DataSubmitted.Entered_by3=session.__protected__metUserName
end select

Is there a command i can place in my code that will only update the radio button related fields only and leave the related untouched radio button fields alone?

Thanks,

Denis

[Dan Blank]

Re: Updating only one field when changing record

I would put the date entered and user information in the Events section of the grid. Under CanUpdateRecord.

[den1s]

Re: Updating only one field when changing record

Hi Dan,

That's exactly where it is. But i need a rule that states;

'Only change the value of User Name and Date when the associated radio button has been changed'.

RADIO BUTTON1 ------- USER NAME1 -------- DATE1
RADIO BUTTON2 ------- USER NAME2 -------- DATE2
RADIO BUTTON3 ------- USER NAME3 -------- DATE3

e.g if i change the value in radio button 1, then only the username1 and date1 values change. If another user then changes the value in radiobutton2, then username2 and date2 change, but username1 and date1 remain unchanged.

I hope this is possible.

Thanks,

Denis

[marvinbase]

Re: Updating only one field when changing record

If you don't have the same field being updated again by a different person (ie, different people checking "Yes" on radio button 1 on two different days for the same record), you can do a lookup to the underlying table to see if the information has already been filled. For instance:

select
    case DataSubmitted.Stat1="No"
		DataSubmitted.Date1=""
		DataSubmitted.Entered_by1=""
	case DataSubmitted.Stat1 ="Yes"
                          [B][COLOR="Blue"]If alltrim(lookup(<YourTableName>,<YourRecordFilter>,"Entered_By1"))="" then[/COLOR][/B]
                               DataSubmitted.Date1 = date()
                               DataSubmitted.Entered_by1 = session.__protected__metUserName
                          [B][COLOR="blue"]end if[/COLOR][/B]
end select

[den1s]

Re: Updating only one field when changing record

Marvin,

Thank you for your response.

RADIO BUTTON1 ------- USER NAME1 -------- DATE1
RADIO BUTTON2 ------- USER NAME2 -------- DATE2
RADIO BUTTON3 ------- USER NAME3 -------- DATE3

There are 3 unique radio buttons, user name fields and date fields. If a user selects Yes on radio button 1 the username1 and date1 will be populated with data. However, another user may need to update radiobutton2, which will automatically update username2 and date2.

The problem is, if the second user comes along and updates radiobutton2, unfortunately username1 and date1 also get update with the current username and date. I need to stop this from happening and have only the associated radiobutton username and date updated. If the user did change radiobutton1 then i would expect the details username1 and date1 to be updated. But if your updateing radiobutton2, then only username2 and date2 should be updated and username1 and date1 should be untouched.

Any ideas?

Thanks,

Denis

[Dan Blank]

Re: Updating only one field when changing record

Hi Denis, You may need to attach your work. After reading this again, two different senarios pop into my head. It is a little confusing when you mention the second radio button that "all" the fields get changed. Is that all the fields for that record or all the fields in the table? Seeing what you have done may help get you a quicker response, so we aren't guessing.

[den1s]

Re: Updating only one field when changing record

Dan,

I am basically trying to update a text field with data depending on a value selection in a radio button. However, i have 3 sets of these in one grid.

The values i am having the problems with are;

DataSubmitted.Date1=date()
DataSubmitted.Entered_by1=session.__protected__metUserName

Reason being, that both items change when the form is updated based on the current date and username. I need to try and prevent all sets changing everytime a user updates the form. So using canupdaterecord is no doubt the place to put it, but there need to be some code in there to prevent all Date() and session.__protected__metUserName from all sets being updated.

I dont think i can expalin this in any other way. I hope this helps.

Thanks

Denis

[marvinbase]

Re: Updating only one field when changing record

Hi Denis,

Like Dan said, if you can post your grid or the database as a zip file, it may help; that way we can see what you're seeing. It would help to answer some of the questions below, and others that might arise once these are answered.

I am basically trying to update a text field with data depending on a value selection in a radio button. However, i have 3 sets of these in one grid.

^^Does this mean your user sees 3 sets of 2 radio buttons, for a total of 6 radio buttons? (One 'yes' and one 'no' radio button for 3 Datasubmitted.Stat fields?) Or do you have 3 radio buttons for a single Datasubmitted.stat field? The code you posted in your first post seems to indicate the first scenario.

Reason being, that both items change when the form is updated based on the current date and username.

^^Does this mean that both items are changed for only a single record, or all records in the table are being changed for all fields?

select
case DataSubmitted.Stat1="No"
DataSubmitted.Date1=""
DataSubmitted.Entered_by1=""
case DataSubmitted.Stat1 ="Yes"
DataSubmitted.Date1=date()
DataSubmitted.Entered_by1=session.__protected__metUserName
end select

select
case DataSubmitted.Stat2="No"
DataSubmitted.Date2=""
DataSubmitted.Entered_by2=""
case DataSubmitted.Stat2 ="Yes"
DataSubmitted.Date2=date()
DataSubmitted.Entered_by2=session.__protected__metUserName
end select
....

The problem is, if the second user comes along and updates radiobutton2, unfortunately username1 and date1 also get update with the current username and date

^^From all your descriptions, I still can't tell if all the fields are changing all 3 date and submitted fields everytime any field has changed- even if no one has checked any of the radio buttons at any prior point; or if it is only updating any field that has already been checked by a user in the past, and is overwriting the prior date and submitted fields.

If it is only overwriting fields that have already been filled in previously, it is probably because your logic

case DataSubmitted.Stat1 ="Yes"...
 ... 
case DataSubmitted.Stat2 ="Yes"...

is allowing both the current and previously changed fields to be changed every time that record has been selected. In other words, if your RADIO BUTTON1 is tied to the Stat1 field in your database, and the Stat1 field has already been saved as "yes" in your database because another user has already checked it in the past, then your grid will open with that radio button already set to "yes". When the second user checks RADIO BUTTON2, they have changed Stat2 to "yes" and Stat1 is already set to "yes" from the data saved in your database from a previous user. Therefore, both 'case DataSubmitted.Stat1 ="Yes"' and 'case DataSubmitted.Stat2 ="Yes"' are triggered, and the date and submitted fields are updated for all. That's why I had suggested using a lookup before.

Then again, if all the above assumptions are incorrect, then the problem lies elsewhere. In which case, posting some examples or your entire zipped database will help eliminate our faulty assumptions :)

[den1s]

Re: Updating only one field when changing record

Guys,

I have managed to resolve this by adding a simple 'if' statement;

[B]if Args.DataSubmitted.R1.Date1 = "" then[/B]
DataSubmitted.Date1=date()
DataSubmitted.Entered_by1=session.__protected__metUserName
[B]end if[/B]

Apologies if i didnt explain my issue clearly, but thanks to everyone for their input with this one.

Denis