-
Create a Retool account
-
Create two databasaes via importing via .CSV
-
install_log.csv
-
joins_and_sends.csv
-
Create two apps by selection import from JSON
-
lora_installer.json -- Mobile app
-
lora_install_history.json -- Web dashbaord
All field default to TEXT some need to be INT4 and TimnestampZ
UPDATE joins_and_sends SET status='joined', joined_at='2023-12-19 08:48:33.534660834' WHERE dev_eui='AABBCCDDEEFF0011'; UPDATE joins_and_sends SET status='sent', sent_at='2023-12-19 08:54:23.534660834' WHERE dev_eui='AABBCCDDEEFF0011';