Jump to content

tdub808

Newbies
  • Content count

    8
  • Joined

  • Last visited

Community Reputation

0 Neutral

About tdub808

  • Rank
    member

Profile Information

  • Title
    Photographer
  • Industry
    Photography
  1. A4 Layout ready to print

    In case someone else (like myself) run into the issue of Preview Mode or Prints only showing the first page number on all the pages. i.e. Page 1 of 15 on every single page. Solution: Uncheck "Restart page numbers after each occurrence" in Layout Mode --> Double click on the footer part or tab. Now it should show Page 1 of 15 on the first page, Page 2 of 15 on the second page, and so on. Cheers!
  2. Aloha All, DISCLAMER I'm not a programmer nor a technical writer and also is ESL. So my writing is tailored to me or someone like me aka noobie as F* (toward me not you). Detail and step by step and as clear as possible. Please let me know if i’d missed something or grammar correction. System: As of 04-20-2016 (not potting around) macOS 10.11.4 (yeah I’m using macOS name form now on instead of OS X), iOS 9.3.1, Filemaker Pro Advance 14.0.5 and GO 14.0.4 OBJECTIVE Make merge variable to show the slide control panel's object name (the name of the front most slide panel). So when the file is open the merge variable will show the name of the from most slide control panel letting you know which slide you're on. ISSUE Merge Variable does not show value on open first window. Please read entirety below. WORKAROUND Although it's a lame hack that I prefer not to use but it does the job. I'd included these two ugly steps in the script Go To Object [ Object Name: "Panel2" ] then Go To Object [ Object Name: "Panel1" ] to have the merge variable show Panel1 name on opening of the file. # the number symbol or the hashtag is to comment as a note to yourself and others about the script line(s) (ignored when the scrip is performed functional line). Set Variable [ $$panelName; Value:GetValue ( Get ( TriggerTargetPanel ) ; 2 ) ] #The "2" is the result value which is the name of the objectName that you gave it in the inspector panel. Number "1" will return the number of the panel. As in 1 (which is the first) of 3 panels or 2 (which is the second) of 3 panels or 3 (which is the third) of the 3 panels. Go to Object [ Object Name: "Panel2" ] Go to Object [ Object Name: "Panel1" ] #Refresh Window will work the same but I think it'll refresh the whole layout. FYI: "MVpanelName" is the object name of the merge variable "<<$$panelName>>." Refresh Object [ Object Name: "MVpanelName" ] ENTIRE HOW TO Create a new file. Choose File menu > New Solution… https://www.filemaker.com/help/14/fmp/en/html/create_db.8.5.html Enter Layout Mode. Choose View menu > Layout Mode or press COMMAND + L keys. https://www.filemaker.com/help/14/fmp/en/html/fmp_basics.3.7.html Insert Slide Control. Choose Insert menu > Slide Control https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.42.html Name the each slide panel. Choose View menu > Inspector or press the COMMAND + I keys. Choose Position tab > Enter Name field. Press the Enter/Return key to commit the name to the object. http://help.filemaker.com/app/answers/detail/a_id/6147/~/naming-objects-in-filemaker-8.5-and-later Choose the next slide and repeat. Create a script with the above script. Choose Scripts menu > Script Workspace… Type or copy and paste the script in the code box above in the the WORKAROUND section of this post. https://www.filemaker.com/help/14/fmp/en/html/create_script.14.3.html Choose Insert menu > Merge Variable. Name it the EXACT same as the name use in Set Variable objectName ($$panelName). https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.35.html#1064499 Set File Script Triggers. (not a 100% sure this is needed) Choose File menu > File Options... Choose Script Triggers tab > click checkbox OnFirstWindowOpen > click Select button > choose your script > click OK button > click OK button. Set Layout Script Triggers. (not a 100% sure this is needed) Choose Layouts menu > Layout Setup... Choose Script Triggers tab > click checkbox OnLayoutEnter > click Select button > choose your script > click OK button > click OK button. Set Object (slide control) Script Triggers. (this is a must) Right click on the Slide Control Panel object > select Set Script Triggers... Click checkbox OnPanelSwitch > click Select button > choose your script > click OK button > click OK button. Enter Browse mode. Choose View menu > Browse or press the COMMAND + B keys. SEEKING HELP Please reply if you have a better solution to this terrible workaround. Mahalo All!
  3. How do I start this?

    comment thank you so much for the script step above! Also, a big thank you for being very patience with me in clearing out my fog of thoughts on this solution! I'll give this a go tomorrow and update this post to reflect the working solutions (if it works). You will be heavily credit of course. One last thing, the admin move this post into Value Lists category as he thinks it's best fit. Any thoughts as to why it would make sense for Value Lists to be a fix for this solution? In the meantime, I'm going to read up on it with this http://help.filemaker.com/app/answers/detail/a_id/5833/~/creating-conditional-value-lists. Always grateful for your help comment!
  4. How do I start this?

    Yes, a new consent form is create for each shoot and the only things would be different is the date stamp, info pertaining to that particular shoot (such as location, description of production), and he/she signature. Only the contact info will be reused when available.
  5. How do I start this?

    commit thank you for the example. It really help to give me some structure and clarity to my thoughts on how to approach this. You're making what seem difficult and near impossible for me to figure out into something that's giving me confident and hope to completing this. I'm very excited about working this solution out with your help and maybe others too! Deeply grateful! Here's my current paper trail solution: Client/model want to be photograph --> I then collect basic info (name, phone, address, etc) --> If client/model agreed to the terms laid out then a consent form is generated. At which point on paper Client/model would write all that in --> The are given a copy. Here's my idea for a digital workflow options: Option #1: Client/modle want to be photograph --> I open the CONTACT file --> Perform a find/search for their name --> If the result is no match found --> Create new record --> Then collect basic info --> If client/model agreed to the terms laid out --> Click on a button to create a new CONSENT form record--> FM script would auto populate the basic info in the CONSENT form record that was created. --> All the client/model would need to do is sign in the signature box --> Then I would click email copy to client/model's email address --> Done Option #2( this now include your suggestion): Client/model want to be photograph --> If client/model agreed to the terms laid out --> I open the CONSENT file and create a new CONSENT record--> client/model enter their name(s) into global field(s) --> This would somehow automatically perform a search as each key is entered (if possible by FM) OR triggered on exist of the last field entered --> Then a script would perform the find, create a new contact record if no existing record was found, grab the new/existing record's ContactID value, and set the new consent record's foreign key value to that. [ Would this populate the newly created CONTACT record with the basic contact info that was entered in the CONSENT form record fields? ] --> All the client/model would need to do is sign in the signature box --> Then I would click email copy to client/model's email address --> Done I hope I'd clarified my thought on this solution. I'd would appreciate your feedback on the two digital workflow options. Again, deeply grateful for your help on this!
  6. How do I start this?

    Thank you so much comment! You word it perfectly and is exactly how I need to start! This help so much already. So here's what I'm thinking in term of the workflow and correct me if I'm wrong: Weather the client is a new client or not they will perform a search for their name in the CONTACT file. If there is no match then give them the option to creating a new CONTACT record. Once either an existing CONTACT record is found or a new record is created in the CONTACT file the client have the option to click on a button to create a new CONSENT form. This will automatically populate the client's CONTACT info to the newly created CONSENT form. So I'm thinking it's something have to do with portal to the related record. Now this is somewhat familiar to me if I may have sense this somewhere. I'll search for it and will update if I can find it. So is there a method and/or either this is possible in FM for the workflow below? I guess the objective is to reduce the complexity and improve usability aka ease-of-use for the user and not the tech. Create a new consent form. User type in contact info. As data is inputed it automatically check the Contact file for a match. If FM can't perform this auto-checks then maybe on click of a button to perform a script to check? If match show a listing of match name for user to pick. If no match, ask user to create a new contact record. Contact info is then auto populate in the Consent form and consent form record is then associated with the contact record. Thoughts on this?
  7. How do I start this?

    Aloha comment, Thank you for your prompt reply. To clarify I do not want to create any duplicate records nor do I want to import the CONSENT table into the CONTACT. I'll update the post to reflect this. I want to be able to type the name in the name field of the CONSENT table and have it reference the CONTACT table to see if there is a matching name. If there is a matching name then DO NOT create a new record with the same name in the CONTACT table. Also, that CONSENT record must relate to that name used in the CONTACT table. This is so that I can see how name CONSENT forms are associated to that one name. Now, if there is no matching name then use that name that was just inputed in the name field of the CONSENT record to create a new CONTACT record with that name. Essentially automatically creating a new CONTACT with that new in the CONTACT table. I hope this clear that confusion up. I'll check out your link. Again, Thank you!
  8. How do I start this?

    Aloha Everyone, First off I'm ESL and my gramma is not up to par with an English major. Second, I'm a photographer and not a programmer. That said, I am determine not to let that stop me from learning FM enough to program me a simple but functional DB. I'm familiar enough to understand and get around FM and it's back end but have not spent enough time to know it intimately like one who spend everyday in FM. In other words, I know basic of FM parts and functions and attributes but have not had the opportunity to learn how to connect everything together to make one simple idea to work. Lastly, I'd greatly appreciate you all for taking the time to help me with my issue. I'd only ask if you all can be a little bit more descriptive in your answer then a vague simply answer like "you should use a calculation." Here is my simple idea but seem complex issue for me: I have two files, one is a CONTACT file (the starter kit) and another is a CONSENT file I'd created from scratch. Both files have the corresponding table names. I want to be able to type in the name fields of the CONSENT file to check the CONTACT file for a matching name. If there is a match then use that name and associate the CONSENT record to the CONTACT record. If there is no matching record in the CONTACT file then create a new record in the CONTACT file with the name that was entered. UPDATE for clarity: To clarify I do not want to create any duplicate records nor do I want to import the CONSENT table into the CONTACT. I'll update the post to reflect this. I want to be able to type the name in the name field of the CONSENT table and have it reference the CONTACT table to see if there is a matching name. If there is a matching name then DO NOT create a new record with the same name in the CONTACT table. Also, that CONSENT record must relate to that name used in the CONTACT table. This is so that I can see how name CONSENT forms are associated to that one name. Now, if there is no matching name then use that name that was just inputed in the name field of the CONSENT record to create a new CONTACT record with that name. Essentially automatically creating a new CONTACT with that new in the CONTACT table. This is what I have going so far: I have related the two files. With just the Manage DB relationship and field auto-enter calculation I'm able to auto complete the name and create a new record. However, this just create duplicates contact record which is a no go. I know this is not the way to go and assume it's either a combination of calculation and/or scripting. I just don't know where to begin. How do I start this from a step by step instruction? Please feel free to ask me for clarification and I'll do my best to make sure we're both on board with our understanding. Again, thank you for your kindness for taking the time to help out on my problem! Mahalo all!
×

Important Information

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