Adding up to 4 child images when parent ticket is created

Question

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 parent - Image child relationship.

Currently I have an embedded report on the Image table linked from the Ticket entry form. I successfully add the first Image record but I don't end back up displaying the Ticket parent add form so I can 'add image' again.

I don't know how to 'loop' on adding Image records and how to limit the number of Image records to no more than four images.

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

markshnier__you · Answer

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

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

Sigh - no edit...The formula URL&nbsp;URLRoot() &amp; "db/" &amp; [_DBID_IMAGES] &amp; "?a=API_GenAddRecordForm&amp;_fid_12=" &amp; URLEncode ([Record ID#])&amp; "&amp;z=" &amp; Rurl()------------------------------Katherine Oakey------------------------------

markshnier__you · Answer

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

katherineoakey · Answer

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. &nbsp;I add the filed and click Save and Close.I do end back at the parent table but the form isn't visible. &nbsp;As soon as I stopped the test in the EOTI role, the form displayed. &nbsp;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. &nbsp;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------------------------------

Forum Discussion

Adding up to 4 child images when parent ticket is created

Related Content

Display Thumbnail Image

Jinja Question: Adding business days to today

AI Smart Builder for Creating Apps and Streamlining Pipelines

Add button to create record in different app

create pipeline to create new records based on current record