I need help remembering how i did something previously that I inadvertently deleted ๐
Those who have been following know that I am new to AppSheet and application development as a whole but i'm trying to make test apps and learn as i go through tutorials.
Today's adventure has got me making some progress but I have hit a stumbling block. I previously learned to use the LINKTOFORM() function to pull data from the currently viewed record and send it to another form. I have used that to make some notes that should be linked back to the primary record by way of referencing, and i am probably not using the right words, so here's some pictures.
Here's what I am currently getting:
And unfortunately, it is not displaying the table like it was 15 minutes ago. I am unsure how or why this changed, but previous, it showed a list of records under the primary record containing the data where the same key value was present in both. Now all that is showing is the sign out record primary key(s) instead of a table with data that looked like this:
I am quite certain its because I have added a virtual column that simply returns a list, but for the life of me I cannot remember how I did it last time. I looked at the Facilities Inspection template for reference, and it seems to somehow be using this same REFROWS() method but it is getting usable data instead of just a list of keys.
I may not have provided enough information here, please let me know if additional info is needed to help me. I feel like I am missing a ref view or something.
Basically, what i want is, when i am viewing the detail record of my virtual test subject Dorthy, the records in the next screenshot be shown under the detail in a table view that is clickable to see the full detail of that record
Solved! Go to Solution.
UPDATE: Figured it out. Apparently I failed to make a certain column a REF data type at one point. Changing that created the inline view. Now I can edit the inline view to control how this is displayed.
EDIT: the "certain" column was the _patientIdentifier column in the secondary Patient Encounter Records table. Once I made that a ref, it created the inline view for the patient detail to access.
okay, this is insane... I take a break to get some lunch and think this over, and now without me changing ANYTHING, its magically working again....
So now, the question is, how do I format this view to only display certain columns?
UPDATE: Figured it out. Apparently I failed to make a certain column a REF data type at one point. Changing that created the inline view. Now I can edit the inline view to control how this is displayed.
EDIT: the "certain" column was the _patientIdentifier column in the secondary Patient Encounter Records table. Once I made that a ref, it created the inline view for the patient detail to access.
User | Count |
---|---|
18 | |
13 | |
8 | |
4 | |
2 |