XML Receipt and Conditions

I wanted to make a small adjustment to the receipt when a certain
condition is met.
If a particular word (eg. family) is typed into the comment on an item
I wanted something slightly different to happen to the receipt

I've just about got it, just stuck on the condition tag

<IF>
<CONDITION>len(Entry.Comment)</CONDITION>
<THEN>

I can get it using len but this makes it happen for any word, is there
anyway I can make it so that it is more specific ie    Entry.Comment
contains '%family%'
0
jet328 (1)
3/15/2009 11:04:27 AM
pos 14173 articles. 0 followers. Follow

1 Replies
548 Views

Similar Articles

[PageSpeed] 59

try
 <IF>
 <CONDITION>Entry.Comment like '%family%'</CONDITION>
 <THEN>


"jet328@gmail.com" wrote:

> I wanted to make a small adjustment to the receipt when a certain
> condition is met.
> If a particular word (eg. family) is typed into the comment on an item
> I wanted something slightly different to happen to the receipt
> 
> I've just about got it, just stuck on the condition tag
> 
> <IF>
> <CONDITION>len(Entry.Comment)</CONDITION>
> <THEN>
> 
> I can get it using len but this makes it happen for any word, is there
> anyway I can make it so that it is more specific ie    Entry.Comment
> contains '%family%'
> 
0
MattHurst (182)
3/15/2009 3:04:01 PM
Reply:

Similar Artilces:

XML Header
Hi, I have some XML doc loaded in a C# Web Service. XmlDocument doc = new XmlDocument(); doc.LoadXml(myDoc); Code Missing to manipulate header (I would like to replace or manupulate all these XXXXX): <mso-XXXXXX productversion="XXXXXX"> <mso-application progid="XXXXX"?> doc.Save(myNewDoc); Any idea on how to access and manipulate data within the doc header? Thanks vbdev vb6dev2003 wrote: > I have some XML doc loaded in a C# Web Service. > XmlDocument doc = new XmlDocument(); > doc.LoadXml(myDoc); > > Code Missing to manipulate header ...

Read XHTML into XML
Hi all, I need to read/parse XHTML aspx pages and look for certain tokens and content. How can I use a XmlTextReader for this? If not, any other ideas? Thanks in advance, JA Reyes. Jose Antonio Reyes wrote: > I need to read/parse XHTML aspx pages and look for certain tokens and > content. How can I use a XmlTextReader for this? If not, any other ideas? If the pages are well-formed XHTML then it is possible to use XmlReader (in .NET 2.0/3.0) or XmlTextReader (in .NET 1.x) to parse the XHTML documents. You can also use the other XML APIs .NET provides so using XPathNavigator and/o...

About return receipt
Days ago, I got an email with a return receipt request, and I click yes to this request. But the return receipt cannot be sent and everytime it said: " Error(0x800CCC0F).... (invalid address ):279905 -1 " I want to cancel the receipt but I cannot find it in the outlook. Anyone would offer help? Thanks in advance. Following is the original error message: ����pop.m165.com - ���ڷ��͡������˴���(0x800CCC0F):���������������жϡ��� ���������ִ����⣬�������ķ���������Ա�� Internet �����ṩ����ϵ(ISP)�� �� Ӧ������: 500 ��Ч��ַ(invalid address):279905 -1 �� ...

How to invoke the xml editor?
I installed vs2005 on a new xp pro machine, and installed everything except C++. When I click on a file with a ".xml" extension it is opened with IE. When I click file/Edit with XML Editor, it opens it with Notepad. If I click File/Open With and select XML Editor, it opens it with IE. So, where is the xml editor? Can it be invoked from withing VS? Where? Bill * billsahiker@yahoo.com wrote in microsoft.public.dotnet.xml: >I installed vs2005 on a new xp pro machine, and installed everything >except C++. When I click on a file with a ".xml" extension it is >opened ...

show XML schema and values
I have an XML document that looks like the following: <record> <Field1>value1</Field1> <Field2>value2</Field2> <Field3>value3</Field3> </record> What I'm aiming to do is to show the data in a report as in the following example: record: Field1 value1 Field2 value2 Field3 value3 The "Field1-3"-elements can have any name, so I'm trying to get a table that has in one result column the element name, and in the second colum...

Conditional Formatting #94
I have a range of cells that contain formulas, but I also need to give the user the option to manually overwrite the result of any of these formulas. Where the formula is overwritten I want the cell shading to turn yellow. I can't see a way of doing using the Conditional Formatting tool. Is there something else I could try ?? Hi Phil, Are you using Conditional Formatting to begin with ? If so they answer is no, because C.F. overrides normal cell formatting.. Unless you are talking about a constant replacing what is normally a formula in a column. You have to be able to identify w...

