Viewing of data from google Spreadsheets. Can somebody please help me?

[gabriel_goes_braga]

I'm doing a system of visualization of the informatios of an item by the reading of the item's barcode. I've being able to read the barcode and get the informatior from the google sheets(by using the google sheets API in the storage section) but when I try to present the info in the screen it goes wrong, the data is mix up and I can't find a way to relate the parts of infortation, for example ram memory to 8GB(it's computers informatios on the spreadsheet). My code and result are bellow, if someone can please help me that would be great.

[TIMAI2]

To start with:

could simply be:

(the same would apply to the LegendaData list)

For fetching all the cell data, it would make more sense to get the range data (A1:K1) and (A2:K2)

[gabriel_goes_braga]

Yeah, thanks. Gonna change now and teste the cell range

[TIMAI2]

Are you attempting to query your spreadsheet using the barcode scan result ?

[gabriel_goes_braga]

Actually I'm using the function PROCV(I'm still going to se other functions and if there's a better one, but this is the only one that I know for now), I have another sheet with the resto os the values, them in the Sheet1 there's the function that finds the info for me, then I read it and show it in the list view, the problem is that the size of everything is diferent so isn't gettind the ideia of data that I'm trying.

I'm Brazilian, that's why the information in the image is in portuguese and not english.

[ABG]

Here's a sample you can study for cross-sheet functions:

Logging Marathon Runner Checkpoints in Google Sheets

This sample is intended to show how to use Google Sheets aggregation functions like MAXIFS to summarize multirow log data into single line summaries. This sample uses the New York City Marathon as a base, though it probably can't scale to the 53,000 runners. It is based on three sheets: Checkpoints, a list of locations each runner must cross on his route Mileposts, a detail list of runner checkpoint timestamps Runners, a master list of runners, with identifying bar codes and stats Checkpoin…

and here's a sample of how to display sheets in YAML:

Browse Google Sheets in YAML format

This tutorial is meant to show an alternative way to display wide table data in portrait mode. It uses YAML. YAML is a data serialization language that is often used for writing configuration files. Depending on whom you ask, YAML stands for yet another markup language or YAML ain't markup language (a recursive acronym), which emphasizes that YAML is for data, not documents. This tutorial is browse-oriented, and centers around a value procedure that can take a table (row of rows) with a heade…