Second form has fields greyed out unless first form has one record selected in record picker
I have two forms in one document, the second form is executed as an action on a button in the first form. The first form contains a record picker. If I select a random item in the record picker then click the button, I can enter details on form two and only those details print (which is what I want). However I don't want to select a random record in the record picker each time. How can I get this to work correctly?
-
It sounds like you need to adjust the Show When option for the 2nd Form via Form Properties and then the button highlighted below:
0 -
I've tried changing to always, never or when a field is empty. Makes no difference. The trigger for form 2 is an action assigned to a button on form one for a new form.
If I tick a selection from the record picker, it brings it across to form 2 and I can edit it. If I don't tick a record, form 2 is displayed with record entries greyed out and uneditable.
I cannot get form 2 to be displayed unpopulated ready for a new entry.
0 -
I am guessing those fields are usually populated via a database value and so if none is selected there is nothing to edit.
Could you add a record called "Manual" into your database and select that when you want to choose that at print time?
0 -
Yes I could add a record in my database called ‘manual’ and select that. A bit awkward though as I’d have to search for it first then select it then click my button with the action attached to it.
Is there an action I could assign on opening form 2 that could get round having to do this?0 -
Basically what you are trying to do is print a non database label using a database linked label format and that is not possible as the database lookup/selection is always required.
It sounds like you maybe using a Record Picker to select the product required, have you thought about using a Filter (Query prompt) instead so the operator types in the search parameter and so this could include Manual as an option quite easily?
Alternatively you would probably need two label formats, a database and a manual label but you could create a "label" that does not print but just has two Action buttons on a Form, one for Manual that opens that label and one for Database that opens that instead using, say Print Station with just the two labels to choose from at the start would probably be easier
0 -
It is somehow retaining the record in it's memory from the last record selected in the first form, even if it was from an earlier print run. Hitting clear doesn't work. The only way to edit the entry is to select any record in the record picker and ascend it in form 2.
0 -
I added another label template and used fields with embedded data instead to link to the new form. However, it is still greyed out when I click on the button with the action to go to form 2.
0 -
Are you still trying to populate the second form and template without selecting a record first, since as mentioned above this will not work if you are using a database linked label format as you must select a record?
0 -
I've 2 forms and 2 templates. Form 1 and Template 1 are database linked. Form 2 I tried to populate Template 2 with embedded data only coming in from Template 2. Cn this not be done in one document?
0 -
No it would need to be a separate label.
0 -
working now thankyou
0
Please sign in to leave a comment.
Comments
11 comments