Hi Just wondering if there is an equivalent to excel’s RIGHT function inside Kobo/xlsForms? I want to extract the last 2 digits of a number entered by the user so that I can then use it further down the form in a concat calculation. I can ask the user to enter only the last 2 digits of the number…

Welcome, You may use the mod operator. AnyNumber mod 100 should give you the last 2 digits. For existing functions and operators you can always look here https://getodk.github.io/xforms-spec/#xpath-functions

Is it possible to use "RIGHT" function in calculate

User Support Form Building

Kal_Lam December 10, 2021, 7:56am 3

@the_barn8, this is how @wroos has advised you to do it:

Thank you @wroos for sharing this with the community!