neoGSheets Sample App
neoGSheets
SinLios
1.0
neoGSheets Sample App
[age],[current],[mydata([current]).Age],[mydata([current]).apellidos],[mydata([current]).edad],[mydata([current]).Name],[mydata([current]).nombre],[mydata([current]).Surname],[mydata(0)],[mydata],[name],[surname],[total]
True
1024
550
False
False
False
WebApp
False
C:\Users\sinli\Documents\VisualNeoWeb\Libraries\img\default-icon.png
en
#000000
[AndroidOS,iOS,WindowsPhoneOS]
normal
True
True
False
True
True
False
False
True
False
False
ArrayLen [mydata] [total]
.The array index 0 stores the field names.
SetVar [total] [total]-1
SetVar [name] "[mydata([current]).Name]"
SetVar [surname] "[mydata([current]).Surname]"
SetVar [age] "[mydata([current]).Age]"
SetVar [comment] "[mydata([current]).Comment]"
Refresh
ArrayLen [mydata] [total]
.The array index 0 stores the field names.
SetVar [i] 0
LoopObject [name] [mydata(0)]
SetCompVar [miname[i]] "[name]"
EndLoop
SetVar [total] [total]-1
SetVar [name] "[mydata([current]).Num]"
SetVar [surname] "[mydata([current]).Code]"
Refresh
SetVar [current] 1
SetVar [total] 1
368px
57px
384px
232px
368px
297px
384px
48px
Load Data From Google Sheets Into a Table
SetVar [googleSheet] "https://docs.google.com/spreadsheets/d/15opsxPVzmeZSuLQOB0WqN2K4rcc1e_6HSnIvreVMdek/edit?usp=sharing#gid=0"
.get all columns and order by age
neoGSheetsLoadAsTable "Container3" "[googleSheet]" "order by C" ""
24px
409px
232px
64px
[cellData]
24px
17px
328px
272px
150px
56px
160px
96px
[name]<br>
[surname]<br>
[age]<br>
[comment]
14px
56px
136px
96px
Name:<br>
Surname:<br>
Age:<br>
Comment:
30px
212px
256px
24px
[current]/[total]<br>
0px
0px
328px
40px
Get the data in an Array of Objects
768px
57px
232px
232px
[days]
[theday]
False
768px
297px
48px
48px
ES
SetVar [googleSheet] "https://docs.google.com/spreadsheets/d/1QgNDjNY8qsaBhU7XDNjE9WWOXayftOgPykJaxvJfVtY/edit#gid=0"
neoGSheetsLoadColumn "[googleSheet]" [days] "a" ""
830px
297px
48px
48px
EN
SetVar [googleSheet] "https://docs.google.com/spreadsheets/d/1QgNDjNY8qsaBhU7XDNjE9WWOXayftOgPykJaxvJfVtY/edit#gid=0"
neoGSheetsLoadColumn "[googleSheet]" [days] "b" ""
892px
297px
48px
48px
FR
SetVar [googleSheet] "https://docs.google.com/spreadsheets/d/1QgNDjNY8qsaBhU7XDNjE9WWOXayftOgPykJaxvJfVtY/edit#gid=0"
neoGSheetsLoadColumn "[googleSheet]" [days] "c" ""
952px
297px
48px
48px
DE
SetVar [googleSheet] "https://docs.google.com/spreadsheets/d/1QgNDjNY8qsaBhU7XDNjE9WWOXayftOgPykJaxvJfVtY/edit#gid=0"
neoGSheetsLoadColumn "[googleSheet]" [days] "d" ""
368px
17px
384px
40px
Get the data in a HTML table
768px
17px
232px
40px
Get column data in Array
24px
297px
328px
48px
Load Data From Google Sheets
SetVar [current] 1
.Load a Public Google DataSheet Data
SetVar [googleSheet] "https://docs.google.com/spreadsheets/d/15opsxPVzmeZSuLQOB0WqN2K4rcc1e_6HSnIvreVMdek/edit?usp=sharing#gid=0"
neoGSheetsLoad "[googleSheet]" [mydata] "select A,B,C,D" "mysub"
24px
369px
232px
40px
Get cell data in Variable
24px
481px
232px
48px
Load Cell Data
SetVar [googleSheet] "https://docs.google.com/spreadsheets/d/15opsxPVzmeZSuLQOB0WqN2K4rcc1e_6HSnIvreVMdek/edit?usp=sharing#gid=0"
neoGSheetsLoadCell "[googleSheet]" [cellData] "a" 1 ""
280px
369px
720px
136px
<strong>Public Google SpreadSheets:</strong><br>
<a href="https://docs.google.com/spreadsheets/d/15opsxPVzmeZSuLQOB0WqN2K4rcc1e_6HSnIvreVMdek/edit?usp=sharing#gid=0">Google SpreadSheet 1</a><br>
<a href="https://docs.google.com/spreadsheets/d/1QgNDjNY8qsaBhU7XDNjE9WWOXayftOgPykJaxvJfVtY/edit#gid=0">Google SpreadSheet 2</a><br>
<br>
<strong>Translations done using Google SpreadSheets translation function:</strong><br>
=GOOGLETRANSLATE(A1;"es";"en")
768px
481px
232px
48px
Reset All Data
danger
SetObjectHTML "Container3" ""
SetVar [cellData] ""
CreateEmptyArray [mydata]
CreateEmptyArray [days]
SetVar [name] ""
SetVar [surname] ""
SetVar [age] ""
SetVar [comment] ""
SetVar [total] 1
SetVar [current] 1
0px
0px
1024px
600px
False