Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

Have a field acting like Excel Cell

Avatar

Level 10

One of my clients have this request to have a field that can calculate operations for you but in only one field...

I am wondering if there's a method already made for this...

For exemple, in a field of hours, instead of inserting the number of hours directly we could insert the number of days he work with the number of hours and weeks... so the client could just insert 4 * 5 * 42 which will display the response in that same field... I can't make other fields for that cuz it's in a huge table and there is no space for more fields...

Anyone have an idea on how to achieve something like so?

Insert in a text field / decimal field / numeric field 4 * 5 * 42

will return the result 840 in the same field on exit event..

Thanks, Rob

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Rob,

I found the solution so if anyone else is looking for something similar,

you can set everything in the validate event of a text field preferably..

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Hi Rob,

I found the solution so if anyone else is looking for something similar,

you can set everything in the validate event of a text field preferably..