Qdabra qRules

Re: Using GetInputParameter with same Library and Repeating tables

Patrick Halstead — Sat, 27 Jul 2013 23:43:28 GMT

If the dropdown is bound to a field in your main data source, you should be able to just set that field and the dropdown should show it. You may also want to use IDs that are different from the display strings) for your dropdown for unique selection and long term maintenance.

Did you end up using an input parameter for your form? How are you specifying which form to load?

Re: Using GetInputParameter with same Library and Repeating tables

Deeayrian — Thu, 25 Jul 2013 19:48:24 GMT

Thanks to the help of you two and some other sites, I was able to successfully create form 2 via a button on form 1 using the open form command and adding the form's name as a parameter to the end of it. Then I could successfully copy over specified fields from form 1 into form 2 via a button that ran a query. Thank you so much for your assistance with all of that!

Now I am stuck because some of the fields that I am copying over are values from drop down lists. It appears you can't assign a value to a drop down list field, even though that value exists as an option in the list. Can you confirm if this is true? Do you know of any ways I can get this to work.

Thank you!

Re: Using GetInputParameter with same Library and Repeating tables

Patrick Halstead — Sat, 13 Jul 2013 21:31:20 GMT

Hi Deeayrian,

It's the URL for the target form. You will probably need to make it part of your concat function. For example, in the source form: concat("http://site/library/form/template.xsn&ID=",ID), where ID is a field in your form that you will be using for the input parameter.

You can get the URL for your site (assuming it's same for source and target) using an xpath command:

substring-before(substring-after(/processing-instruction()[local-name(.) = "mso-infoPathSolution"], 'href="'), "/Forms")

Re: Using GetInputParameter with same Library and Repeating tables

Deeayrian — Wed, 10 Jul 2013 12:45:00 GMT

This is probably a silly question, but how do I obtain the link to that particular form? I have searched for several hours and can't seem to find this anywhere.

Re: Using GetInputParameter with same Library and Repeating tables

Deeayrian — Wed, 03 Jul 2013 14:51:15 GMT

Sorry, I forgot to answer your question about filler or browser. It is indeed a filler form.

You've provided a lot of new commands I am not familiar with yet so I will do some research/testing and see how I can use them for my situation.

Thank you for pointing me in the right direction!

Re: Using GetInputParameter with same Library and Repeating tables

Hilary Stoupa — Wed, 03 Jul 2013 14:42:28 GMT

I meant to say "copying repeating values" not just copying values.

I asked about filler vs. browser because if you are using filler you could try the OpenForm command.

I'm assuming when you save your form, you know the name of it? That is what I am suggesting you pass to your new form, so you know what current form the new form was opened from.

qRules has CopyTable that can copy repeating data - so if you created a data connection to an XML of the same type, you could use ChangeConnectionUrl to modify that to open the correct form, query to get the data, then use CopyTable (or Insert with other rules, or Transform) to get the data into your target form.

Re: Using GetInputParameter with same Library and Repeating tables

Deeayrian — Wed, 03 Jul 2013 12:49:28 GMT

Hi Hilary, Thank you for your response.

I have some further questions. You say "I can't really think of a way to use it [GetInputParameter] for copying values into a new form" but isn't that what it is used for? The example instructions provided on your site use it to copy the person's name and their travel purpose from the Travel Request Form into a newly generated Expense Form by clicking a button. I would like to do the same thing, except that my new form would be in the same library and the data I would be passing is in repeating tables.

How would I open the new form and pass the input parameter with the ID or URL of the form I want to copy? How would I specify which form using the query?

What other qRules commands can copy repeating table values from one form to another?

Thank you.

Re: Using GetInputParameter with same Library and Repeating tables

Hilary Stoupa — Wed, 03 Jul 2013 01:34:32 GMT

Hi - GetInputParameter would be used in the target form you are opening. I can't really think of a way to use it for copying values into a new form. I think I would instead:

Submit the form the user has open, so that the items they have checked are saved
Open the new form, passing in an input parameter that has the ID or URL of the form saved in step one
In the new form, get the input parameter and execute a query for the form from step 1
Use other qRules commands to copy in the repeating table values

Is this a filler form or a browser form?

Using GetInputParameter with same Library and Repeating tables

Deeayrian — Tue, 02 Jul 2013 19:18:12 GMT

I have a form that I would like to use GetInputParameter to pass data from some of the fields into another newly created form in the same library.
My questions are:

Can you use GetInputParameter to create a new form in the same library as the source form?
Can GetInputParameter pass data from repeating tables into repeating tables in the new form?
Can you dynamically specify what gets passed? For example, what if the end user checks a checkbox next to each row in the repeating table that they wanted to copy into the new form?

As always, thanks for your help.