BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbox

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
sabbirehal
Posts: 57
Joined: Fri Feb 12, 2016 11:35 pm
Location: Brampton, ON

BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbox

Post by sabbirehal »

Hi Group,
I am trying to upper case the field value dynamically on the screen to upper case with the option as Dynamic checkbox property in v8.4 but its not doing anything. The UPPERCASE function though converting the value to uppercase after saving the record.
Any idea if the Dynamic checkbox suppose to do the UPPERCASE dynamically on the entry screen or not?

Thanks
Sabbi
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by Jaymer »

i can give you Javascript to do it if you're int.
can't address the real issue though.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
sabbirehal
Posts: 57
Joined: Fri Feb 12, 2016 11:35 pm
Location: Brampton, ON

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by sabbirehal »

Jaymer,

I just want to know if it is a bug or maybe the Dynamic checkbox property meant to do something else?

Thanks
Sabbi
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by Jaymer »

dynamic rule gets proccessed immediately to do exactly what you are trying to do.
but i cannot answer (without trying) as I do not have 8.4 installed.

even in 8.3, i cannot be sure that if the field you update is the same field in the rule ( if Name was changed then Name = UPPERCASE(Name) ) that is is refreshed when you tab out of it. normally, ANOTHER field is updated when you tab out of Name - I cannot say I've tried it on the SAME field.
And it may only be a display bug in 8.4

so i cannot help you
sorry
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
BobK
Posts: 544
Joined: Thu Jan 31, 2008 2:14 pm
Location: Cincinnati, Ohio, USA

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by BobK »

It works, but the function is TO_UPPER_CASE
used like
RegularUser.TestField=TO_UPPER_CASE(RegularUser.TestField)
Bob
sabbirehal
Posts: 57
Joined: Fri Feb 12, 2016 11:35 pm
Location: Brampton, ON

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by sabbirehal »

Hi Bob,
I am using correct function. Please see the attached picture. Even after tabbing out the field, the value does not convert to upper case. It does change to upper case only after saving the record though.

Thanks
Sabbi
Attachments
upper_case1.jpg
upper_case1.jpg (148.78 KiB) Viewed 11873 times
BobK
Posts: 544
Joined: Thu Jan 31, 2008 2:14 pm
Location: Cincinnati, Ohio, USA

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by BobK »

Sabbi,

I never tried it with 3 actions in 1 rule.

Try putting each action in a separate rule.

Note: It has been my experience that this only works when tabbing out of the field into another field. So, it does not work for the last field on the form.
I do not know if that is a bug or feature :)
Bob
sabbirehal
Posts: 57
Joined: Fri Feb 12, 2016 11:35 pm
Location: Brampton, ON

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by sabbirehal »

Bob,

I tried separating out each rule for different fields but same result.
Is there any support email for reporting the bug to awareim or I can directly send to Valdimir?

Thanks anyway for you help.

Sabbi
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by Jaymer »

SOLUTION

ok, this may have been too easy to make the experienced users overlook this

first of all, i tried what you have done, exactly, in 8.3 with same result.
but then I realized the same thing from the FIRST TIME I saw your example (I was in bed and not at kbd) - hey, thats not the way I would have written that.

My rule would have been this: (and this works as expected) (Dynamic, of course)

IF Cust.FName WAS CHANGED THEN
Cust.FName = TO_UPPER_CASE(Cust.FName)

enjoy!
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
sabbirehal
Posts: 57
Joined: Fri Feb 12, 2016 11:35 pm
Location: Brampton, ON

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by sabbirehal »

Jaymer,

Thank you very much. Yes, adding the IF condition solving the issue.
I just started learning the awareim and I may have lot of questions down the road.

Regards,
Sabbi
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by Jaymer »

Just had the need to do this in 8.4

Thought it wasn't working at first. As BobK said, it doesn't work (or appear to work) if you dont tab into another enterable field.
Tabbing to a Combo Box/Reference Field WILL NOT redraw the TO_UPPER field and it will still appear lower.
Just seems odd.

makes me wonder if the rule didn't really fire (when tabbing off), OR
if the rule will never fire (if you don't park on another field), OR
if the rule fired, but screen didn't re-display
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo

Post by Jaymer »

I like this CSS method a lot more than the Rule.

Note: the CSS method DISPLAYS uppercase, but its still lower (or as entered). its NOT converting the data before it goes to the db.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Post Reply