I have 2 tables and also I set the usersetting(language) and can choose English or Japanese.
When I choose one of these languages, column name , VC, enum, enumlist are automatically translate English or Japanese by setting switch() formula.
In case of enum, the value I set are English word and Japanese one.
see below table 1( ๆฃ่ ่ฟฝ่ทกtable).
And at the other table, I set the VC formulating select(ๆฃ่
่ฟฝ่ทก[ๆฌ้ในใใผใฟใน],
[่ช็ชID]=[_thisrow].[ID].
and then, I set the the another VC formulating RIGHT(text([ๆฌ้ในใใผใฟใน]),4).
When I selected Japanese at the usersettings, the above right()formula can work.
However when I selected English, the above right()formula cannot work successfully.
As you can see the last image, "Done" cannot be returned.
Does anyone know why this situation happen?
Or could you tell me how to solve the problem?
Solved! Go to Solution.
Even though I suspect there might be a better way to implement your requirement, you can try the following without changing what you have configured so far.
Since [ๆฌ้ในใใผใฟใน] is a list, if you want to get the "last element" you can try
INDEX(
[ๆฌ้ในใใผใฟใน],
COUNT(
[ๆฌ้ในใใผใฟใน]
)
)
as the App Formula of [้ ้ใฎ็ถๆณ].
Even though I suspect there might be a better way to implement your requirement, you can try the following without changing what you have configured so far.
Since [ๆฌ้ในใใผใฟใน] is a list, if you want to get the "last element" you can try
INDEX(
[ๆฌ้ในใใผใฟใน],
COUNT(
[ๆฌ้ในใใผใฟใน]
)
)
as the App Formula of [้ ้ใฎ็ถๆณ].
Thank you very much!!
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |