• Global community
• Language:
• Deutsch
• English
• Español
• Français
• Português
• 日本語コミュニティ
Dedicated community for Japanese speakers
• 한국 커뮤니티
Dedicated community for Korean speakers
Exit
• How to not calculate hidden fields

# How to not calculate hidden fields

New Here ,
Nov 28, 2022 Nov 28, 2022

Copied

I'm trying to total up the column total but I don't want the hidden fields to be in the calculation.

TOPICS
Adobe Sign forms , Web forms

Views

432

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
4 Replies 4
Nov 29, 2022 Nov 29, 2022

Copied

Thank you for reaching out.

Could you please confirm how you created the form? Are you adding a form field in Acrobat Sign?

Please confirm which field you are trying to calculate. Which areas are you referring to as hidden fields?

Thanks,

Meenakshi

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
New Here ,
Nov 30, 2022 Nov 30, 2022

Copied

Yes, I attached the link to the web form,

It's kind of hard to explain.

We are trying to show when a person clicks on a certain amount of days for renting our products that they will get a certain discount.  but we need to have at least 5 lines so that people can choose a different types of products

Dropdown Field

Child Kayaks \$145
Double Kayaks \$265

1-2 Days normal price

3-4 Days 25% off

5-6 Days 30% off

7+ Days 50% off

The only way I could figure out how to do that per line is to have 4 different fields in the total column overlapping them all and putting conditions to hide if those days aren't clicked in order to show the correct discount %

1-2 Days normal price  (QTY1 * Dropdown1 *Days1) Hide is Any Days1 is greater or = 3

3-4 Days 25% off  (QTY1 * Dropdown1 * Days1 * .75)  Hide is Any Days1 are less than or = to 2 & greater or = than 5

5-6 Days 30% off  (QTY1 * Dropdown1 * Days1 * .60)  Hide is Any Days1 is less than or = to 6 & greater than = 7

7+ Days 50% off   (QTY1 * Dropdown1 * Days1 * .50)  Hide is Any Days1 is less than or = to 6

The problem is that when I want to do a grand total field for the 5 lines it still calculates the hidden ones too.

Grand total [3-4 Days 25% off] + [5-6 Days 30% off] + [7+ Days 50% off ] + [1-2 Days normal price]

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
May 02, 2024 May 02, 2024

Copied

Hi,

thanks

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
May 03, 2024 May 03, 2024

Copied

LATEST

Thank you for reaching out.

For the calculation, please refer to the information in the following help document:  https://adobe.ly/3y3rgay.

If you can share the document once so we can have a look.

We have checked that you are using the Adobe Sign Enterprise plan. You may also contact our Adobe Sign Enterprise support team for the correct information. You may contact them using the steps in the following help document: https://adobe.ly/3waaHcD.

Thanks,

Meenakshi