I would like to combine values of two fields on a page to one text field. Following is the demonstration:
On Customer form,
Month (Data Type: Option (January, February,...))
Year (Data Type: Option(2018,2019,2020,2021,...))
Intake (Data Type: Text(30))
The formula of "Intake" should be (Month,"/",Year).
Kindly assist on this.
Not quite sure what you're trying to do or what is "Intake"?
There are many ways to work with dates, but not sure if that's even what you need.
From what i understood :-
you can create text constant on the page %1 / %2
then on the field type in STRSUBSTNO(textconstant,Month,Year) - do you need to store this in table or just need appearing on page?
Intake is a field that should combine the values of the two fields, that is, Month and Year.
Thank you, let me try this and get back.
I would like it to be stored on the table.
then you might want to put the code in table.
So its just
Intake := Format(Month)+"/"+Format(Year);
Just write conditional update if needed if not Directly you can write on onvalidate of both the fields or call the function.
Thanks a lot. That has worked real good.