HiYour re-populating listbox input drive me to search the forum and found this thread Update Number of Attachments Field where Mouslander advised to use formatted value. Thanks to both of you.Rgds

Hi BruceI changed NumericField1.rawValue to NumericField1.formattedValue in add button and object locale from default to English (USA) for all buttons. This time listbox values were retained in mail recipient's computer. Would you pls share why this happened as I have no idea.Rgds

"So, you are saying if you just save it locally and then re-open it the listbox values are retained, but if you email to someone within your organisation the listbox values are not retained, but the attachments attached to the form?"---- yes, you are right.Would you please help me with some code in reloading the listbox from the attachments in the form.And for mail system, what should I check?Rgds

Hi,List box doesn't retain file name when recipients open the file after receiving it by internal mail.

HiI tried with paul's sample and same thing happened.I am sharing my form for your viewDeviation Report Form.pdf - Google Drive Rgds

Hi BruceSorry, I forgot to share one issue.In our firm, we use internal outlook mail service. When a person add attachment in his/her PC, attachment name is populating in listbox. But it is not populating in recipients PC. I converted my form to static PDF and this time listbox is okay with attachment name in recipient's PC.If I use static form then searchable dropdown facility is lost.(Thanks for sharing a great feature in your blog, Adobe LiveCycle Designer Cookbooks by BR001: Updated: Drop-Do...

Thanks for reply.There is one code in initialize event in form1::initialize - (JavaScript, client)xfa.host.messageBox("This document requires Adode Acrobat Pro 9 or higher or Adobe Acrobat Pro DC to get full feature of the form. Click OK to continue.", "Software Version Requirement", 2);if (!app.runtimeHighlight){ app.runtimeHighlight = true;}I have two drop down box (userSelection & prodfacility) and one text box (prodlocation) that has below code form1.page1.userSelection::docReady - (JavaScri...

It worked.Thanks

Hi GreigI am working on 3 dependant dropdowns. The link is not woking.Would you please share the file in fibonacci107 at gmail dot com.Thanks

HiThanks and you a saver!I open the form and it is almost there.. Text field data is populating in drop down list. But i am getting two unusual things -firstly when i mistakenly click the drop down icon after initial addition of file dropdown list is automatically populating. What will be my approach to prevent this happening? Any idea pls.Secondly, when I click export button, i had to save the file. Is there any way so that i can avoid this file save option.

HiThank for reply.I removed one endif after $ = TotalDays - dayCnt and it worked!.Another point is that if I want to exclude one specific day what type of code I shall use?Suppose start date is 8th April 2018 and end date is 11th April 2018. I want to exclude 10th April from calculation.Rgds

HiThanks for the replyI changed the code as below after endfor, and showing the error,Error: Syntax error token near 'else' on line 47, column 4.if (sickcb1 == 1) then$ = TotalDayselse$ = TotalDays - dayCntendifendif else$ = "" endifelse $ = ""endifcan you please helpRgds

HiThanks for the response.After you reply, I put below code in WeekDaysvar fromDate = Start_Date1var toDate = End_Date1if ( HasValue(fromDate) & HasValue(toDate) ) then var fromDateAsNum = Date2Num(fromDate, "YYYY-MM-DD", "en_IE") var toDateAsNum = Date2Num(toDate, "YYYY-MM-DD", "en_IE") if (toDateAsNum >= fromDateAsNum) thenvar TotalDays = toDateAsNum - fromDateAsNum + 1var currentDateNum = fromDateAsNumvar dayCnt = 0for i=1 upTo TotalDays dovar dayOfWeek = Num2Date(currentDateNum,"E") if (dayO...