[SOLVED] Text field with mask - how to save into database full value with mask?

Applications Forms
#1

Chaps,

1st question:

I have situation, that I have to create mask for one text filed in Form: 123-123. I assigned mask XXX-XXX or 999-999 and it is works fine. But I need something more: values should be saved in database with format like mask: 123-123. But value is saved as 123123 without sign “-”. I know… it is trivial issue, but i don’t know how to solve it. Could you please help?

2nd question:

How to assign grid into form in layout like below:

  • Form -
    | input 1 | grid1
    | input 2 |
    | input 2 |

Thanks!

#2

Copy the fieldvalue to a string, add the - characters and catch the OnAfterInsert/OnAfterUpdate. In that event do an update to write your own fieldvalue…

#3

Hello rr. Thanks, it makes sense… and it works. Thread could be closed.