You are viewing limited content. For full access, please sign in.

Question

Question

Invalid object name when trying to store document from Quick Fields

asked on October 28, 2016

I have reviewed other posts about what might be causing this error, but I cannot see anything wrong.  There are no extra spaces at the end of the name configuration and there is nothing in the tokens that is objectionable. 

Here is the programming:  %(Date#"yyyy"#) %(Fields.Vendor Name) - Cheque %(Fields.Cheque No)

And the content of the fields:

Vendor Field contents:  BEDEVIL OILFIELD LTD
Cheque Field contents:  22327

This is what is showing up as the name before I hit store:  2016 %(Fields.Vendor Name) - Cheque %(Fields.Cheque No)

 

I have used the dash with many other QF sessions that I've programmed and never run into this issue.  What else might it be?

0 0

Replies

replied on October 28, 2016 Show version history

Just to be be sure please try this. 

%(Date#"yyyy"#) %(Fields.Vendor Name#@Trim@#) - Cheque %(Fields.Cheque No#@Trim@#)

Also, could you please try to store it at different location, say maybe at root just for testing.

1 0
replied on October 28, 2016

That worked!  Thanks!  Even though I clicked into those fields and made sure there were not spaces at the end, somehow, it must have been holding an extra space, because as soon as I entered that #@Trim@# into the Vendor Name token, it worked!  Thanks so much!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.