Answered

Possible to force currency entered in increments?

Like (0) Share

Report

Posted on 4 Jun 2021 05:22:04 by asmith2

Hi all! I have a form that serves as a cash order. I have text boxes that update the SharePoint list with the amount of denominations they need. The denominations need to be in certain increments, however.

For instance,

Ones - increments of $1,000

Twos - increments of $2,000

Fives - increments of $5,000

Tens - increments of $10,000

Twenties - increments of $20,000.

I know you can test for a value in-between numbers, but I'm not sure how to enforce that when the number can be so many different options. I have an error box that I'm trying to implement this idea into the visible function. Anyone do something like this?

Categories:

Using Apps Using Formulas

All responses (5)

Answers (1)

asmith2 39 on 04 Jun 2021 at 13:16:19

Like (0)

Report

Re: Possible to force currency entered in increments?

Perfect, thank you!
v-qiaqi@microsoft.com on 04 Jun 2021 at 08:19:20

Like (1)

Report
Re: Possible to force currency entered in increments?

Hi @asmith2,

Do you means that you want to each Text input add increments based on the specific number?

Could you please share a bit more about the scenario?

I think the Mod() could achieve your needs.

I think you could set the OnChange property of each TextInput control as below:

If( Mod( Value(TextInput4.Text), 1000 ) <> 0, Notify( "Please incremented by the specific amounts!", NotificationType.Error ) )

Note that you could replace the 1000 within the Mod() function with another specific number as you expect.

Check if this could help you.

Regards,

Qi
Verified answer

zmansuri 6,048 Super User 2024 Season 1 on 04 Jun 2021 at 08:12:32

Like (3)

Report

Re: Possible to force currency entered in increments?

Mod will give you remainder. If remainder is 0 that mean is divisible by 100 and not error. If it is not zero then error.
You can customize this logic anyway you want
asmith2 39 on 04 Jun 2021 at 05:38:49

Like (0)

Report

Re: Possible to force currency entered in increments?

So the value entered needs to be incremented by the specific amounts under it. So the value in Ones must be in increments of $1,000. If a user entered $1,200 they'd get an error because that's not a $1,000 increment. It would only accept $1,000 , $2,000 , etc.
Bilakanti 1,226 on 04 Jun 2021 at 05:30:21

Like (0)

Report

Re: Possible to force currency entered in increments?

@asmith2 Can you send me the screenshot of what you are trying to achieve.