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
BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbox
-
- Posts: 57
- Joined: Fri Feb 12, 2016 11:35 pm
- Location: Brampton, ON
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
i can give you Javascript to do it if you're int.
can't address the real issue though.
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
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 57
- Joined: Fri Feb 12, 2016 11:35 pm
- Location: Brampton, ON
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
Jaymer,
I just want to know if it is a bug or maybe the Dynamic checkbox property meant to do something else?
Thanks
Sabbi
I just want to know if it is a bug or maybe the Dynamic checkbox property meant to do something else?
Thanks
Sabbi
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
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
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
Jaymer
Aware Programming & Consulting - Tampa FL
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
It works, but the function is TO_UPPER_CASE
used like
RegularUser.TestField=TO_UPPER_CASE(RegularUser.TestField)
used like
RegularUser.TestField=TO_UPPER_CASE(RegularUser.TestField)
Bob
-
- Posts: 57
- Joined: Fri Feb 12, 2016 11:35 pm
- Location: Brampton, ON
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
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
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 (148.78 KiB) Viewed 12355 times
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
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
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
-
- Posts: 57
- Joined: Fri Feb 12, 2016 11:35 pm
- Location: Brampton, ON
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
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
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
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
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!
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
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 57
- Joined: Fri Feb 12, 2016 11:35 pm
- Location: Brampton, ON
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
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
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
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
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
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
Aware Programming & Consulting - Tampa FL
Re: BO-Update Rules-Set Field to UPPERCASE - Dynamic Checkbo
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.
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
Jaymer
Aware Programming & Consulting - Tampa FL