Applying conditional rules to the spreadsheet widget.

  • Lrgunter
    Asked on June 2, 2018 at 5:09 AM

    I need to evaluate the a field that is filled from the spreadsheet file. Based on its value, I will show or hide more information. It seems like the field is not being evaluated.

    What am I doing wrong?

  • luisvcsilva
    Replied on June 2, 2018 at 10:34 AM

    Hi, unfortunately Jotform is not able to apply conditional rules to cells within the spreadsheet. What you can do is to apply conditional rules to the string associated with the current state of your spreadsheet, as shown by the screencast below:

    1527949876GIFrecord 02 06 2018  102949 Screenshot 10

    As you can see, I created a condition that tells me whenever there's a cell filled with the string "apple" in the spreadsheet. This can be extended to compare spreadsheets or check if your spreadsheet contains a value or not, comparisons using single cells,rows or columns is not possible yet.

    If we misunderstood your question or you need further assistance, don't hesitate in contacting us.

     

    Thanks.