Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Commander
3 years ago

Show a form in a form

I have a parent and child relationship.

Projects have many Monthly Summaries. On that monthly summary I have about 30 pertinent fields shown in a nice pretty grid on the form.

On my project, I want to show the most recent monthly summary. I can think of 2 ways:

1. Make a ton (about 30) summary fields filtering for the most recent summary. Then simply display them on my project.

2. Make a button to pop up and show the most recent summary. I can make a specific form to show only the fields I want.

My question is - can I somehow use a report link or other trick to show a specific form of a specific record, right on my parent? So if I want to display it right on my project I dont need to make 30 summary fields?

------------------------------
Mike Tamoush
------------------------------
  • it is possible to embed webpages on forms. But I think as part of the compromise on JavaScript security they found they had to block showing Quickbase forms within Quickbase forms.  Originally they blocked any webpages from displaying on forms and there was a lot of pain caused by that decision and they backtracked and realized that their security loophole had to do with QuickBase forms embedded in Quickbase forms.

    So I'm pretty sure the answer is "no" you cannot embed a Quickbase form on the QuickBase form anymore.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
  • BradLemke's avatar
    BradLemke
    Qrew Assistant Captain
    I did manage to get a 'child record form embedded into parent form' solution working a few years ago for my apps, though nearly every aspect of that solution has been deprecated.  This solution involved using the Iframe html tag in a formula rich-text field, which is unfortunately no longer allowed to be used.

    ------------------------------
    Brad Lemke
    ------------------------------
  • Hi Mike,

    I think this should achieve what you're looking for - create a formula URL field that points to a form displaying the information you want to embed and specify that this is embedded in the parent form as an iframe. If you append '&ifv=1' to the formula URL and create a form that only shows the information you're interested in, it should do the job with some experimentation on the size of the iframe.


    ------------------------------
    Jeremy Anson
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      Jeremy, does that solution require using the <iframe> tag in the URL formula?  Those are now blocked and if you try to put in a quickbase link and use the button to show as iframe a red message appears

      Sorry, you can't use redirects to Quickbase URLs


      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • JeremyAnson's avatar
        JeremyAnson
        Qrew Cadet
        No, although I've realised I've just tried this by adding the field in the child record, displaying a form showing information from the parent ... and there are other ways of doing this without creating multiple lookup fields.

        The formula is:

        URLRoot() & "db/" & [_DBID_AAA] & "?a=dr&rid=" & [Related AAA record] & "&dfid=10&ifv=1"

        In the display options for the field I've checked 'Embed as iframe in forms' and set the iframe size to accommodate the cut-down form. 

        I guess this should work at the other end of the relationship too as long as you have a record ID# to point the URL at.



        ------------------------------
        Jeremy Anson
        ------------------------------