Eric,
Thanks for the response. I am still new to quickbase, so trying to learn as much as I can. Any response helps.
So I think my solution is a few parts, and I want to be able to combine them all into one button, if possible.
I believe I have some of it, but am still struggling with the other parts.
Currently the user opens a new Work Order fills in any needed data, clicks the "Add Job" button, the Work Order record is saved and the user is taken to the Job form. On the job form, the user inputs information for the job, and then in the assignments editable embedded report, enters additional information. They click the Save & Close button, the Job and related assignments are saved, and the user is taken back to the parent work order in edit mode to continue if needed. That process flow is smooth and what I would like to maintain, if possible, or at least as close to that as is possible.
Issue:I need to bring down a related client from the parent record (Work Orders) to the child record (Jobs). That related client also has to be brought down to the grandchild record (Assignments). All this is to allow a Contacts list in the grandchild record to be conditional based upon the related client, and show only the related contacts to that related client. The grandchild is an editable embedded report in the child form. The Child and Grandchild being Parent and Child.
In order to have the related client flow down from the child to the grandchild, the child record has to be generated/saved first. Then for the related client to populate in the grandchild record so that the conditional contacts list functions, the grandchild record also has to be generated/saved first too.
It breaks the process flow to require a user to enter some data, save, go back and edit, enter some more data, save, go back and edit, and then save again.
Solution:I think that I have a solution, but I am only part way there.
My Jobs form didn't incorporate the default "Add Assignment" button because the embedded report is editable.
However, I think that I will add it and edit the code in it.
When clicked, I need it to do the following:
- Generate/Save the Job form
- This will allow the related client to be brought down to the Job, and in turn eventually to the assignment
- Generate/save a new assignment related to the Job
- This will allow the related client to be brought down to the assignment, and in turn allow the conditional contacts list to function properly.
- Take me back to the Job form in edit mode so that I can continue making any changes as needed.
One caveat is that in doing this, I need to ensure that I maintain the return path back to the Parent (Work Order) record, so that when I click on Save & Close in the Job form, it saves and then takes me back to the work order in edit mode.
The code I have thus far is the following:
URLRoot() & "db/" & [_DBID_ASSIGNMENTS] & "?act=API_AddRecord"
& "&_fid_6=" & URLEncode ([Job ID#])
& "&rdr=" & Dbid()& URLEncode("?a=er&rid="&[Job ID#])
This is in the Job form, generates a new Assignment and keeps me in the Job form in edit mode.
What it is lacking is saving the Job first (then doing the above), as well as maintaining the return path to the Parent record in edit mode.
I am currently reading through the API guide to get a better understanding of the calls and syntax, as well as messing around with the "URL Formula Buttons for Dummies" app by Mark Shnier, and also wrapping my head around the "Magic Buttons - Having Fun with Formula URLs" app by Kirk Trachy.
If you have any suggestions, thoughts, input, ideas, etc., it is very welcomed!!
P.S. I will have to check out those Empower sessions you recommended.
Too much to absorb, not enough time!! hahaha lol
------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------