SUMIF with two conditions ?
:cool: OK I have tried just about everything and can not find the righ combination for seems like a simple problem: IN A1 IF N79:N83 >=1 AND IF N79:N83 <=7 THEN SUM K79:N8 -- Calvi ----------------------------------------------------------------------- Calvin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=590 View this thread: http://www.excelforum.com/showthread.php?threadid=26341 Hi Calvin one way =SUMPRODUCT(--(N79:N83>=1),--(N79:N83<=7),N79:N83) Cheers JulieD "Calvin" <Calvin.1d4dfz@excelforum-nospam.com> wrote in message...

More on uncontrolable receipts being sent
A while back I asked about a problem in which requests for receipt messages were being honored even though I had turned that off. As an experiments I switched to ASK, which it now does. However, when I tell it no, the pop up box closes, and a receipt message appears in the outbox. An improvement, as I always have a reminder to delete them before they are sent. However, I would still like to fix the problem. I am using: WINXP Home (SP1) Outlook 2000 (SP3) However, the problem occurred, or was noticed, while I was running WIN98SE, Outlook 2000, and applied SP2 to Outlook. Prior to that, ...

Delete Macro with OR/ELSE condition
I am a beginner a writing Macros in Excel. I have a Macro that deletes any record that does not equal "Server/Midrange Software" in column M. I need to expand this to include other criteria. Such as, if column M does not equal "Server/Midrange Software" or does not equal "Data Telecom" then delete the record. The Macro I have currently is..... Sub TryMe() 'Deletes rows where the value in column M are not equal to Server/Midrange Software Dim RowMdx As Long Dim LastRow As Long LastRow = Cells(Rows.Count, "M").End(xlUp).Row Fo...

conditional format of data tables in charts
I've created a chart that is based on a data set where the cells have conditional formatting (if value a > value b then colour the cell red) I have the data table displayed with the chart (in chart options, 'show data table' is ticked), but the condtional formatting is not displayed in this table, i.e cells that are red in my original data set are not coloured in the chart table. Is there any way to apply the conditional format on the table displayed within the chart? Cheers Dan. Daniel, Unfortunately you can't apply conditional formating to data tables. However, yo...

Offline synch using XML web-services
This is a bit long-winded. Can somebody read thru these 2 use cases, and tell me if it is feasible ? :- Use Case : Replication before Offline Synch Scenario 1 : Oracle Server , MSDE client 1. User clicks on 'Go Offline'. System creates a MSDE SQL database in laptop (client), gets the schemas of the tables in Oracle, creates corresponding tables in client's MSDE SQL (mapping Oracle datatypes to SQL datatypes). 2. Offline replication program reads in the tables of the server into a typed datasets, converts the typed datasets into XML, and stores the XML in the client. (XML serial...

XML Serialization ... how to truncate <?xml...
While xml serializing object how can I truncate <?xml ...?> this line alone? I need to send the serialized xml data to a web method ... since SOAP already have <?xml tag there was some confusion Any help would be greatly appreciated Thank you Regards Raj Raj wrote: > While xml serializing object how can I truncate <?xml ...?> this line alone? Serialize to an XmlWriter created with XmlWriterSettings where you set OmitXmlDeclaration to true. -- Martin Honnen --- MVP XML http://msmvps.com/blogs/martin_honnen/ ...

Custom Autonumber Conditional Formatting
To, The EXPERTS, ( Access Dept.) I am New to access but have managed to make a database for my patients records , my trouble is the Registration Number of the Patient,( a cloumn in my database). i want it to generate the unique ID just llike AUTONUMBER, with the format i need that should be like YYMMnn( YY= present year,MM= present month and nn = numbers 01 to 99, with reset to 01 at the start of the next month)the event to trigger the event is SAVE Form button. please can anybody help? Thanking you in advance To, Mr.Klatuu Thanks for your Promt help... I will try to put this into use i...

String to xml document
Hi there, I was hoping someone can help me with a little problem I can't seem to find any answers to. I've got a form wich will be posted. On receiving the post I would like to parse a formvar to a xml document. The contents of this formvar (string) will be a valid xhtml document. Can someone give me a startertip (or more :-)) on how to achieve this? tnx in advance, James van der Veen Sjeems wrote: > I was hoping someone can help me with a little problem I can't seem to find > any answers to. > > I've got a form wich will be posted. On receiving the p...

Beginner of XML
I am a beginner of XML. I want to group some files together with a xml file. (it includes a text file, and an image file and a video file) Can someone show me some guidelines? Please help. ...

conditional formating
Hi.. Ive got a set of sales figures next that relate to specific stores we are selling our products in. Ive managed to conditionally format cells where no stock has been sold, but I want to highlight the name of the store that has not sold any stock. How do I do this? Please help me Im going out of my mind!! Thanks Hi you may provide some more details about your data layout. e.g., some example data -- Regards Frank Kabel Frankfurt, Germany "ANDREW_B" <ANDREWB@discussions.microsoft.com> schrieb im Newsbeitrag news:47638ECE-9DD9-4568-83F8-39BEC64E25AC@microsoft.com... ...

