Hi.I have created a document form called “ItemInventory”.
I have also created another form, as a response to the first form, called “ItemResponse”.
I would like to create a view that only shows “ItemInventory” documents which have an associated “ItemResponse” document underneath them.
Is it possible to do this with a view selection formula?
Thanks,
Richard.
Subject: yes and no
not natively. you’d need to add a field on your main document that indicates whether it has responses. you could set the field either when any response is created or you can use a scheduled agent to populate the field.
Subject: I’ll probably use a field
Thanks for that, Paul.I’ll probably just use a field as you suggest.
Obviously the field will still indicate a response doc is present if a response is created and then deleted, but I’m not sure that will be a problem in this case.
I’ll have to think about this more carefully.
Thanks a lot.
Subject: you just need to code it correctly
you can use the QueryDocumentDelete event to capture any deletion attempts and lookup the associated parent doc and update the field.