-
May I see a copy of your template? It would help me understand the question better. Feel free to email it to me. :)
-
See attached sample. Save the file linked in this post header by right clicking the link. Then, right click the downloaded file and select design to open in design mode. Then you can preview, etc.
-
In the form, you could use a calculated value set to display the data as currency. Just add a calculated value to the form, select the field that has the value, and under the properties, format it as a decimal. You'll have the options then to set the currency settings.
-
Display in your form? Or in your list?
-
So - by auto populated, you mean it has a default value? Or is it being set by a rule?
-
Hmmm. I don't know how helpful this is, but I just tested this in a list form of mine. I checked in preview and in the published form, and in all cases the validation worked as expected. The field was marked invalid unless I had 7 digits, followed by a semicolon and a space for any additional numbers.
-
Glad that it all worked out in the end - have a great weekend!
-
So - if you set the query field for the record you want, then query the main data source of the list form, you'll get back the record and can edit it. Your dropdown could be bound to the query ID field (you may have to put the data source task pane into advanced mode to see that) and have the list item ID for the value, and the title (or ...
-
I love your user name - laughed out loud when I approved the account. One issue I see right off is that you don't want the end user to have access to the list - but the user will have to have permissions to the list to be able to add / edit items. Or do you just mean that you don't have an obvious link any where for the user to click to ...
-
Give this one a try. You'll see I'm using default values for the ref numbers instead of setting on submit -it is just easier with repeating data to do that. If you don't want to see them till submitted, you could add a field to your form for status, set to submitted as part of your submit rules, and only display the ref nums if status ...