Applying conditional rules to the spreadsheet widget.

  • Profile Image
    Lrgunter
    Asked on June 02, 2018 at 05: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?



    This is a re-post of a comment on How to Use the Spreadsheet to Form Widget

  • Profile Image
    luisvcsilva
    Answered on June 02, 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.g

    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.