Forum Discussion

KatherineOakey's avatar
KatherineOakey
Qrew Member
5 years ago

Adding up to 4 child images when parent ticket is created

I have a form to create the parent ticket record. At the same time, I would like to be able to optionally add up to four images.  Currently I have an Image table which is the child of the Ticket pa...
APIs and custom code
Forms
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
If you post the formula for your [Add Image]  button, I will fix it so that you land back on the parent.

As fort limiting to 4, what you do is to go the relationships and make a summary field of the number of images.

Then have a form rule to say

When  the # of images >= 4, hide [Add Image]​​

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
KatherineOakey's avatar
KatherineOakey
Qrew Member
5 years ago
Here is the formula URL for the Add Image button.

Got it on the summary field to count number of images and then add a form rule to limit to four.  I like this as we can either limit to four or depending on role, unlimited.

Still many holes I am working through but getting a bit less painful :)

------------------------------
Katherine Oakey
------------------------------
  • KatherineOakey's avatar
    KatherineOakey
    Qrew Member
    5 years ago
    Sigh - no edit...

    The formula URL 

    URLRoot() & "db/" & [_DBID_IMAGES] & "?a=API_GenAddRecordForm&_fid_12=" & URLEncode ([Record ID#])& "&z=" & Rurl()

    ------------------------------
    Katherine Oakey
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      That button sure looks like it should return to the launch point, like the Parent Record. Are you sure it doesn't.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • KatherineOakey's avatar
        KatherineOakey
        Qrew Member
        5 years ago
        I think I am missing something obvious.

        Fill out the parent form and click the 'Add Image' button.

        Takes me to the form to add an image.  I add the filed and click Save and Close.

        I do end back at the parent table but the form isn't visible.  As soon as I stopped the test in the EOTI role, the form displayed.  So, I think I may have messed up how the EOTI role is accessing the form(s).

        When the parent form is initially accessed, it is in Add.  When I go back to the form from the Image add, am I in Edit and I need to set up the same form for Add as for Edit in Set how different roles use these forms?

        ------------------------------
        Katherine Oakey
        ------------------------------