Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About WF7A

  • Rank

Profile Information

  • Title
    Database Administrator
  • Industry
  • Gender
  • Location
    Lewiston, ID

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
  1. I received a reply from Junior Perez at 360 Works and with his permission I'm reprinting it here: Hey Richard,As it stands, I doubt Scribe supports list boxes. As I understand it, we use a library/API like iText or PDFBox that allows our plugin to interact with any XML document and perform scribe functions. Based on the lack of mentions of list-boxes in our documentation, that's a feature that either the library we used at the time didn't support, or something our developer didn't account for when making the plugin.I'll double check with him that this is a feature we hadn't accounted for. As for when this feature will be made available, it probably won't happen until Scribe gets re-worked, which probably won't be anytime soon. Just so you know, in the event you wanted to hire a developer to implement this feature sooner, let me know and I could get you in touch with our project management team.
  2. I looked in the the latest documentation for Scribe but didn't see any text regarding extracting multiple values from of a .pdf list box. When there's one value in the field the chosen value's extracted but when there's more than one the result is an empty/null field. Did I miss something or...? Cheers, Rich
  3. I thought I'd bump the thread to include the looping script I composed to load a .pdf, parse its fields, then populate the FileMaker Pro database. Cheers! Note: In line 28, I used a calculation field, FieldList_Sorted__lct, instead of FieldList__lxt, because I have so many values in the .pdf that I want to import from that I wanted the list sorted in ascending order to make it easier to troubleshoot troublesome fields (which are listed in ascending order in the FileMaker Pro's field editing screen) since Scribe imports the fields unsorted. To convert the unsorted list into a sorted one, I made a dynamic value list out from the FieldList__lxt field then used FieldList_Sorted__lct (calculation/text/unstored, ), defined as follows: ValueListItems ( Get ( FileName ) ; "Values" ) ...with Values being the value list name.
  4. I agree and feel the same way, but there's a reason for this: to fend off any potential confusion for new users*. More than likely there will be more records than what they'll will see in the portal (before scrolling), so it alerts them that they will have to scroll through all the records to number them all. (...and they have to number them all for an attached script to work.) *The users have little-to-no experience with databases so I'm trying to make it really simple for them. I may be understimating the intelligence of the users but if I can make a solution as bulletproof and intuitive as possible it'll be less work for me in the future.
  5. Happy holidays, everybody! (Please refer to the attachment.) This is a portal that lists company names from the CompanyName child table. On its right is a field (SortOrder) that contains a numeric value that a user would enter that in turn, causes the company names to change their sort order in a different part of the solution. That part works fine. To make it a little more elegant/easier for the user to enter a number in SortOrder, I'd like to create a dynamic value list from which it would list numbers from 1 to X, with X being the count of records inside the portal, e.g., if there are 8 company names within the portal then the value list would contain the numbers (sans commas) 1, 2, 3, 4, 5, 6, 7, 8. The user would then go down the SortOrder column selecting from the value list until all the numbers are used. I tried a few calculations but none of them worked so your help would be appreciated. TIA for your assistance!
  6. Thanks for the reply! I took your lead and constructed the equation as: Case ( PatternCount ( List ( STANDARD_1::PassedYN__lxt ) ; "Yes" ) ; "Yes" ; "No" ) On second thought, the result of that can be the flag so I don't need a second field to act as one.
  7. Happy holidays, everybody! Simple request: I want to set a calculated flag in a parent table's field so if any of that parent record's children has the word, Yes, in a specific text field it would set a value in the flag field. I tried the following but the syntax is getting the better of me; as always, your help is greatly appreciated! The flag calc is easy; the ExecuteSQL syntax is hard. Of course, if there's a native way in FileMaker Pro to do it I'm all for it! Parent table name: TEST Child table name: STANDARD_1 Fieldname in TEST: YesFlag__lxt Fieldname in RESULT: PassedYN__lxt ExecuteSQL ( "SELECT COUNT ( STANDARD_1::PassedYN__lxt ) FROM RESULT WHERE STANDARD_1::PassedYN__lxt = 'Yes' " ; "" ; "" )
  8. Thanks. Yeah, I wanted to keep it inside its popover (you can't tell from the screenshot but it's a popover) but what can you do. : S “A foolish consistency is the hobgoblin of little minds..." --Ralph Waldo Emerson
  9. A change of aesthetics in a solution is forcing me to change from a portal to a pop-up menu and I don't know how to re-code the existing script; the portal works fine so I know the relationships are good, just that I don't know how to script a pop-up to pull the URL from a related record then use the OpenURL command. The related table has two fields, URL__txt (which holds the actual URL) and Value__txt (which has the name for the URL). In the portal at right, a button--made from the Value__txt field--when clicked, uses the OpenURL command to open the URL stored in URL__txt. So far, so good. The pop-up menu on the left, in the local table, has all the values of Value__txt; I use a global field for temporarily storing Value__txt's value. Question 1: Should the global field be stored in the local table or in the related table, or does it matter since it's a global field, anyway? Question 2: I'm attaching a script trigger to the pop-up menu so when a user selects the name for the the URL, it'll fire the script to open the web browser to URL__txt. So, here's the big question: How do I set up the script to do that? Do I use GetValue and loop it so it compares what's in the global field to what's in Value__txt then when found, it somehow retrieves the URL__txt? That seems like a klunky way of doing things...though it might be the best way of doing things, I don't know. As always, any help would be appreciated. Cheers!
  10. I'm scratching my brain raw as to why this is happening: same layout setup, settings are the same in the layotu setup, same (defunct) Electric theme; on a Mac, FMPA v16. Image 1 (from Layout "A") After clicking a button that fires the Adjust Window (Resize to fit), it sizes the window correctly. Image 2 (from Layout "B") After clicking a similar button. Notice the bottom-right corner. Image 3 (from Layout "B") I stretched it the window to the bottom-right so you can see it's the same as in Image 1. What could cause this to happen? There aren't any objects in the layouts so...?
  11. Greets, all: I have a two-part question: Currently, when a user opens a URL in FM-GO, it's a two-step process for them to get to Safari so they have access to the slider in the iPad that splits the screen into halves or 1/4-width. A better solution would be to use the Web Viewer in the existing tab panel on the layout but there's doesn't seem to be much functionality to it--it's _very_ basic; I need it to do everything that you can do with/in Safari. Am I missing something in the Web Viewer or does it really such limited functionality? Plan B: Back to the slider... To save real estate, a possibility would be to make a narrow-width, but vertically lengthy, layout but with about 30 different fields that need to be readily accessible to the user so s/he can copy-and-paste the contents from those fields into a web form. I thought of possibly positioning them linearly (vertically) but then how would I enable the user to scroll through them like s/he would would in List mode or in a portal? I tried a self-join portal but that didn't work because it showed one record after another scrolling down the portal; I want it so a user can scroll through the litany of fields but _only_ for the current record. Is there a way to pull that off? Any more of these brain hernias and I'm going to have to go to Costco for another bottle of Tylenol. TIA for your help!
  12. Thanks--great idea about using the Country field with a calc. I forgot to mention that this is in FileMaker Go, so no tooltips. : (
  13. This is a stylistic issue: I have a calculation field (text) that displays a three-line address: Street Address City / ST / ZIP Country The field is clickable so when the user clicks on it, it copies the entire address into the clipboard so it can be pasted in a non-FileMaker Pro form on-screen. To save vertical space in the layout, I want to display only the last line of that field that shows Country, but no matter how much I play with the controls in the Inspector--and adjust the field's height--I just can't get it to work. Is this do-able or no? TIA for your help!
  14. "Universal" Constrain --- Syntax

    Ah! Thanks. Just for the sake of (an) argument, say I wanted to constrain to a specific field but its contents could be anything (not empty); what would I replace "ID" with?

Important Information

By using this site, you agree to our Terms of Use.