Make an update with spread sheet taken from a listview

@Spicy_Topics I would like to update colum A "status" yes all the items in the spread sheet are seend from the app. and some other user needs to see the information send and needs to make and change in the row.

two differnt person needs to use the one who send the information and the one who manage the information

hmmmm.....

image

from

which is where all of this started :wink:

1 Like

You want selected item from list view need to update or all lists showing in the list view need to update?

Yes, this is what i am suggesting.. Because update mean user need to change something but ine aia there is no plae for editing also the datas are not in list thats why it is not get updated...and nothing else

only one item

for this part to feed the spreadsheed is already donne

image

and It works with out problems

and for the fiters also work but as far as I understand because the filters has many elements theres is no way for the select update to see which item we need to update

and just for that your advise is to make different list view to only select the Item that we want to update ?

wit let me redesign there by you can send update just in another way

This is nice but you know the issue is that the screen to feed the spread sheet , needs to be different from the screen to select this item in a list view and to filter and update those items

If you could do it to help me I will really appreciate it . you know because it is not just make the update is either select rows and delated :roll_eyes:

you know could be that the only solution for this is to use a code to make the filters with SQL

because when I did this exercice with a read code in apps script it works fine , the dificulty started when making the filters with gviz query

Now i have understand your needs completely .. half a way solved.. wait a min

:sweat_smile: jeje

had some work.. time being i have updated the aia.. pls see to this..

@Arturo
SMO.aia (244.0 KB)

For updation, once update over again i made into show udated records in list view in this version
SMO(1).aia (244.1 KB)

1 Like

Wow :flushed: thanks for your efort and time let me check it i go back give me 5 min

Dear @Spicy_Topics , it works find for the update just the message the record is update is for some seconds but I know we can fix this the only thing is for the delate it show a message after do it, let me show you the message
image

do know how can fix it :bowing_man:

no i didnt work for delete.... and in the web got text use one more else if and use just like what i have used for record updated..

Dear @Spicy_Topics sure I will do it and Just really thanks again I am your fan

and is there way to compensate you just let me know

with your asistance I can just continue working you already helped me to cross the obstacle

1 Like

now dele working fine.. see your sheets, i have deleted few items without error

pls use formula here and dont enter number by hand

image

If you use header then use =ArrayFormula(if(B:B<>"",row(A1:A)-1,"")) in I1 cell

SMO(2).aia (243.7 KB)

if you array formul and even if you delete any row serial number will be adjusted.. Our update function purely depends upon rowid

1 Like

Thank you for your nice reply.. Our community is always ready to help for the needy peoples.

ok, I put the formula but it doesn't work

image

do I need to do one adcional thing ?

dear @Spicy_Topics me again

Working with the app I found another an issue, let me explain to you in order to find the way to resolve the issue.

the information send to feed the spreadsheet needs to be send for the also with the app.

is there possible to send one IDROW for every sent in order to have this information and we could make the updates or the delates ?

image

I think in make somthing like this but it doesnot work, it shows me always the same value

image