populating textfield based on the drop list selection.

Question

Hello my Friends,

I need your help for this problem and I need the code for this issue.

Here the details for this form.

In the the Status Dropbox there 3 categories ( Pending, Invoice and Release)

When I select the “Pending” Status in dropbox, then select the Reservation date and select the Deposit Dropbox (yes or No) then result in Over due text box

if “yes” selection from deposit dropbox = display in overdue textbox is “14 days"

If “no” selection from deposit dropbox = display in overdue textbox is “ 3 days”

If the status select, invoice and release not showing the overdue. Mean blank only. Only the Pending showing the output in over due textbox.

Please refer the sample in excel in attached. So that you have idea what I mean. The main point there is if you change the date automatic the over due is change the no. of days.

Also, the pdf file sample but without code in over due because I don’t know how to do it.

Thanks you advance for you help.

Nesa Nurani · Accepted Answer

also, if I want to change the date example below.

10/10/2020 - the result in over due is -8 days

12/20/2020 - the result in over due is 53 days.

you can see there the sample in excel.

See if this works for you example

This is code I put in "OD1" field as custom calculation script:

Nesa Nurani · Answer

Put the code in "OD1" field as "Custom Calculation Script"

if(this.getField("Status1").valueAsString == "Pending" && this.getField("Dep1").valueAsString == "Yes"){
event.value = "14 Days";}
else if(this.getField("Status1").valueAsString == "Pending" && this.getField("Dep1").valueAsString == "No"){
event.value = "3 Days";}
else event.value = "";

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.