Do this from scratch?

⚙️ 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

Leave a comment