Therefore Ideas

Submit your feature requests for Therefore™!

Fill data grid from referenced table

It should be possible to fll a data grid with various lines automatically from a referenced table, not one by one.

This would eliminate the possibility of filling the lines with wrong information, also reduce the time needed to fill the e-form if we need to fill 5-10 or even more lines.

  • Alex Enescu
  • Mar 25 2021
  • Attach files
  • Peter Sarlos commented
    21 Sep 12:23pm

    Hello all,

    Based on multiple discussions, we have the following proposal: While filling out an E-Form users will be able to automatically copy multiple lines from a referenced table based on another field value. Administrators will be able to set up a datasource(refernce table) for a table component. A field then can be set as a base for selecting the data from the source. For example: Entering an order number from a previous order will populate all the line items on an items table and there is no need to add every item manually. After the items added they can be edited so modifications are available if the order needs to be changed.

    Please see the attachment to view the UI plan.

  • Sascha Willershausen commented
    19 Aug, 2021 02:49pm

    Hello all,

    if I understand correctly, you want to do a database lookup (e.g. an ID) and then have the rest of the data populated, is that correct?

    If yes, that is currently possible. We already use this in our system by selecting the ID via the "database lookup" component and filling the associated data in TextBoxes. You can make an editing grid around it and add more and more "rows" via the "Add another" button. In the editing grid, you can then set that a table is created from it when exporting.

    I hope this helps you.

    Many greetings


  • Admin
    Product Innovation commented
    2 Aug, 2021 10:33am

    Although we understand that this would help in some scenarios, due to the big number of great ideas for enhancements we do not plan to start implementation of this request soon. Thus, if you have important projects pending where you absolutely need such functionality, you can only make use of the scripting features inside the eForm feature and load values (probably via REST calls) and fill them into the eForms table. This will be coding effort, but probably the only option as of today.

  • toni martin commented
    29 Jul, 2021 07:26am

    Hello, could we have any update on this? we have some projects in stand by for months because the solution developed with eforms is not complete

  • toni martin commented
    14 Jun, 2021 04:39pm

    Hello, ok but as you can see is the idea related to eforms more voted, so we would appreciate if it could be included soon in one of the next releases

  • Admin
    Product Innovation commented
    14 Jun, 2021 08:44am

    We keep this in mind, but cannot confirm a date when this will be done. Due to the huge number of great ideas here it is always very difficult to select the top ones which will be implemented on the next release.

  • toni martin commented
    7 Jun, 2021 11:34am

    Could we have any update about this idea soon?

  • toni martin commented
    12 May, 2021 08:02am

    Yes, that's it, table should stay editable, so user could add, edit or delete any row from default data copied.

    I don't understand what you mean about standard Therefore client functionality, finally what we want is that once the table is filled that will be mapped from eform to category as current functionality

  • Alex Enescu commented
    12 May, 2021 08:01am


    It would be nice to have an option for the fields to be changed or read only. This would give more flexibility on a case by case scenario.

    Regarding the feature, while the idea is featured in the eform category, it would be more than welcome in the Therefore client.

    Thank you.

  • Admin
    Product Innovation commented
    12 May, 2021 07:52am

    Thanks for the clarification. We now understand more or less what the software should do.

    I assume all rows copied from such referenced table should stay editable, correct? So, we are talking about copying default data, which the user can change as required.

    You specifically ask for this feature in eforms, but this is not requested as standard Therefore client functionality when saving a document, correct?

  • Alex Enescu commented
    3 May, 2021 11:51am


    An example would be, we have a field with the Vehicle ID, you select it and the table populates with all the options that vehicle has. Basically the table depends on the vehicle ID.

    Another example would be, you select the product ID, and the table populates with the ingredients and weight and whatever information you need.

    I hope this makes it easier to understand. Thank you.

  • Admin
    Product Innovation commented
    3 May, 2021 10:44am

    Hi, I still have no idea how this could work in the end. You compared this to the referenced table concept. In this case there would have to be some starting field which is filled in and then the lines are populated. Is this what you would expect? What data are we talking about that this makes sense?

    Or are you more talking about default values? E.g. when the eForm is opened up that there should be 7 lines with certain default values?

  • toni martin commented
    29 Apr, 2021 08:10am

    Do we have any news about this? :)

  • toni martin commented
    6 Apr, 2021 11:32am

    Hello. For instance when you have lines linked to a category. These lines can be added dinamically when filling the eform with the data grid, but you cannot load them once it is already saved in database. It would be greatfull that you could link a datagrid to a referenced table already created, so that you can "preload" some values to these lines. So if you have an eform where you look for a document in a category, and this document has some lines associated, you could get those lines dinamically into the datagrid

  • Admin
    Product Innovation commented
    6 Apr, 2021 11:18am

    Thanks for the idea. Could you please add more information on the specific use case? E.g. Which data do you want to store in the table in Therefore? Where does this information come from? Which information would you like to specify in Therefore and then use it to pick up the correct lines from a different table?

  • toni martin commented
    26 Mar, 2021 07:49am

    It would be great to be able to link a referenced table to data grid, as well as you do it with table queries. It will give you the option to preload some lines and it would be much more agile for the user.