Hello everyone! I have a small issue on my app that Iโm working on. Bear with me as Iโm going to explain what it is.
My app is a database app gathering details of patients in our unit. Its parent table is the โPersonal Detailsโ table. It has multiple child tables referenced to it. So when the user fills out the personal details of a patient, user gets several referencing virtual columns linked to these child tables, so that the user can fill out the rest of the patientโs details separately (ie: โClinical Detailsโ, โBlood Investigationsโ, โImaging and Biopsyโ, โMDT Decisionsโ, โDiagnosisโ, โManagementโ etc.) and they get saved in different tables inside the main spreadsheet. This is the basic model of my app.
Now to give a background understanding of the problem Iโm havingโฆ
When the user goes to fill out the โImaging and Biopsyโ table, the user gets a drop down Enumlist from which the user can select any type of imaging. โDiagnostic ERCPโ is one such imaging modality. When the user selects โDiagnostic ERCPโ, the following columns appear - โDate of Diagnostic ERCPโ, โSummary of Diagnostic ERCPโ, โPost-ERCP Complicationsโ, and a virtual column for the โERCP Image Uploadโ child table so that the user can upload several images under ERCP. To get this to work, I have setup a child table called โERCP Image Uploadโ that is referenced to the โImaging and Biopsyโ table, so now the parent table is โImaging and Biopsyโ and the child table is โERCP Image Uploadโ. Inside the ERCP Image Upload table, I have set up an โERCPKeyโ column, an Image type column for uploading the image, and a ref type column called โDiagnostic ERCPโ, where I have selected โImaging and Biopsyโ as the ReferencedTableName, and I have set up the โIsAPartOfโ to โTRUEโ so that it creates that referencing virtual column inside the โImaging and Biopsyโ table. Since โImaging and Biopsyโ table is a child table of โPersonal Detailsโ parent table, inside the โImaging and Biopsyโ table, I have set up its own key column called โInBKeyโ and another column called โImaging & Biopsy_Refโ which is the Ref type column that is referenced to the โPersonal Detailsโ table. This is working perfectly for me as intended.
Now to the problem Iโm havingโฆ
As I told earlier, there are multiple other child tables referenced to the parent table โPersonal Detailsโ, and another such child table is โManagementโ table. Inside this โManagementโ table, the user gets to select whether the patient is being managed โsurgicallyโ or โnon-surgicallyโ. So if the user selects โNon-surgical managementโ, the user gets a virtual column referenced to a child table called โNon-surgical managementโ (now the parent is โManagementโ table and the child is โNon-surgical managementโ). Inside this โNon-surgical managementโ table, user has many non-surgical options to select, out of which โTherapeutic ERCPโ is one option. When the user selects this, the following columns show up - โDate of therapeutic ERCPโ, โSummary of therapeutic ERCPโ, โPost-ERCP complicationsโ (pretty much like when the user selects the โDiagnostic ERCPโ option from the โImaging and Biopsyโ table earlier). Just like with โDiagnostic ERCPโ inside the โImaging and Biopsyโ table, I wanted the user to be able to upload images under this โtherapeutic ERCPโ as well. Since I have already created an โERCP Image Uploadโ table referenced to the โImaging and Biopsyโ table earlier, I thought I should be able to use that same โERCP Image Uploadโ table for this as well. So I created a ref type column called โTherapeutic ERCPโ inside that โERCP Image Uploadโ table and selected the โNon-surgical managementโ table as the โReferencedTableNameโ to it and set โIsAPartOfโ to โTRUEโ inside that, so that I get an โERCP Image Uploadโ virtual column inside the โNon-surgical managementโ table when the user selects โTherapeutic ERCPโ. This too worked for me as I wanted!
BUT, since Iโm still working on in my app, Iโm making many changes to the app elsewhere, and whenever I make some other change to the app absolutely unrelated to what I told above, and everytime I save changes to my app, the โTRUEโ in the โIsAPartOfโ inside the โTherapeutic ERCPโ ref type column gets changed to โFALSEโ!! So inside the app, I donโt see the โERCP Image Uploadโ virtual column under โtherapeutic ERCPโ. But inside the โImaging and Biopsyโ table, the โERCP Image Uploadโ virtual column always appears, because the โIsAPartOfโ in โDiagnostic ERCPโ ref type column does not change to โFALSEโ like it does with โTherapeutic ERCPโ. So every time before I save changes to the app, I have to head over to the โERCP Image Uploadโ tableโs columns and REselect โTRUEโ for โIsAPartOfโ for the โTherapeutic ERCPโ Ref type column. Why does this happen?
Sorry for the long read. I wanted you to get an exact idea of the issue that Iโm facing, so I had to type in everything.
Happy New Year to all of you at AppSheet!
Letโs get this explanation little bit shorter:) You have TableC for images and you want this TableC would be a child table for two different tables, TableA and TableB. Correct?
@Aleksi_Alkio Exactly! Pardon the long explanation.
I was able to reproduce the problem with a test app. I need to talk with our developers if there is a reason for this behavior.
@Aleksi_Alkio Thank you. Hoping to hear a solution
At this moment this behavior is unfortunately by desing. If you like, you could request this from hereโฆ www.appsheet.com/feature-requests
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |