⚙️ AppSheet Build Steps
✅ Step 1: Start App
- Go to AppSheet
- Choose: “Start with your own data”
- Select the Google Sheet with the two tables above
✅ Step 2: Table Settings
- Add both Members and Transfers sheets as tables
- Enable auto timestamp for Transfers[Timestamp] using AppFormula: NOW()
✅ Step 3: Views
A.
Members
View (Table)
- Columns: Phone, Credits
- View type: Table or Deck
- Name it: “Balances”
B.
Transfers
View (Table)
- Columns: FromPhone, ToPhone, Amount, Timestamp
- View type: Table
- Name it: “Transfer History”
✅ Step 4: Credit Transfer Form (optional for future)
If you later want users to send credits, we can:
- Enable a form view to submit rows to Transfers
- Use Bots to:
- Subtract credits from sender
- Add credits to receiver
✅ But for now: read-only, public info only
✅ Step 5: Make It Public
- Security → Turn user sign-in OFF
- Set Members and Transfers tables to read-only
📱 Final Public App Features