We use cookies to try and give you a better experience in Freshdesk.
You can learn more about what kind of cookies we use, why, and how from our Privacy policy. If you hate cookies, or are just on a diet, you can disable them altogether too. Just note that the Freshdesk service is pretty big on some cookies (we love the choco-chip ones), and some portions of Freshdesk may not work properly if you disable cookies.
We’ll also assume you agree to the way we use cookies and are ok with it as described in our Privacy policy, unless you choose to disable them altogether through your browser.
Hi Mail & Deploy colleagues,
I'm having difficulties cycling through a list of invoice numbers. Previously my onvoice numbers had this format: 12345678 and Mail & Deploy worked perfectly with them. As far as I can see these numbers are seen as datatype String. As from this year the invoice numbers look like this:
U1234567 and Mail & Deploy comes with an error that the the form at of the importstring is not correct in the cycle field 'Invoice number'. Could anyone tell me how I can solve this? I'v tried using the expression MID(Invoicenumber 2, 7) but that is still causing an error.
Thanks a lot for your help.
Malcolm Stimmler
Mail & Deploy user Saltro the Netherlands.
0 Votes
1 Comments
Emma Camacho posted 2 days ago Admin
Dear Malcolm,
The easiest way would be to make this Field explicitly a text field. Something like
Load
text(invoicenr) as invoicenr
...
kind regards, Emma
0 Votes
Login or Sign up to post a comment