Google spreadsheet data as list picker elements

Discuss
, ,
1

Hello kodars,
I am using google spreadsheet extension from app helper. I want to call username column data from google spreadsheet and set the data’s as list pickers elements. But It is showing this issue. I have to submit this application at my office to manage the field user report.

image
image876×501 31.5 KB

2

Two factors you should listen

  1. Check the data obtained from spreadsheet to your app or show us your spreadsheet screenshot. Your error shows it is not in list or csv row
  2. Another one instead of kist picker text or elements you have choosen enabled. See to that also
3

Thanks @Still-learning.It is working now.

blocks
blocks521×597 44.9 KB

4

I have one more query. How to get the row number from the value of a cell.

blocks 2

image

5
  1. First get all the values from the col.
  2. Then use index is in the list block to get the position of the item from the col list. It will give you the row number