General

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 21:45:00 GMT

So I have this working in the email YEAH!!! Now only question is how to format the currency in the table. Any ideas. I know in her example she is using whole number with no $ or commas. I do not need cents. Dorinda

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 20:19:30 GMT

finally got it to download. geez Internet is fussy today.

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 20:15:11 GMT

It will not allow me to save it only a link to that document here is what I get when I try to download it

Re: Unique ID for data connection submit

Hilary Stoupa — Wed, 04 Dec 2019 20:12:52 GMT

You are most likely opening it instead of opening in design mode. Save the linked file locally. Right click on the saved file and select Design to open in design mode. EDITED TO ADD - to save the linked file locally, right click the link and select the option to save. That menu option will differ depending on what browser you are using.

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 20:02:06 GMT

It wont let me down load your copy give me the following error: Forms that require the domain permission level contain features that access information on a network, such as data connections, linked images, and code.

Re: Unique ID for data connection submit

Hilary Stoupa — Wed, 04 Dec 2019 19:58:25 GMT

Here. I put the formula on a button for you in this copy. The button is named "Button" and is at the top of the approval view.

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 19:51:29 GMT

Now I am getting this error and here is what i have Type mismatch. Error occurred during a call to property or method 'Eval'.

Re: Unique ID for data connection submit

Hilary Stoupa — Wed, 04 Dec 2019 19:05:06 GMT

Use the field picker in the formula editor to re-select group 2.

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 19:00:14 GMT

So from the webinar it wants you to set it on the submit rule. I tried that and it doesnt like it i am adding to an action rule, when you put it as the default it works fine. Not sure how to fix this one? "../my:group1/my:group2" does not point to a valid location path of a field or group.

Re: Unique ID for data connection submit

Hilary Stoupa — Wed, 04 Dec 2019 18:50:53 GMT

Looks like the HTML tags were removed from my formula. I've put the formula in the default value in your HTML coded string for you, using the same approach as in the expense report form you included from the webinar you watched. It is more helpful if you can include info on the errors, like screenshots, or the error text, or information on what you expect to have happen and what is actually happening.

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 18:32:27 GMT

I have tried to type this and get all kinds of errors I am not sure what I am doing wrong but I cannot get this to work. Please help Dorinda

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 17:44:35 GMT

I am still so lost I am attaching the form so you can see what it is doing. I cannot get it to do anything.

Re: Unique ID for data connection submit

Hilary Stoupa — Wed, 04 Dec 2019 15:08:25 GMT

I reformatted my earlier post. You should have been able to see my suggestion if you'd scrolled up? Here is the post again.

I suppose I'd either add a rule on Submit to set the HTML Coded string field, or I'd use a default value there. For a default value in the _HTMLCodedString field in your ior form:

xdMath:Eval(xdMath:Eval(../my:group1/my:group2, 'concat("", my:QTY, "", my:ItemNbr, "", my:UnitPrice,"")'), "..")

Re: Unique ID for data connection submit

Ruenells — Wed, 04 Dec 2019 11:39:24 GMT

I do not see anything I really need help understanding this. Thank you again for your help. Dorinda

Re: Unique ID for data connection submit

Hilary Stoupa — Tue, 03 Dec 2019 17:53:34 GMT

Oh wow - Chrome mucked up the formatting. Just fixed in IE.