LinkedIn
Twitter
That worked @Suvrutt_Gurjar!
Thank you so much.
There’s a small lag until the data gets saved and charts view grabs the new last row from the VC. So the user has to wait a bit until the charts change according to the last row the user saved, but that’s a small price to pay for the great analysis I can achieve! 
@Suvrutt_Gurjar
I haven’t fiddled around with user table and user settings still. I’ll have to learn about them first. In the meantime, I’m trying to figure out another way to do this other than using a virtual column, like creating a LINKTOFILTEREDVIEW action that will be triggered at the end of filling out the Analyser table’s form view.
LINKTOFILTEREDVIEW(“Full DB”,AND([OT Date]<=Analyser[_THISROW].[OT End Date], [OT Date]>=Analyser[_THISROW].[OT Start Date]))
This actually takes me to a table view with the relevant rows isolated very fast as it doesn’t depend on saving data to the Google sheet. The only issue is trying to feed these rows to the Charts from thereon. As it’s only a virtual table (for lack of a better word) made out of the physical “Full DB” table, it doesn’t have a foothold for me to feed it to the Charts. Or is there a way that I don’t know yet? 
Yes @Suvrutt_Gurjar, I am a surgeon, but doing this is my passion.
I found out about AppSheet just about a year and a half ago when I was looking for a solution to maintain an efficient surgical database through a mobile phone. I spent days and nights trying to figure out the expression language you all use in AppSheet. I wouldn’t have been able to learn this platform if you all don’t constantly do an amazing job like solving issues when ever we come across them. I have learned so much from you, @Steve, @MultiTech_Visions, @LeventK, @Aleksi and many others and for that, I’m eternally grateful.
Sri Lanka although it has a really good healthcare system in the government sector, still lacks proper patient database management systems in government hospitals. Doctors maintain patient data on paper that is always predisposed to illegibility, loss or irretrievability. So we are unable to maintain and retrieve patient data for research and audit purposes most of the time, especially at ward and unit levels.
I have up to now created 5 good apps that work as really good solutions to pertaining issues in my hospital.
- An HPB app to manage the huge number of hepatopancreaticobiliary (my specialty) cases we receive at our hospital from all around the country as ours is an HPB unit in a tertiary care hospital.
- A Urology cancer app that records data and does analysis on all the kidney, ureter and bladder cancers in our country which is a multistation app.
- A colorectal app that records and upkeeps colorectal cancer patients in my hospital.
- A surgical logbook maintenance app for surgical trainees to keep tabs on the surgeries they do, obtain printable CSVs from the app itself and analyze their data based on different surgeries and their complications etc. (I wrote a 150 page manual stating how to create the app for anyone who is interested and the manual contains all the expressions I used to create that app, and so far a lot of surgical trainees have managed to create that app by themselves sticking to the steps in the manual)
- The orthopedic app I was recently making which solves a major crisis in operation theatre list management, and postponed cases.
The College of Surgeons in Sri Lanka recognizing the work I did, invited me to do a guest speech at the Annual Surgical Congress last year, and I talked about AppSheet and how it empowered me to find solutions for the issues we come across to a gathering of so many surgeons in the country including surgeons from the Royal College of Surgeons in England who were present at the audience when I did this. None of that wouldn’t have been possible if it weren’t for all of you! My gratitude to you therefore is absolutely sincere! 
