Toggle values

Answered

Follow

Prakesh Chand

March 18, 2019 03:06

Hi, very new to this but the tool is really good.

I am trying to update 2 pages from same worksheet, 1 page needs to have Toggle to update other fields but the second does not! However, when in app mode I change over selection via toggle, the second sheet changes to n/a values.

I may be doing something wrong so some guidance would be great.

0

• Official comment

  

  Damian Roller March 18, 2019 08:35 (Edited March 18, 2019 08:35)

  Dear Prakesh.

   

  An error of this type indicates that the value could not be found in your data source.
  So you have a selection field in the Excel / App and if you select a value there, a suitable result will be displayed in another cell, correct?

   

  If the result is not displayed, it can have several reasons. Please have a look at this article to find out what to look out for in Excel. Especially interesting will be point 11 with the unsupported formulas. Do you use one of them? https://support.openasapp.net/hc/en-us/articles/209427425

   

  How is your toggle configured? Are you using the data validation to cells in your Excel (https://support.office.com/en-ie/article/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249)

   

  Hope we can solve the problem.

   

  Best regards,

  Damian

  Comment actions Permalink

Please sign in to leave a comment.