Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About amerioca

  • Rank

Profile Information

  • Gender
    Not Telling
  • Location

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10

FileMaker Partner

  • Certification
    Not Certified
  1. Hi Steve. Tnx for your reply. The fields look only clipped on the last screen shot. Happend because I tried to use a different theme. All fields are placed right into the center of the parts and are not overlapping. I have already tried to re-size the parts. But no success.
  2. Tnx for your input. All true what you are saying. That is why I don't understand, what happened here. However, I just tried to add another trailing grand summary part and really nothing has changed. Still have the blank space inbetween the footer and the now trailing grand summary part. Only difference is, that the space is white instead of grey because I change the theme. No idea, whats going on. I have some 4 more subsummary reports in the db and compared. No r difference in the setup really (exept for the different table and occurances used for the fields) . I noticed something else weird here on the right edge of the layout in browse mode. A small part of the blank area goes up into the subsummary part at the right edge. Getting really confused here.
  3. Tnx for your reply. Just checked and tried various themes. The blank area stays. It's just changing color depending on the theme. Looks like, this solution is not working for me.
  4. Hi everybody, looks like I do have a sort of rookie problem here. I created a subsummary report which is sorted by a break field and all works fine. All is fine in layout and preview mode. Just in browse mode I seem to have a problem. There is a large grey empty area just underneath of the subsummary part showing. Anyone with an idea what it is I messed up here? I already googled but just found 1 similar report from 2010. Sort of optically annoying. Any help is highly appreciated.
  5. Hi everyone I am working with filemaker on and off for the last recent years but, no doubts about it, I am still a rookie. lately I have created a db similar to a booking engine for shore excursions for river cruise ships. Lots of modules, layouts, scripts etc. As I really have to work with my limited knowledge, it took a long time and is not really constructed in a way any pro would do it with a lot of workarounds and probably sort of unorthodox. However, it works just fine for me and I am sort of proud, to have gotten to the point where I am. However, I am afraid, that I corrupted the whole thing somehow. No I am trying to integrate a sort of an accounting layout consisting out of a summary or subsummary report. The report contains fields from 4 related tables. and a summary field. The db has some 5 different tables and around 35 different active layouts. First problem is that my subsummary part, which I created with the New Layout/Report assistant, does not show up at all in browse mode. I have tried to base the layout on all 4 tables, but it seems not to be working. The second problem is that the summary field is not working and producing some random weired numbers instead of the summary of the field it is assigned to. On the attached pics I have placed the summary field into the bottom in order to demonstrate the results. In every ordinary case it is located in the subsummary part. I have played around here a lot. deleted it, created a new field, created a new layout etc, etc, but it just won't calculate the value of the field it is assinged to. Anyone any idea, of what am I doing wrong here? Tnx for any help in advance.
  6. I have created a list report with a value list assigning values to fields of certain colours. All from 1 table – no related values. Layout is based on the same table. The script filters the number of records with a certain colour. The script button is located in the footer of the report. Excursion scripts: Departure show Pink Set Variable [ $DeptG; Value:customer::Dep_Date ] Go to Layout [ “Departure_List” (customer) ] Enter Find Mode [ Specified Find Requests: Find Records; Criteria: customer::Bus_Color: “=Pink” ] [ Restore ] Commit Records/Requests Set Field [ customer::Dep_Date; $DeptG ] Perform Find [ ] (This script is assigned to 6 different buttons for each colour) Every colour is assigned to a certain text value assigned by value list, which should show up in a calculation field in the header of the report for print purposes The calculation field has a formula stored: Case ( customer::Transpo 1 = "Rail" ; "Rail" ; customer::Transpo 1 = "Globus Garage" ; "Globus Garage";Transpo 1 = "Gambrinus"; "Gambrinus";customer::Transpo 1 = "Tefra";"Tefra";customer::Transpo 1 = "Sprinter";"Sprinter";customer::Transpo 1 = "Individual";"Individual" ) I am encountering 2 problems: 1.) When I trigger the script, the calculation field comes back with random values from the value list, but never the one set in the value list. It also somehow resets the value list to a random value not matching the calculation. It’ all messed up. 2.) Whenever I click next to the records in the list, the values in the calculation field as well as in the value list disappear which spoils the purpose of printing the list. Anyone with an idea, of where I messed up? I am sort of a rookie and assume that I have messed up something very basic here.
  7. Hi everybody, I recently amended a db from an old Lynda course, controlling shore excursions for river cruise ships. For my limited expertise (I am still a rookie at the very best) the construction is somewhat complex as there is many vessels, different routes, different charterers and consequently different shore excursion programs and prices. In some cases the shore excursion program of different vessels and operators is similar but not the same and so on. I have 7 different tables partly related (pls see graph attached): For every journey ::customers and ::trip are assigned a tour code and date (“tour code” is not unique as journeys repeat themselves during the season, “Tour Code” in conjunction with “Date” is unique) Every tour operator/vessel has many trips on every journey. All table occurences and fields are uniquely defined by unique id. Now I want to create an opening layout reflecting all relevant cruise information such as passenger list from ::customer and ::trip (shore excursions) for the specific journey, as well as other information in text fields. But I seem to be unable to get the right relationship and layout setups together. I tried all possible relations and layout setup combination but nothing worked so far. On the same layout I was able to either retrieve the passenger list from ::customer for each journey or the offered shore excursion (trip) list from ::trip but not both together on one layout. What is it, I am doing wrong? Any ideas are appreciated
  8. Tnx for your detailed replies and sorry for not being more clear. The db reflects all passenger activity such as passenger information, shore excursions, cabin no’s, cabin changes, charges, invoicing, arrival and departure list, complaints etc etc. During a cruise with a lot of passengers, there is a lot of searching, filtering and isolating records on an almost hourly base. Not all passengers go on every shore excursion, or change cabins or arrive/depart on the same vehicle or from the same departure point. The db is supposed to filter this information with detailed reports, for every activity of the current cruise (tour code). As a result I am getting detailed reports on every single shore excursion sales, capacity planning on shore vehicles cabin changes, charges etc. etc. But once finishing one search request, the very moment, a different passenger shows up with a different request, I have to go back to ‘show all records’ I will get all records from all cruises and all vessels from the past, which it is a lot of data and complicates every process significantly. I know that I could write a script with extended search and filter parameters but I would have to add that script to almost every single layout and constantly change the search parameters. A filtered portal is also not an option, due to the enormous amount of data and reports for every single cruise On opening I would require only records of passengers and shore excursions of the very Tour Code we are currently operating. Meaning, that I intent to permanently isolate all records from previous cruises and only see the ones of the current one for the entire session. The filtering by date I require for the very reason, that one vessel sails the same itinerary various times per season with different passengers. What would be the best way to achieve this?
  9. Hi everyone, first of all, I am a rookie and have limited knowledge. This is actually my first more complex db I have created or worked with. I have ammended a db from a lynda template which basically controlls shore excursions, booking and passenger activitiy records for river cruise ships. However, I work for various different companies on different vessels and everyone has partly the same and partly different shore excursions on offer with different prices and details . Additionally every operator has some 10 - 15 different itineraries on offer, which are offered with different tour codes and dates. With the high amount of vessels, itneraries, passengers, different excursions and prices for each operator I want to create a priviledge set which, on opening only shows the records of a specific tour code and date and permanently ommits all other records during the user session. User X (which is the tour code) can only see any record with the tour code X. This procedure is not meant to be a protection but simply a functionlality. The Tour Code acts as a user name. The db opens with the customer layout. As a signin page I still have to create, would need two fields to filter records by user session. One for the tour code and one for the date as many trips are repeated during the season. I have tried various privilege sets but seem to be unable to get it done right. Here attached, where I stand. I have tried many different options but the ones on the screen shots is the last, I have tried. I keep getting error messages (access denied) when I try the different options. Any help is highly appreciated
  10. Iam certainly not a professional filemaker developer but try to work around problems (problems for me not for the pros) but this easy thing here drives me nuts. I am trying to hide the toolbar for all layouts (about 80) based on privilege set. I have placed an opening script in the File Options but what it does, it only hides the toolbar for the first/opeing layout not for the rest. Any tipps here are most welcome. Merry x- mas for all Opening script Allow User Abort [Off] Set Error Capture [On] Perform Script [“hide toolbar test”] -script supposed to hide tool bars for all layouts (If [Get ( AccountPrivilegeSetName ) ="Operations"Show/Hide Toolbars [Lock; Hide] Else Show/Hide Toolbars [show] End If #---------File Opens on L000_Opening Window to speed up the open process. #-------------by not loading any screens and images and then performs this Startup Script # Freeze Window # #--------------------------------------Checks Staff Account for UserName # Go to Layout [“L131_STAFF_List_View” (T17_STAFF)] Enter Find Mode [ ] Set Field [T17_STAFF::FileMaker_Account; Get(AccountName)] Perform Find [ ] # If [Get(FoundCount) = 1] Set Variable [$$Name; Value:Get(AccountName)] Set Variable [$$CalendarFilter; Value:Get(AccountName)] Else Set Variable [$$Name; Value:Get(UserName)] Set Variable [$$CalendarFilter; Value:"-All Users-"] End If Show All Records Go to Layout [“L0_Opening Window” (T14_PREFERENCES)] Set Field [T14_PREFERENCES::g_Name; $$Name] #-------------------------------------- Set initial Session Globals for Invoice Line Item Management Set Field [T12_INVOICES::g_Search; ""] Set Field [T12_INVOICES::g_Product Category Filter Popover; "Product"] Freeze Window # #--------------------------------------If the PatternCount = "Pro" - Desktop # If [PatternCount ( Get ( ApplicationVersion ) ; "Pro" ) = 1] Set Variable [$$Device_Mode; Value:"Pro"] Go to Layout [“L1_Home” (T14_PREFERENCES)] Adjust Window [Resize to Fit] Move/Resize Window [ Current Window; Top:(Get ( WindowDesktopHeight ) / 4) - (Get ( WindowContentHeight )/4); Left: (Get ( WindowDesktopWidth ) / 2) - (Get ( WindowContentWidth ) / 2)] Perform Script [“ (0831) Map Start Up”] # End If # #--------------------------------------Sets the window title as the name of the file.
  11. Tnx. Sorry for the trouble. I have copied and pasted your suggestion and works smooth as baby skin. Btw. just for clarification: The field Note_Type is the one, which has the value list assigned. Tnx once again. Problem solved.
  12. Tnx for your quick reply eos. But what the situation is somewhat different. This is basically portal which is only relevant when one of the mentioned "expressions" come up in the note_subject field which is based on a value list with 12 different options. Product Testing, Assessment and Trial are the only ones where the portal is required. Meaning that Product Testing, Assessment and Trials are not fields but values within a value list. Any idea?
  13. Hi, there I am trying to hide a portal under certain conditions and it works fine with one condition but the moment I am applying more then one it does hide anything at all anymore. Here's what I did. T16l_projects_NOTES||id_note|::Note_Type ≠ "Product Testing" or T16l_projects_NOTES||id_note|::Note_Type ≠ " Assessment" or T16l_projects_NOTES||id_note|::Note_Type ≠ "Trial" It all comes down to a drop down list of notes while the portal is only required for this 3 options anyone able to help. highly appreciated.
  14. Richard, pls ignore the above posting. I have simply given the QTY field a validation. Hence it still creates problems tranfering Estimates to Invoices but does the job for the time being. Tnx again for your support.
  • Create New...

Important Information

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