I want the form to include a data drop down list bound to an SQL Server
table, but I also want to show/hide objects based on the user's actions,
clicking radio buttons, for example. Can I have a form that does both?
I'm habing trouble finding helpful information, both in this forum and
in wider searches.
Thank you for this information, which may be true in theory, but my
forms show that only the static form can show external data, and the
static form can't change presence at runtime, although other actions
(like reset all fields) will work. On the other hand, in a dynamic form,
I can change presence, but data will not appear in the dynamic dropdown,
which is grabbing names from SQL Server. Can you try an experiment
yourself? Try a data connection and changing presence in the same form,
and let m...
I've created a form with a dynamically populated dropdown of names. To
get it populated, one step was to save it as a static PDF form. Then it
worked perfectly. However, I soon found that my scripts to show hide
elements no longer worked. Certain Action Builder actions still worked,
but not show/hide. So I created a simple test form, and show/hide worked
form can be dynamic and all actions work or the form can be static and
After more testing, I've found that the Date/Time field cannot be set to
Data Format Date and Time or it won't work. Current Date is the same.
I've gotten errors in the Report palette when there is a mismatch. So
the Help instructions aren't accurate. These two fields are actually
limited to dates, if you want to export the data to a spreadsheet, at
least. I don't know why each object has so many possible settings in the
Object palette when you can't use certain combinations.Now I'm looking
I notice that if I select as Value Runtime Property, then the Binding
tab disappears. And there's a FormCalc in the script editor. with
Num2Date and Num2Time functions. However, when I Manage Data, there are
no fields and no values either from Export as XML or in a spreadsheet.
Also, I notice that when I open my form from two years ago, Acrobat has
the line across the top that says, "Please fill out the following form"
and has the Highlight Existing Fields button, which does highlight the
I should also add that right now I'm using my own machine. Ok. Now I
have some more helpful information. I created this problem form at work.
The Date/Time field and Current Date field from that form are the ones
with more limited palettes. Now, at home, when I drag a Date/Time field
or Current Date field onto the same form, I get the full object palette
that I see on that form from two years ago. So, it seems that ES 2 at
work is different from the ES 2 that I have at home. I guess I should
Hi, Niall! Thank you for this suggestion. In ES2, in the Object palette,
there are tabs for Fieldand Value. In the Value tab, I selected Runtime
Property: Current Date/Time. On the Field tab>Patterns, I selected a
Type, but nowhere do I see a Binding palette or Name/Normal. Have you
tried one of these objects to see what happens? It's strange to me that
the PDF shows the Date and Time, but when I send the data to a
spreadsheet, only the Date Time disappears. Even the name of the object