Valid xml to read from an xml file?
I'm using vb.net, i get an error at the reader line saying the remote server can't be found. Is the below even valid? dim reader as XmlTextReader reader = new XmlTextReader ("http://www.mysite.com/my.xml") do while (reader.Read()) 'do some action here response.write(reader) loop thanx chumley XmlTextReader uses System.Net.WebRequest under the covers -- see if you can figure out how to create a connection that way. Usually there's some proxy server information missing that you can enable if you use WebRequest directly, and then pass the result of GetResponse()...

Example eConnect XML documents
MSDN says the following: Installing eConnect schema When you include the schemas component of the eConnect install, the installer places schema files in a schemas folder on your computer. The following schema resources are available: The install places the .xsd schema files in the directory c:\Program Files\Microsoft Great Plains\eConnect9\XML Schema\Incoming XSD Individual Schemas. The files in the directory contain the schema for each eConnect XML document. The install places a file named eConnect.xsd that contains the schema definition for all eConnect XML documents. The install typicall...

Saving DataSet as XML in ADO format using VB.NET
Hi, I am trying to convert a lot of web reports from ASP/VB to ASP.NET/VB.NET. I would like to save my dataset in XML and then use XSLT to transform the XML. The catch is I would like to have the XML in the format that ADO uses versus the default format in which ADO.NET uses. Currently, I am using ADO within .NET, but I am concerned about the performance and it might improve if I used the native data providers for .NET. I am not sure if I am missing something but how do I save the .NET DataSet to XML in the OLD ADO format? Thanks for you help in advance and it is most appreciated. In the ...

How do you get a conditional output to show in color
I need to have dates that have past show in red on my spread sheet. Can I do that with an IF statement? Have a look at Conditional Formatting in Help, its all there and it will do that with no problems, Regards, Alan. "Luke" <Luke@discussions.microsoft.com> wrote in message news:A70AC164-DCD3-4439-A07C-AD54BB64A740@microsoft.com... >I need to have dates that have past show in red on my spread sheet. Can I >do > that with an IF statement? ...

XML variable for description on receipt?
Hi, I would like to add a description (actually all of those 3 extended descriptions) to display on the printed receipt under the main description. What is the variable to do that? Entry.Item.Description Entry.Item.ExtendedDescription Entry.Item.SubDescription1 Entry.Item.SubDescription2 Entry.Item.SubDescription3 R. "Zorian" <Zorian@discussions.microsoft.com> wrote in message news:F4425EAC-62B6-46FE-826A-D8BA2AA75DBB@microsoft.com... > Hi, I would like to add a description (actually all of those 3 extended > descriptions) to display on the printed receipt un...

xml to SQL
Hey we have a project in which a company produces a XML page in reply to actions on it's site. I see that SQL 2000 works well with XML so Can someone point me in the right direction, I would like to take the XML from thier SQL and have it "post" to own sql server (add,create, data, modifity and delete data on the fly). I was looking at doing XML to HTML and then passing to some a ASP but if we can grab from the responsetext then we could save time and headaches. Now I really know next to nothing about XML but I am reading all the newsgroups and pulled now TONS of xml / sql stuff ...

new xml file is larger than the original
i'm working on a windows application that will edit and create xml files from another application. the original file is 83k, the one created by my vb.net program is 153k but all i add is a new xmlelement when i use the other program and add a xmlelement is only increased the file to 85k. how come my application increased 70k in size and also added the <?xml version="1.0"?> when i didn't tell it to. how do i duplicated a xml file and only add the xml element that i want to insert. where did the extra 70k come from. thanks here is my code: Dim newEvtEnr...

Conditional Formatting 11-13-07
I have a continuous form that lists members of a class. The database includes two classifying T/F flags indicating if a member is missing or deceased. The RecordSource query is normally filtered such that these two classes are excluded. However, I have a command button that turns off the filter via event code such that all members are listed. The name fields have conditional formatting, with the missing members shown in red and the deceased show in blue. It seems that all of a sudden the deceased members lost their conditional formatting: Expression is --- [Deceased]=True show in Blue Expr...

Obtaining receipts for read messages
How does a sender ask the recipient to acknowledge receit of an e-mail? Help Menu seems to indicate a Digital Signature is necessary - is this so? Old Red One <oldred1@charter.net> wrote: > How does a sender ask the recipient to acknowledge receit of an > e-mail? In the Compose window, before you click Send, click View>Options and check one or more of the "Request a receipt" boxes. This will send a receipt request. However, there is nothing that _requires_ the recipient to acknowledge that request. > Help Menu seems to indicate a Digital Signature is necessa...