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
        ------------------------------