How to get google sheet row number

Discuss
, ,
#1

GS.

I used Recycler List View extension and get data from GS with GSAI2 extension. I got my data to spinner.

1655722495070
16557224950701080Ă—2340 107 KB

I want if I select GASKET ONLY get that row number or if I select GASKET HEAD SET get that row number like that. how I do it

#2

What have you tried so far ? How do you set data ? Post a screenshot or better a test aia

#3

Screen have 2485 block. Download Block as image not working. I already sent my aia last time to you. please give me a tips I want select CATEGORY and edit ITEM No. Can I send my aia again

#4

Send you aia again please

#5

my aia sent to you

1 Like
#6

I noticed that above image comes when you need to add a new item in inventory. If this is the case you don’t need row number because you will use append row block and row will created at the end of gsheet

#7

No. I want edit that row data. when I add new item append data in other sheet. see the image

GS new
GS new1358Ă—561 74.3 KB

GS

#8

when I add new item fill the “INVENTORY” sheet and update “CATEGORY_MASTER” ITEM NUMBER that I selected category in spinner

#9

See this, I made video for convenience presented what I want.

block
block742Ă—496 108 KB

This is category Master DB

category master DB
category master DB987Ă—634 65.1 KB

This is Inventory DB

inventory DB
inventory DB1017Ă—551 58.8 KB

I need when I add items to inventory, update Category item no. I did it manually enter row number, but I need get row number with spinner selection. see the video ( Item code )