Populate multiple rows into a repeating table from Secondary data query

Question

So I have a repeating table that I would like to be auto populated with the results of a query from a secondary data source that will have multiple results (AKA a repeating section I believe). Is there a way to do this? The reason I want to use the the repeating table is I want the user to be able to query the data from the secondary data source and then add/remove a row if necessary, fill in the new fields and then have a sum of all the costs with the new row added. But I want the information pre filled for the user as much as possible from the query before they add or remove anything. Is there another way I can accomplish without using code? Hopefully I explained that properly, Thanks, Thomas

Answer 1

There is no easy way to do this via rules because rules don't offer anything to work with repeating data (i.e. you cannot inset or delete rows, or easily copy multiple rows of data).

Code is the only way this can be done. Qdabra Software's tool 'QRules' provides a code backend that does all this work for you, but provides you an easy rules-based front end. It can insert/delete rows, copy tables, etc., even between the main and secondary data sources.

You will want to evaluate any special requirements needed if you use QRules and your form is web-based hosted on SharePoint.