lora_installer

1. Create a Retool account

2. Create two databasaes via importing via .CSV

3. install_log.csv

4. joins_and_sends.csv

5. Create two apps by selection import from JSON

6. lora_installer.json -- Mobile app

7. lora_install_history.json -- Web dashbaord

Database import

All field default to TEXT some need to be INT4 and TimnestampZ

Import install_log CSV

Import joins and sends CSV

SQL update statement for setting joned and sent states

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';