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.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021