I am seriously struggling with the basics here, so appreciate if someone can guide a noob towards the right base structure. To give some context, the idea that I am building is as follows:
Patient goes for a guided injection treatment for musculoskeletal injury.
Imaging clinician adds Patient Name and Patient Mobile Number to Airtable form embedded in site.
At specific intervals (day 0, 1, 3, 7, 14, 28) the platform will send an SMS poll asking about pain levels. The patient replies with a single number from 1-10. [this is done via Zapier and ClickSend]
Imaging Clinician can then receive report with Patient Name and Pain Scores or alternatively log in to site (planning to use Memberstack) to access their data directly.
You can see my pre-launch site (built in webflow) here - www.mobius.xyz
So the main base I have built is as follows:
and when patient replies I built the following base with records added via Zapier:
I think I have made a mistake by using Patient Mobile Number as the primary field for both, yes? So how should I construct this instead? I want to be able to record the pain scores for each patient for each day of the poll, as indicated by the # of days since the procedure.
I would ultimately like to be able to generate something like the following:
[note that this base is obviously FAKE NEWS because I can’t for the life of me build the damn thing!]
I then want to able to deliver that base (or should it be a view???) to a customer portal for each Imaging Clinician, which I plan to do via memberstack and webflow, but I’m a ways off yet!
I hope this makes sense! Can anyone help out someone who is completely lost? I will repay with good vibes and (internet) hugs!
many thanks in advance,
zac Structuring Bases for Pain Tracking App- noob alert! Structuring Bases for Pain Tracking App, very basic questions