Enter the Arabic date and convert to Gregorian

[Ahmad_1]

1- I want the entry in Arabic to be in the first box 

2- The corresponding Gregorian date shall be automatically after the introduction of Arab history

[SkrOYC]

Supported locales - AppSheet Help

[MultiTech]

Difficult... you can't split locales like this (unless there's a way to cheat things)

----------------------------------------------------------------------------------------------------------

Only work around I see would be:

1. Set your locale as Gregorian (so you can see 123) when looking at the actual dates in a calendar and such
2. Inside your form, create separate fields for someone to enter:
   1. Day
   2. Month
   3. Year
3. Make these data-entry fields use ١٢٣ for their allowed values
     - As you might have surmised the year entry field will be problematic to get working smoothly

----------------------------------------------------------------------------------------

Only other option I can see, unless I'm missing something (which is possible), would be to set your local so it uses ١٢٣ - then create a "display" field that basically SUBSTITUTE()s out all the ١٢٣ numbers for their 123 counterparts.

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
  "١٢٣", 
"١", "1"), "٢", "2"), "٣", "3"),
 "٤", "4"), "٥", "5"), "٦", "6"),
 "٧", "7"), "٨", "8"), "٩", "9"), "٠", "0")