Create multiple entries in one request

[marun maon]

Hi all, is there any way for me to insert multiple text field entry for my table name from the form below? Right now user can input only one table name at a time and there is possibility user want to put multiple table name and i don't want user to use comma or semicolon to separate the table name as i will use this information to automate table migration. so if user want to put another table name, there will be new text field for table name thus if there is 5 different table name in the same request user can input into 5 different text field under Table name entry.

[Daniel Fietta]

Hi Marun,

How do you make sure that the users correctly spell the database tables and names correctly?

And how do you know which source table should be migrated into what destination table if you have multiple values?

As Nick mentioned, you could use a table for that where your target and destination database information are the columns and every table would have its own row. The field can either be a simple text field or a select list with pre-defined values. Check out our tables add-on: Tables for Jira

One other approach that I could think of is treating the source/target databases and tables as assets in Jira. By doing it with proper asset management, e.g. by using Assets - Advanced Links, you could have issue pickers in the create screen and users can only select existing databases and based on the selected database they can only select the tables that are actually available in those databases. This way you could also add some more logic to the selection.

Best,
Daniel
STAGIL

[sshankaranarayana]

You could explore the Labels field type instead of the Text field type when creating a custom field. That way multiple table names could be added as separate values.

  

Consult the screenshot to see if that is what you wanted to achieve. This was created by adding a custom field of type 'Labels' and name 'table name'. This field allows you to add multiple values. 

[marun maon]

Hi Sharvani,

Does the label will be save in the database? after i try to do this the values of the label is not in the database? is there any explanation to it?

Thanks,

Marun.

[Nic Brough -Adaptavist-]

Don't look at the database, it's not suitable for reporting or queries, you're wasting your time with it.

But, yes, the labels are stored in the database, that's where Jira stores its data.

[Nic Brough -Adaptavist-]

Jira does not have fields like that natively.

The closest you can get is the Table Grid Editor app (which isn't quite what you describe here, but captures the information your users need to add very well)