Search found 7 matches

by elbeau
19 Mar 22, 15:40
Forum: Macro Programming
Topic: Date
Replies: 0
Views: 196

Date

Can PhraseExpress restructure various date formats entered in a user form? All entries should be converted to the yyyy-mm-dd format (including the leading zeroes). For Example: 12/2/2021, 12.2.2021, 2021.12.2, 12-2-2021 (etc.) should each output 2021-12-02. Ideally, 12.2.21 would result in 2021-12-0...
by elbeau
13 Mar 22, 17:01
Forum: Macro Programming
Topic: Display variable result (not code) in Last user input/selection SOLVED
Replies: 1
Views: 244

Re: Display variable result (not code) in Last user input/selection SOLVED

Update - looks like deselecting "Last user input/selection" and adding the temp variable as the "Default value" does the trick.
by elbeau
13 Mar 22, 16:49
Forum: Macro Programming
Topic: Display variable result (not code) in Last user input/selection SOLVED
Replies: 1
Views: 244

Display variable result (not code) in Last user input/selection SOLVED

I'm using a form that sets Location_ID as a temporary variable to check/process the variable. (Top half of attached) With "Last user input selection" enabled, the form displays the variable code rather than the variable value, resulting in a very confusing Default Value for the user. (Bottom half of...
by elbeau
12 Mar 22, 20:41
Forum: Macro Programming
Topic: Multiple IFs for Dynamic Forms?
Replies: 1
Views: 218

Multiple IFs for Dynamic Forms?

Is there a way to add more than one "Visible only on input in:" field for Dynamic Forms? For instance, I want to display option 1 IF options A, B or C are selected (but not option D). Alternatively, the ability to hide further options once a specified selection have been made could work. Any ideas? ...
by elbeau
17 Aug 21, 20:43
Forum: Macro Programming
Topic: Using Spreadsheet to populate Variables
Replies: 2
Views: 969

Re: Using Spreadsheet to populate Variables

That's a great step in the right direction - thank you. I made another post that more fully explains my goals. https://www.bartelsmedia.com/forum/viewtopic.php?f=146&t=18861 Wishlist : Set source file location once per form. (There are a ton of variables) Have the script search the document for key/...
by elbeau
17 Aug 21, 15:00
Forum: Macro Programming
Topic: Document Generation & Temporary Variables
Replies: 0
Views: 492

Document Generation & Temporary Variables

I have searched the forums and internet but haven't been able to find a workable solution - I am hoping you can help! I regularly create MS Word reports that are similar, and I've been doing this with PhraseExpress forms by manually entering form/variable data. The user-completed form fields are sav...
by elbeau
22 Jan 21, 20:05
Forum: Macro Programming
Topic: Using Spreadsheet to populate Variables
Replies: 2
Views: 969

Using Spreadsheet to populate Variables

I have various MS Office documents that are set up as forms in Phrase Express using variables. Currently, I copy/paste the information from a spreadsheet into the Phrase Express phrase form fields. I know I can map the spreadsheet fields to the Phrase Express form using external data, but that seems...