Require a roll up $ value to be inserted into a Form

Collin S

Scenario: our Form has 5 different product categories that our partners will add $ values for applicable product categories. Unfortunately, our partners will submit the form will all of the other information without inputting any values. Thus, internal team will need to reach back out to partners to resubmit.

It is possible that a job has all 5 product categories or only 1 so we don't want to require each field because it may not be applicable.

I would like to insert a formula that rolls up the total list and if the value is not > $0 it locks down the form. I don't think the "lock down" is an option.

My best current solution would be a conditional field that rolls up values with a FLAG that statis Total List is $0, you need to insert a value. Once Total List is >$0, that conditional field disappears.

Is that the best/only solution. Thanks all.

Paul Newcome

Forms cannot do calculations like that. You would need to submit the form to be able to evaluate the data. You will need to either look into a 3rd party form option that has that capability, or you will need to send an automated update request to the submitter after the fact.

Collin S

Thanks for the response.