SOLVED

Forms - can one question's answers be restricted based on another answer?

Copper Contributor
I have a situation in which people answer how many vacation days the earned over a period of time.
I have a second question asking how many of those days they used.
Obviously they cannot use more days than earned.

Is there a way to have forms check this on its own.
I am using the rating type of question with 1 to 10 as possible answers.

Thank you in advance
2 Replies
best response confirmed by Ian_123 (Copper Contributor)
Solution

@Ian_123 no, there's no feature like that in Forms. If your users areall internal you could build a custom canvas app in Power Apps for your form and that would give you much more control over calculations, restrictions etc. But it's a much bigger learning curve than Forms.

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

Rob,
Thank you for your reply.
I am. Very limited on the programs. And services I can use (I get what I get kind of) so I won't be able to work with what you suggest but I appreciate your time!
Thank you
1 best response

Accepted Solutions
best response confirmed by Ian_123 (Copper Contributor)
Solution

@Ian_123 no, there's no feature like that in Forms. If your users areall internal you could build a custom canvas app in Power Apps for your form and that would give you much more control over calculations, restrictions etc. But it's a much bigger learning curve than Forms.

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

View solution in original post