Announcements
Hello's,
I have an app with an input field restricted to just numbers. However I also want to stop users from putting in a % symbol as it just converts their value which is not desired once the form is submitted.
Is there a way to stop this input being allowed, or the best method to remove it before the form submits please?
thanks
Thanks @PowerAddict, but this doesn't appear to work.
I've tried adding Substitute(DataCardValue7.Text, "%", "") to the OnChange property of the input box, which didn't work so I also tried having it on OnSelect property of the submit button such as Substitute(DataCardValue7.Text, "%", "");SubmitForm(form1) but this also still didn't work.
Possibly I'm doing this in the wrong place?
The input box format property is set to Number, not text
Yep, the TextInput is inside a form. The Textbox is set to numbers only (but it still allows %)
This submits to a sharepoint list using SubmitForm. (never used patch before)
Problem being is multiple users use this some record a % some record actual value. I am looking to only submit a number/value and I'll deal with % further down the line.
Perfect @PowerAddict thank you so much for your help. I would never have thought to look at that Update property!
@PAM-thrive
I know this thread is already solved but would changing the Format property of the Text Input to Number be a valid solution here too? This would ensure no letters or symbols would be allowed.
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
@mdevaney unfortunately that doesn't help.
The format is already set to Number, and this format does appear to support % symbol.
Interesting I tried to apply the same fix above, to another app that does similar things, but there is no "Update" property. From what I read this is somehow related to the tables unique identifier.
I had no idea about that behaviour. Thanks for enlightening me 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 324 Most Valuable Professional
11manish 193
Valantis 138
