Skip to Content
author's profile photo Former Member
Former Member

Hiding a single row in a table using form calc

I am new to adobe and development and I have a requirement where I need to hide a single row based on a value of 0.00 in a table. I have used the scripting form calc, when I assign it at the subform level everything nothing below is populated. Then I assigned it at the data level of the table and it removed all of the data that flowed from the table. The header line was still populated. What I am wondering is what I have done incorrectly or need to change so just the single record with the "0.00" value does not show.

if ( ZCUST_AR_OUT.DATA[*].TOTAMT == 0.00 ) then

$.presence = "hidden"

else

$.presence = "visible"

endif

My Expectation is that the row1 below would be hidden.

Example

Invoice Number Invoice Date Due Date Project No Project Name Balance Due

90000000 12/05/2014 01/05/2015 140000 Test 0.00

90000001 12/04/2014 01/04/2015 140001 Test 2 1.00

This is what shows with my calc

Example

Invoice Number Invoice Date Due Date Project No Project Name Balance Due

Above as just an example as there are other calculations that I am doing where I need the info to be there just hidden.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2014 at 12:02 AM

    The solution for my issue was that I had the form calc positioned at the table data properly but the "[*]" had to be removed. Once I removed the [*] the presence = 'hidden" command worked for the specific record.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.