Clear field used for "log" - InfoPath Dev Sign in | Join | Help in Newbie Questions InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Newbie Questions » Clear field used for "log" Clear field used for "log" Last post 11-29-2012 10:54 AM by Hilary Stoupa. 13 replies. Page 1 of 1 (14 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 11-21-2012 07:26 AM Toni Green Joined on 04-22-2011 Arkansas Posts 18 Clear field used for "log" Reply Contact Happy Day Everyone! I am trying to find a solution to clear a test field once I hit the tab button. Let me explain a bit more in detail. I have created a "Work Log" text field that the user will input there daily activities, etc. When they hit the "tab" button the data concats with date, time, status, etc into a read only field called "Log View". What I am trying to do it to clear the field "work Log" once they hit tab. I am new to the coding aspect so any detailed instructions would be greatly appreciated.Have a wonderful day and thank you in advance!!!! Newie to InfoPath! Filed under: reset fileds, clear field, tabing 11-22-2012 04:27 AM In reply to ErnestoM Joined on 08-27-2007 Posts 3,320 Re: Clear field used for "log" SampleForm.xsn Mark as Not AnswerMark as Answer... Reply Contact I don't believe you need code to achieve this. I'm attaching a sample form that you can download, open in design mode (to look at the rules) and preview. Hopefully this helps. Good luck! Ernesto MachadoQdabra® Software/ InfoPathDev.comThe InfoPath Experts – Streamline data gathering to turn process into knowledge.™ 11-23-2012 07:28 AM In reply to Toni Green Joined on 04-22-2011 Arkansas Posts 18 Re: Clear field used for "log" Mark as Not AnswerMark as Answer... Reply Contact Thank you! My only problem is that it overwrites the last value that is logged....am I doing something incorrectly? I added the rules as you stated.Thank you again for your assistance. Newie to InfoPath! 11-26-2012 04:33 PM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Clear field used for "log" SampleForm.xsn Mark as Not AnswerMark as Answer... Reply Contact Actually, it looks like in that sample, you'll only ever have the last entry. I modified this a just a smidge. :-) Hilary Stoupa 11-28-2012 05:43 AM In reply to Toni Green Joined on 04-22-2011 Arkansas Posts 18 Re: Clear field used for "log" Mark as Not AnswerMark as Answer... Reply Contact Thank you for your assistance. I have the concat formula working beautifully, but still can not get the initial field to clear once the data is moved to the "Work Log" text field. Newie to InfoPath! 11-28-2012 07:17 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Clear field used for "log" Mark as Not AnswerMark as Answer... Reply Contact What are your current rules? Hilary Stoupa 11-29-2012 07:35 AM In reply to Toni Green Joined on 04-22-2011 Arkansas Posts 18 Re: Clear field used for "log" Mark as Not AnswerMark as Answer... Reply Contact concat(., " by ", userName()) concat(@WorkLogCache, @crlf, now(), ";", ., ";", userName(), ";", "Status", ";", RequestStatus) Newie to InfoPath! 11-29-2012 07:45 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Clear field used for "log" scrn.png Mark as Not AnswerMark as Answer... Reply Contact Your screenshots aren't displaying for me - you can attach them under the Options tab if you like. I think what you may be missing is a rule to clear the original field.... in my sample, my rules set the field to blank after setting the log (and my field to set the log only runs if the field is not blank to begin with). Hilary Stoupa 11-29-2012 08:37 AM In reply to Toni Green Joined on 04-22-2011 Arkansas Posts 18 Re: Clear field used for "log" WorkLog1.jpg Mark as Not AnswerMark as Answer... Reply Contact I attached of the screen shot WorkLog1 which is what I am actualyl trying to accomplish. If I use the sample you gave me (about the same I have) it does nto clear the filed..... :-( Thank you :-) Newie to InfoPath! 11-29-2012 08:41 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Clear field used for "log" scrn.png Mark as Not AnswerMark as Answer... Reply Contact In the sample attached to my post, if I preview it and type in the work log field and tab out, the text gets added to the log field and the work log field is cleared - is the sample form not working that way for you? Hilary Stoupa 11-29-2012 08:57 AM In reply to Toni Green Joined on 04-22-2011 Arkansas Posts 18 Re: Clear field used for "log" WorkLog4.jpg Mark as Not AnswerMark as Answer... Reply Contact No it is not :-( (I am sad). It still keeps the data. Here is a screen shot of your form in use on my system. Newie to InfoPath! 11-29-2012 09:01 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Clear field used for "log" Mark as Not AnswerMark as Answer... Reply Contact Oh how weird. And this is in InfoPath Filler? Screenshot of the rules on the Work Log field? Hilary Stoupa 11-29-2012 10:42 AM In reply to Toni Green Joined on 04-22-2011 Arkansas Posts 18 Re: Clear field used for "log" Mark as Not AnswerMark as Answer... Reply Contact Yea I am working from InfoPath Designer 2007. and yes the work log field......any other ideas? Newie to InfoPath! 11-29-2012 10:54 AM In reply to Hilary Stoupa Joined on 06-20-2008 Posts 13,297 Re: Clear field used for "log" SampleForm.xsn Mark as Not AnswerMark as Answer... Reply Contact Oh, how annoying, I just tried this on my IP 2007 VM, and had the same results. Try this one - I added another field to use to reset the Work Log field. Hilary Stoupa Page 1 of 1 (14 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
Happy Day Everyone!
I am trying to find a solution to clear a test field once I hit the tab button. Let me explain a bit more in detail. I have created a "Work Log" text field that the user will input there daily activities, etc. When they hit the "tab" button the data concats with date, time, status, etc into a read only field called "Log View".
What I am trying to do it to clear the field "work Log" once they hit tab.
I am new to the coding aspect so any detailed instructions would be greatly appreciated.
Have a wonderful day and thank you in advance!!!!
Thank you! My only problem is that it overwrites the last value that is logged....am I doing something incorrectly? I added the rules as you stated.
Thank you again for your assistance.
What are your current rules?
concat(., " by ", userName())
concat(@WorkLogCache, @crlf, now(), ";", ., ";", userName(), ";", "Status", ";", RequestStatus)
I attached of the screen shot WorkLog1 which is what I am actualyl trying to accomplish. If I use the sample you gave me (about the same I have) it does nto clear the filed..... :-(
Thank you :-)