Listpicker can't show data while use 2 web component to edit spreadsheet

[ABG]

This is the full contents of the sheet:

"Timestamp ","Batrei ","Tombol ","Manset "
"01/08/2024 8:19:22","Belum","Sudah","Belum"
"01/08/2024 8:19:22","Belum","Sudah","Belum"
"01/08/2024 8:21:51","Belum","Sudah","Belum"
"01/08/2024 10:36:47","Belum","Sudah","Belum"
"01/08/2024 10:44:08","Belum","Sudah","Belum"
"01/08/2024 14:41:27","Belum","Belum","Sudah"
"02/08/2024 14:19:11","","",""
"02/08/2024 14:26:23","Belum","Sudah","Belum"
"03/08/2024 8:06:37","Sudah","Belum","Sudah"
"03/08/2024 8:29:05","","",""
"03/08/2024 8:29:08","","",""
"03/08/2024 8:29:08","","",""

from

Google Sheets

It has one header row.

So why do you remove 4 rows in WebRead.GotText?

[Rod_Rushter]

so sorry, i think it's from "spreadsheet's url of the form", its different link with webread url

[ABG]

(Canned Reply: ABG- Export & Upload .aia)
Export your .aia file and upload it here.

[Rod_Rushter]

here it is
Maintenance.aia (8.9 KB)

[ABG]

In web maintenance got text you need an extra variable to hold your list of Elements. Do not send output into input.

[Rod_Rushter]

is anything wrong from this? while i running this program, this error appears

i think it because the url is a google form

[TIMAI2]

Maybe we need to understand what you are trying to do first.

Please write down in order the process you are trying to follow, e.g.

1. Get all data from spreadsheet
2. Select item from data
3. Send new data to spreadsheet with google form

and so on

[Rod_Rushter]

i want to make a maintenance history, so this is my plan

1. Scan barcode to get serial number then connect it to webread
2. Get device identity data from spreadsheet in webread (serial number, name, date)
3. Send done/undone to different spreadsheet with google form (webmaintenance => This form contains maintenance of the tool)
4. At the end, i want the view of spreadsheet maintenance history is like this:
   

but my code just a trial to send the parameter of maintenance. i'm sorry, i hope my explanation is easy to understand

[ABG]

I am finding it hard to debug apps that use Google Forms to feed sheets, from the perspective of a non-owner.

The sheet ID embedded in a Forms URL does not yield a CSV dump for me.

Did the place that showed you how to use Forms to feed a sheet also show how to debug that technique?

sheet_dump.aia (3.2 KB)

If you can get past the .json file I find the native AI2 component easier to debug.

[ABG]

FAQ Section: Google Sheets

AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Creating a Credential for Google Sheets - @Gordon_Lu Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web Services section of FAQ) Google Sheets compendium - SteveJG Export CSV data to Google Sheet - …

[ABG]

This is wrong.

After you extract the table into listpickdata, use the advanced list block Make A New List From Other List to feed the Elements directly, no loop needed and no temporary list needed.

(From my phone)

P.S. Don't excrete where you eat
Nor extrude, it's rude
Your plate is not a toilet

[Rod_Rushter]

i get the tutorial form this site

METRIC RAT AI2 - Use AI2 to directly submit Google Form Data

and there isn't show how to debug it
But, when i try this technique without combine it with the webread, the application is doing well

[ABG]

This is how you might load Elements from column 2 of a newly arrived CSV Table.

I unfortunately do not have a sheet ID for the table loaded by your Form, so I can't demo it against your maintenance History sheet.

The sheet ID used to process the Form is different from the sheet ID for the sheet that accumulates all the Form data.

I added a third Web component for access to the Maintenance History sheet. It is necessary if you want to read that sheet.

[TIMAI2]

What data (show an example) is in your Webread spreadsheet?

[Rod_Rushter]

this is the data in webread

[Rod_Rushter]

thank you for your help, i'll try it first

[TIMAI2]

I presume you are not getting the qrcode image back....

[TIMAI2]

I have setup an example aia project, spreadsheet and form for you to look at and hopefully use as a template. The spreadsheet has two worksheets, one for the product listing, the other for the form submissions. You need to keep these as plain columns and rows, no sub headings, merged columns.
The google form is linked to the second worksheet: MntceResponses, form submissions will be placed and shown here. The spreadsheet is set to "Anyone with the link can view". I left out the barcode images, might be better to provide a url for these.

The aia project has three functions:

1. GetProductData
   This will return all the data in the first worksheet: Products.
2. SubmitMntceData
   This will submit data from the five textboxes to the google form, then on to the second worksheet:MntceResponses
3. GetMntceData
   This will return all the data from the worksheet:MntceResponses

I have used three web components to keep things simple (you could use just one if you used action variables)

BLOCKS

AIA
mntceDB.aia (3.4 KB)

SCREEN

SHEET

MntceDB

FORM

MntceDB

You should be able to use the aia to read and submit data.

I hope this helps.

[Rod_Rushter]

Thank's a lot for your help, it works in me, thank you