ContributionsMost RecentMost LikesSolutionsGrid Edit in Quickbase Mobile App?I'm seeing whether QB could provide a questionnaire solution. I want my clients to fill out a questionnaire in the mobile app. The questionnaire has about 10 questions with multiple choice answers. When I created some Grid Edit reports, it looks like you can't open those in the mobile app (or at least, I was unable to figure it out). Is there a way to make a flow that is more like Jotform or Google forms where the user can select their multiple choice answer for the 10 questions on the same form in Quickbase mobile? ------------------------------ Solace Sonder ------------------------------ Re: How to pre-populate a grid addThanks Mark. I sent you an email. Would definitely be interested in learning this technique. ------------------------------ Solace Sonder ------------------------------ How to pre-populate a grid addWe have a series of labs panels composed of a series of lab tests that are put in the exact same way every time. I have a join table with patient and lab information. Patient X Lab A Test 1 Patient X Lab A Test 2 The ideal flow would be for a user to select the patient and the lab panel they want to add, and a grid edit/add would open with that patient, lab and test values already populated (in this case there would be two rows in the grid add, like the above mini table). Is this possible in QB? Again, we can script it, but the organization is non technical so trying to look for native ways as much as possible. ------------------------------ Solace Sonder ------------------------------ Creating multiple records in Table X from a QB Sync TableMy QB Sync table has a patient primary key and a multi-select field (although QB imports it as a text field) with hundreds of possible symptom values. I would like to make this into a join table between patients and symptoms with each record being one instance of a patient with that specific symptom. Is there any way to do this natively with QB? I can script it, but the organization I work with is not very technical, so it would be difficult to maintain. Much easier to maintain in a low code platform like QB. ------------------------------ Solace Sonder ------------------------------ Re: How to add a record to my join tableYes. I've tried a bunch of different configurations on this field. :( ------------------------------ Solace Sonder ------------------------------ Re: How to add a record to my join tableI completely understand, Mark. Thanks for the assist. Let's just focus on the #1 case. If we solve that, it will be good enough for a while. Here is the relationship/field structure in both directions. When I view a Patient record, all of this data populates properly. However, when I try to add a patient lab by clicking on the "Add Patient Lab" in the Patients table, this is what I get: Notice that Patient Primary Key is blank, despite this being clicked from the Patient record directly. Here is the URL formula for the Add Patient Lab: URLRoot() & "db/" & [_DBID_PATIENT_LABS] & "?a=API_GenAddRecordForm&_fid_26=" & URLEncode ([Patients Primary Key])& "&z=" & Rurl() Also, notice the Lab Primary Key is a read-only field. How do I create a lookup where the user can select from all Possible Labs which one they want? Normally I would think this would be done by a record picker, but it's almost like the URL for adding a Patient Lab isn't populating properly. ------------------------------ Solace Sonder ------------------------------ How to add a record to my join tableI have a many to many relationship between Patients and Labs. I have two questions: 1. How do I add a record to the join table (Patient-Lab) directly (and allow the user to choose which Patient and Lab to associate it with)? This seems very basic, but I cannot find the instructions to do this in the forum or in the help documents. I want the user to have the option to choose from a record picker the Patient and Lab they want to associate together. 2. How do I add a record to the Patient table that allows them to choose which lab they want to associate with this patient record? I need several values to populate in the record picker so the person entering in the Patient table will know which lab to associate. ------------------------------ Solace Sonder ------------------------------ Re: Create parent-child relationship when parent primary key is from composite key from syncI'm gonna open a support case just to see if this restriction is intentional and if there is some documentation on it. I'm gonna try to get around it by doing a full copy of the table through an automation and then assigning keys that way. ------------------------------ Solace Sonder ------------------------------ Re: Create parent-child relationship when parent primary key is from composite key from syncIt doesn't seem to: ------------------------------ Solace Sonder ------------------------------ Create parent-child relationship when parent primary key is from composite key from syncI have two tables, Patient sync (parent) and Labs sync table (child). The Primary Key of Patient sync table is a composite key Jane_Smith_janesmith@fake.com. This is created during the automatic syncing. The Patient Labs sync data has the first name, last name and email of the patient in it in 3 separate fields. I want to connect these two records automatically when they sync if those 3 fields match. When I try to create a parent child relationship, QB does not give me the option to set a reference field. It goes straight to a lookup field. I I configure the relationship, this is what I get, but the Related Healthie Patient field doesn't populate with anything because it is not the formula field from the lab child table. Is there some restriction on composite fields that I don't know about? Any suggestions about how to get around this and link these tables automatically during the syncs? ------------------------------ Solace Sonder ------------------------------