Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Rich

  • Rank

Profile Information

  • Title
  • Industry
  • Gender
  • Location
    Lewis-Clark State College
  • Interests
    Ultralight flying and amateur radio.

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

Recent Profile Visitors

434 profile views
  1. Indeed, there are records where the Cad_Type__lxt field is empty so that would explain why there's a carriage return before the correct value. (Why it happens with the Set Field command and not as a calculation is still a mystery.) I take it, then, I should use the IS NOT NULL command so only those records with a value in Cad_type__lxt will be processed, but after multiple tries I just can't get the syntax right. If anyone could address that, I'd appreciate it.
  2. There's a bit of strangeness going on with this calculation between using it in a Calculation (text) field and populating a text field with a Set Field script step: ExecuteSQL ( "SELECT DISTINCT ( Cad_Type__lxt ) FROM VALUE_LIST WHERE Cad_FullName__lxt = \"_g_CadFullName__gxt\" AND CountryAbbreviated__lxt = \"_g_CountryAbbreviated__gxt\" " ; "" ; "" ; "" ) The calculation works fine by itself in the Calculation (text) field but when used in a Set Field script step, a line feed (or carriage return--I can't tell which) is inserted in the text field before the calculated result. Am I missing something? I could add a subsequent script step that would substitute the value in the text field with a calculation that would remove the line feed/carriage return but that's a bandaid approach to the problem; I'd rather solve it. TIA for your replies!
  3. It appears my request for help in the Value List forum ( https://fmforums.com/topic/103348-conditional-value-list-multiple-fields-in-another-table/ ) might be a little too involved to ask someone to tweak it for free so I'm going the "for hire" route to get it to worked on; please respond with your bid by mailing it rstuart @ lcsc.edu (sans spaces). To access the attached file, the account name and password are the same: admin What I want to do is have Company_CAD_Abbreviated__lxt field's use a conditional value list to present values using Company_CAD_Type__lxt and Company_CountryAbbreviated__lxt as keys/filters. For example, if Company_CAD_Type__lxt = ST and Company_CountryAbbreviated__lxt = US, then Company_CAD_Abbreviated__lxt should only show the fifty US states; if Company_CountryAbbreviated__lxt is empty, then Company_CAD_Abbreviated__lxt's value list should show all the values that have ST for Company_CAD_Type__lxt. Another example would be if Company_CAD_Type__lxt is PROV and Company_CountryAbbreviated__lxt = CA, then Canada's provinces should appear in Company_CAD_Abbreviated__lxt's value list; if no value is entered in Company_CountryAbbreviated__lxt then Company_CAD_Abbreviated__lxt's value list should show all the values that have PROV entered for Company_CAD_Type__lxt. If no value is entered in Company_CAD_Type__lxt then all the value will appear in the Company_CAD_Abbreviated__lxt's value list. My preference is to code the fix in e-SQL, if possible. Thanks in advance for your considereration; e-mail me if you have any questions. Rich JCC_Stripped.fmp12.zip
  4. VERY cool! By the looks of it, ExecuteSQL Hierarchical Value Lists would probably be the simplest way to implement the CVL--what do you think? Just change Region to Company_CAD_Type and County to Company_CAD_Abbreviated. Still, I don't know how to implement the WHERE part with Country as a referenced field. (I'm not at all proficient with SQL.) It would be tempting to include the City field (in that example) but that would mean changing the field order in the database which would confuse users: When addressing an envelope--which is (hopefully) familar to everyone--the order is name, adddress, city, state, ZIP, and country. To use the example in Adventure 1, the order would change to Country -> State -> City.
  5. Thanks for your patience, Steve--here it is, attached. Account Name and Password: admin JCC_Stripped.fmp12.zip
  6. I wish I could but it's a proprietary solution I'm working on so I can't upload it. I'll make a clone of it and will strip away as much as I can tomorrow (Monday) and will then upload it directly.
  7. Greets, all: I'm having a royal brain hernia trying to figure out how to create a conditional value list between two tables where there are multiple key fields. (Please refer to the attached.) In the JOB table there is a field, JOB::CAD_Type, which stores a handful of custom values for a value list: COMM, DIST, PROV, ST, and TERR. In the screen capture, I chose ST (for State) as a value for JOB::CAD_Type. To the right of it, under the pop-up value list, is JOB::CAD_Abbreviated--it gets its values from another table (VALUE_LIST) where you can see VALUE_LIST::Cad_Type (ST), VALUE_LIST::Country_Abbreviated (US). VALUE_LIST is a table dedicated to storing values that are used throughout the database/solution. (VALUE_LIST::Country_Abbreviated is underneath the pop-up value list.) What I want to do is filter the pop-up value list so that it only shoes pertinent Values per JOB table's CAD_Type and Country_Abbreviated fields. So, with ST in JOB::CAD_Type field and US in JOB::Country_Abbreviated, I only want the U.S.'s fifty states to appear in the pop-up value list. Another example would be if the JOB::CAD_Type was PROV and the JOB::Country_Abbreviated was CA, only Canada's provinces would appear in the value list. So far, I "get" that that Cad_Type and Country_Abbreviated will have to be key fields in both tables, but that's where I'm stuck. If you can point to, or upload, a solution I can parrot in mine it would be greatly appreciated! TIA for your help.
  8. Thanks! That solved the first part. I used this calculation: Substitute ( GetValue ( Syllabus__lxr ; 2 ) ; "FILE:" ; "" ) ...to remove the "FILE:" text leading the filename.
  9. I've been told by The Powers That Be that we don't have the money to purchase a plug-in to view .pdfs in externally-stored containers, so I need a native solution to accomplish that with solutions stored in FileMaker Server (Windows). Mind you, users won't be editing .pdfs, just looking at them. I perused this forum and found the suggestion in a post to open the .pdf using Open URL so it can be viewed in a Web browser but try as I might, I just can't nail down two tasks: (1) What script/calculation do I use to grab the .pdf's filename, and (2) Setting the path to the file in the Open URL script step. I included a screenshot of the paths. TIA for your help!
  10. I've read that container data shouldn't be embedded in a FileMaker Pro (FMP) solution because it can slow performance so external storage is a better way to go. I get that. However, I'm a little confused as to how to go about it even after reading the online FileMaker Help/Info pages. Here's what we have: a portal, accessible by IWP, where users will upload their .pdf's to our (virtualized) Windows/FileMaker Pro server by clicking the button, UPLOAD. Currently, .pdf's are embedded in the field, Container__lxr; the plan is to use SuperContainer--or some other means--to allow users to view the stored (or referenced) .pdf's instead of having to download them to be viewed later. In File > Manage Containers--and in the container field's Option tab--you can see what it looks like in the attached. Where to I go from here so an uploaded .pdf is stored as a reference (outside the solution) and it can be found by SuperContainer. (On that note, do I even need SuperContainer or is there a native way--say, using the web viewer, to view .pdf's?) I know any response will be lengthy so thanks in advance for your time and reply/replies. Cheers, Rich
  11. Ah! Brilliant! Thank you!! I'd like to send you a coffee card as a thanks for all your help--can I send it via your website link in your signature line? (Hopefully, I can snag a Timmys for you.)
  12. Looks great but we're not quite there, yet. I don't know how the dates I entered disappeared but they did somehow. Anyway, if a student takes the same test (code) more than once, the first time (date) the student takes it should have a First Attempt of 1/Yes; thereafter, 0/No. So, say for Record 1 (_p_ParentID) a student took test 5001 on 05-15-1999 and again on 01-20-2000, in First Attempt the 05-15-1999 date should be 1/Yes and the 01-20-2000 should be 0/No.
  13. It was easier to make a quick-'n'-dirty one so I've attached it. First Attempt.fmp12

Important Information

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