BGUK Create Table
Gaev Keeka
Desktop
False
800
600
False
False
False
WebApp
False
en
[AndroidOS,iOS,WindowsPhoneOS]
normal
True
True
False
True
True
False
False
True
False
False
TopCenterApp
22px
25px
750px
431px
[loadedJSON]
22px
468px
153px
35px
Load JSON
LoadJSON "https://www.dovesoft.uk/visualneo/multirecord.json" [loadedJSON]
622px
466px
149px
40px
Go to Page2
GotoPage "Page2"
30px
471px
241px
35px
Remove Array Wrapper Characters
... remove [ and ] ; visualNEOWeb has bug, so do it with javascript
BeginJS
var sourceString = $App.loadedJSON;
var mydataString = sourceString.replace("[", "");
var mydataString = mydataString.replace("]", "");
$App.loadedJSON = mydataString;
EndJS
...AlertBox "loadedJSON" "[loadedJSON]" ""
278px
472px
144px
36px
Show JSON Strings
... convert strings of data within { and } to an array
StrParse "[loadedJSON]" ", " [loadedStringArray]
... how many arrayitems ?
ArrayLen [loadedStringArray] [loadedStringArrayLen]
...AlertBox "Array Length" "[loadedStringArrayLen]" ""
... [lastItem] is length -1 (array item numbers are zero based)
SetVar [lastItem] [loadedStringArrayLen]-1
Loop 0 [lastItem] [thisItem]
SetVar [thisArrayItemString] "[loadedStringArray([thisItem])]"
AlertBox "Item String [thisItem]" "[thisArrayItemString]" ""
EndLoop
621px
466px
149px
40px
Go to Page3
GotoPage "Page3"
16px
32px
762px
429px
150px
469px
128px
34px
Create Table
... Reset any previous column definitions
neoTableResetColumns "BasicTableContainer"
... setup columns; IMPORTANT: column numbers MUST start at 1
neoTableSetColumn "BasicTableContainer" 1 "id" "Id" "" false false false ""
neoTableSetColumn "BasicTableContainer" 2 "fname" "First Name" "" false false false ""
neoTableSetColumn "BasicTableContainer" 3 "lname" "Last Name" "" false false false ""
neoTableSetColumn "BasicTableContainer" 4 "email" "Email Address" "" false false false ""
neoTableSetColumn "BasicTableContainer" 5 "gender" "Gender" "" false false false ""
neoTableSetColumn "BasicTableContainer" 6 "ip_address" "IP Address" "" false false false ""
... define user permissions
neoTableInitTable "BasicTableContainer" "" 0 "Table" false false false false false ""
... load Data
neoTableLoadData "BasicTableContainer" [mydata]
16px
470px
130px
32px
Create mydata
CreateEmptyArray [mydata]
Loop 0 [lastItem] [thisItem]
SetVar [thisArrayItemString] "[loadedStringArray([thisItem])]"
...AlertBox "Item String [thisItem]" "[thisArrayItemString]" ""
ParseJSON "[thisArrayItemString]" [thisArrayItemJSON]
ArrayAddItem [mydata] [thisArrayItemJSON]
EndLoop
AlertBox "All" "Done" ""
0px
0px
800px
600px
False