Skip to main content

Search

Search

Serialization With Prompt Dialog

Comments

4 comments

  • Avatar
    Legacy Poster
    I thought setting it to prompt "Every Record" would do this, but apparently not. That must only apply to databases.

    I have written a script that allows you to do 5 boxes all at once for 5 labels (attached). Maybe you can use that method as a workaround, or maybe not.

    [attachment=148:5 Boxes.btw]
    0
  • Avatar
    Shotaro Ito
    You can prepare a dummy table and use SQL TOP function with query prompt to get required rows of dummy record.

    Create a dummy table like this(in this case, excel sheet "dummy.xls" Sheet1)
    [sql]NUM
    --------
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10[/sql]

    In Bartender, create database setup to connect database above.
    In database setup's SQL tab, enable custom SQL to set sql like this.
    [sql]SELECT TOP ?Q1 NUM FROM `Sheet1$`[/sql]
    Create a query prompt and name "Q1".

    If you create data entry(user prompt) for each record, make sure to it appears in every record, from data source's transform (prompt) property.

    Try attached format.
    Hope that helps.
    0
  • Avatar
    Legacy Poster
    Thanks for both for the kindly help. I really appreciate that.

    For nRyder,
    Your attachment jolted me some ideas to try on.Thanks.You can read the detail scenario below to further understand my current work.

    For Shotaro,
    Thanks.It really lighten me up.

    Actually,my case is actually sounds like this
    I have designed the label and prompt dialog.There is a textbox which requires user to enter for serialize number.If the user enters 4,mean we must print 4 labels,with 1 of 4, 2 of 4,...

    My prompt dialog consists of 2 part,the upper part and below part with some field textbox to fill in.I was thinking that when it prints out the first label,it will prompt out the dialog again with ONLY the upper part comes out, so that the users don't have to enter the data again because basically the below part data is all the same.

    Any ideas? Advice and help would be very appreciated much.Thanks for the patience with me too.
    0
  • Avatar
    Legacy Poster
    I have solved my issue.

    All i need is integrate Shotaro work to my current label. And for the prompt dialog, i set it to prompt "Every Record"
    on whichever textbox i need to input different info, so that it would prompt whenever serialize.

    Thank you very much.
    0

Please sign in to leave a comment.