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?
Solved! Go to Solution.
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.
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.
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications