Need dropdown choice from one table to be added to a new table with a click of a button | Community
Skip to main content
Level 5
December 29, 2021
Solved

Need dropdown choice from one table to be added to a new table with a click of a button

  • December 29, 2021
  • 2 replies
  • 2228 views

Good day,  I have a table which have dropdown lists within it. The table also have several buttons.  One of them is a button which adds a new blank table so that the user can choose whatever they like from the dropdown lists.  There are incidents where a choice from one of the drop down lists will be the same for multiple tables.  I do not want the user to have to choose the same choice every time they create a new table.  I would like the user to click another button which would add the additional table, and also keep certain choices selected in the previous table so that they don't have to choose it every time they create a new table.  Is this possible?  Just to elaborate more:  Example:  The table lists automobiles.  Within the table the user will need to enter 30 automobiles made by "Ford" but the automobiles have different models.  When the user chooses "Ford" from the drop down menu of the first table and enter all pertinent information, I want  "Ford" to be automatically entered into the next table when the button to create a similar table is chosen.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Mayank_Tiwari

Please check this form in which I have copied the value from the dropdown in one table to the other table, on the click of a button - "Copy".

 

 

 

 

2 replies

Mayank_Tiwari
Adobe Employee
Mayank_TiwariAdobe EmployeeAccepted solution
Adobe Employee
December 29, 2021

Please check this form in which I have copied the value from the dropdown in one table to the other table, on the click of a button - "Copy".

 

 

 

 

Level 5
January 25, 2022

Good day,

I'm still in need of assistance on this....Please see my questions below and dated 07-01-2022 below.  My form starts off with only one table which has a button that creates another blank table.  I am going to create another button, which the user will click that will create a table that will have some of the same entries that were chosen in the first table. This is because I do not want the user to have to enter the same entries in the subsequent tables that are created.  I would like the initial entries to be "global" or something similar to the global affect when the new table or tables are created by clicking the new button.  Is this possible?

 

Your script in the click button of your example lists:

var h= event.target.getField("form1.Table1.Row1.Cell3");
form1.Table2.Row1.Cell3.rawValue = form1.TextField1.rawValue;

 

Your example starts off with two tables instead of one.  

 

Level 5
January 28, 2022

Hello @islandgirl23 

I think you need to be more clear on what you try to achieve.

What's for sure is that the form will not "create" tables. it can show a table, or add an occurrence of a repeating subform that would include a table... things like that.

 

Here is a scenario:

the form includes a first table1 where one column contains dropdown lists; another column has a button to show a table2 where a field is calculated to equal the value of the dropdown field of the clicked row.

there can be as many instances of table 2 as there are rows in table 1.

See form here

Is this what you are trying to achieve? 

 


Good day,

This is almost what I want to achieve.  Please see the link https://drive.google.com/file/d/1IK3MyPMY2CpvX0jpNDfLPmwbBUToKWjb/view?usp=sharing .  I have two buttons with a "+" and "-".  Which works perfectly...it "adds" or "removes" a whole new blank table.  The user will enter as much information as needed into the table.  There will be times when an entry in the next table will be the same entry that was in the previous one, like the name. I would like the user to click the "similar" button which would add a whole table like the "+" button but keep some of the entries of the previous table.  The similar entries kept will be predetermined.  The user can then enter whatever is not similar.  If the next table does not have any similar entries, the user will click the "+" button and start from scratch.  So, I will need some type of script entered into the "similar" button to accomplish this.  Your help is greatly appreciated.

MHWinter
Level 4
December 29, 2021

should the new table still have the dropdown list, and assign the value (i.e. "Ford"), or do you only need the value, not the dropdown list?

 

Level 5
January 7, 2022

Yes, the new table should have the dropdown list, and assign the value.