Jump to content

Search the Community

Showing results for tags 'portals'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
    • FileMaker Videos
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Proof+Geist
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics

Blogs

  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting

Categories

  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development
  • FileMaker Hosting

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

  1. First, I appreciate any help I can get as this project has been evolving over two years and, as these kinds of projects to, has become more involved and complicated over that time. I've posted related questions, but exploring other parts of my project. As I'm not a programmer, but a sort of user nerd, my inquisitive mind wants to learn, but sometimes simple concepts elude me. Feedback, both on the specific goal at hand as well as the project overall is always appreciated. Performers is one piece of a much larger project, but I'm trying to enhance the project and working on a piece at a time. BACKGROUND I'm sharing the entire project layout to provide some insight into how the parts fit together. The application is a booking management tool for performers, consisting is several tables as shown: Again my focus right now is the Performers table and how to use it in relation to the Gigs (and Gigs~Songs_Join) tables. There is a Gigs layout which is the hub for performances by one or more Performers. On that layout is summary information about a gig and a portal which shows which songs were performed and in what order (Set & Slot fields). The portal also includes a Performer Name. The assumption at this point is that up to 4 performers will do a given gig. This might change in the future, and could impact the below goals. Gigs~Songs_JOIN is a connecting table for Gigs, Performers, Songbook, Venues, Musicians, etc. Performers is a table of singers and includes fields for a serialized SingerID, name, area of speciality (Tenor, Baritone, etc.), etc., and additional fields for combinations of the same performers including: Multi: checkbox-indicates this record is more than one performer PerformerName: calculated based on Multi: if NOT Multi, show performers Name, if Multi, show MultiName (below) Type: value list-is this a duet, trio, quarter, all, etc. MultiName: the description of this record (i.e., Duet-Clayton/Vicky) Other summary fields include: Total Gigs: count of gigs in which this person has performed Total Songs: count of songs this person has performed GigID: match field to Gigs~Songs_Join GOAL I have two goals, one related to the other. First, if the Performer record is checked Multi, I want to "attach" or "associate" individual singer(s) to the record (i.e., show what people are "included" in the MultiName). For example, MultiName=Duet-Clayton/Vicky, I want to show that Clayton and Vicky (each in separate records) are part of Duet-Clayton/Vicky. Second, ultimately on the Gigs layout, I want to show which Performer sang which song (currently works in the portal), but more importantly, show variable summary information (goal layout below) which changes for each Gig as to each Performer, how many songs they sang and the total amount of time they sang. The catch is, in the summary I don't want to show the Multi records, but instead increment individual singers. So, in the summary info with related portal records in the example below, rather than showing Clayton sang one song, Vicky sang one song and Duet:Clayton/Vicky sang one song, I want to show Clayton sang 2 songs and Vicky sang 2 songs. In summary info, Duet:Clayton/Vicky wouldn't appear. In other words, the summary would show how much time each person was singing. In the summary block of the Gig's layout, each of the above sets is a one-row portal filtered by set. I want to have the SINGER1,2,3,4 replaced with the actual Performer's name, and each band/portal show summary info for the appropriate singer. Here is my relationship graph:
  2. We have a Filemaker Go on iPads and there is a layout with portal rows, when scrolling through it hesitates and you must wait to scroll down. We have offline files on the iPad, although it happens when we connect to the Filemaker server as well. Any suggestions? Thank you, Caroline
  3. I'm hoping someone might be able to help, or at least point me in the right direction. I'm creating a portal that displays a student photo, but would like the ability to navigate forward/backward through the photographs in the portal without the vertical scroll bar. My < and > buttons currently point to a Go to Portal Row - Previous/Next script step. It works great when "Allow vertical scrolling" is turned on, but does not work with it turned off. It does work with Allow vertical scrolling turned on and show scroll bar set to "When scrolling", however, the scroll bar appears on mouse-over. Any suggestions on how I might be able to achieve this? Many thanks! Matt
  4. Hi everyone,i have an issue, maybe one of you could guide me, I have grouped a set of records into a portal (it could be more than 1000 records), each row has a pop-over button that display some actions over the record, but the popover is too slow when i try to open it, does anyone know the reason of this behavior? how can i solve it? Thanks, Jhon
  5. Hello there. First of all im newbie in fm. I use the filemaker 16. I want to make a new base that keeps track of pages and especially registerstations and log ins. So i created 5 tables: "sites, user_names, passowrds, emails and account_descripion) I linked the tables with relationships. I created a portal witch have fields from three different tables, a field user_name from table user_names, a field password form table passwords and a field email from emails table. When i insert the first line(raw) in the portal ιτ seems to work. but if i try to insert values in the second line (say in a site you vave two accounts like facebook one ofiicial and the other one "a fake account") it seems that something is not working properly. I upload a 3m12sec video to show you what i mean. Please check it if you have the time. Also, the source file that im working on is in this link (filemaker 16 file): https://drive.google.com/file/d/1zW1jC6-dL1I9zEplo7Xw0dL3Wy8onKkl Thanks for your time
  6. FileMaker Coaches' Corner - Tip 5 - Portal Record Moving via Sort https://youtu.be/pVt432ZlTVs For this Coaches’ Corner tip, Kristian Olsen explores using sorts to move a portal record up or down. The key is Sorts! Grab the sample file here: http://bit.ly/2FTJn3k http://www.fmcoachescorner.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Looking for FM Starting Point free software download: http://www.fmstartingpoint.com Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web Transform your business with the FileMaker Platform Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos 50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=KpQqLLDcZ8I Playlist https://www.youtube.com/watch?v=KpQqLLDcZ8I&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_&index=13 Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16 https://www.youtube.com/watch?v=urh8iHOCxkg Playlist https://www.youtube.com/watch?v=urh8iHOCxkg&t=130s&index=1&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing https://www.youtube.com/watch?v=GF82vkYtCtA Playlist https://www.youtube.com/watch?v=GF82vkYtCtA&index=8&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=uaZKIpBjMAM Playlist https://www.youtube.com/watch?v=uaZKIpBjMAM&list=PLjTvUZtwtgBSVV1-4pFG4SHAhCIP3Yy-I&index=17&t=10s A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project http://learningfilemaker.com/FIAS.html https://sites.google.com/site/filemakerprotrainingd2n/home/filemaker-training https://drive.google.com/file/d/0ByHcthu5EL9NSmowQm9OUDdZZ1k/view?usp=sharing Free FileMaker videos check out ...http://www.filemakervideos.com Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review https://www.youtube.com/watch?v=mF6Uor0KmKo Playlist https://www.youtube.com/watch?v=mF6Uor0KmKo&list=PLjTvUZtwtgBT8tNHuzF6cOKC_37zCTQl6&index=18 Use FileMaker to create an app with the FileMaker Training Series FileMaker Pro is a cross-platform relational database application from FileMaker Inc. Comment, Like & Share Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media https://www.facebook.com/FileMakerVideos https://twitter.com/filemakervideos https://plus.google.com/+FileMakerVideos/videos #FileMakerCoachesCorner #FileMakerPro16Training #FileMakerPro16Videos Playlist: https://goo.gl/ycpCqW Google RSS Feed : https://goo.gl/hxtYvW
  7. For this Coaches’ Corner tip, Jonathan Lai demos a simple technique for creating a hierarchical portal i.e. a portal with dynamic sub-summaries. You can actually display or hide sub-summary groups! Very cool technique. Link to the demo file used in the video: http://bit.ly/2zaI9zo FileMaker Coaches' Corner - Tip 2 - Portal Filtering - Portal Sorts https://www.youtube.com/watch?v=JJiQ-50Hps8 www.fmcoachescorner.com Most Recent Upload https://goo.gl/Dbn9fm Get up to speed with the FileMaker Pro 16 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference, Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client-server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Looking for FM Starting Point free software download: http://www.fmstartingpoint.com Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web Transform your business with the FileMaker Platform Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos 50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=KpQqLLDcZ8I Playlist https://www.youtube.com/watch?v=KpQqLLDcZ8I&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_&index=13 Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16 https://www.youtube.com/watch?v=urh8iHOCxkg Playlist https://www.youtube.com/watch?v=urh8iHOCxkg&t=130s&index=1&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing https://www.youtube.com/watch?v=GF82vkYtCtA Playlist https://www.youtube.com/watch?v=GF82vkYtCtA&index=8&list=PLjTvUZtwtgBTMCfjM6LLwBAwGf_yXfvd_ Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos https://www.youtube.com/watch?v=uaZKIpBjMAM Playlist https://www.youtube.com/watch?v=uaZKIpBjMAM&list=PLjTvUZtwtgBSVV1-4pFG4SHAhCIP3Yy-I&index=17&t=10s A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project http://learningfilemaker.com/FIAS.html https://sites.google.com/site/filemakerprotrainingd2n/home/filemaker-training https://drive.google.com/file/d/0ByHcthu5EL9NSmowQm9OUDdZZ1k/view?usp=sharing Free FileMaker videos check out ...http://www.filemakervideos.com Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review https://www.youtube.com/watch?v=mF6Uor0KmKo Playlist https://www.youtube.com/watch?v=mF6Uor0KmKo&list=PLjTvUZtwtgBT8tNHuzF6cOKC_37zCTQl6&index=18 Use FileMaker to create an app with the FileMaker Training Series FileMaker Pro is a cross-platform relational database application from FileMaker Inc. Comment, Like & Share Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media https://www.facebook.com/FileMakerVideos https://twitter.com/filemakervideos https://plus.google.com/+FileMakerVideos/videos #FileMakerCoachesCorner #FileMakerPro16Training #FileMakerPro16Videos https://www.youtube.com/watch?v=4ozLZaRUgZ0&feature=youtu.be
  8. I am trying to make a checklist for tasks that attaches to different records. Ideally I would have a table that keeps track of the tasks but I also need it to connect to each object. So for example, on November 1 , 2017: -Object 102 was washed and wax -Object 103 was dusted -Object 104 was washed with power hose -Object 105 didn’t have any work done to it. All the objects (102-105) are in a table that I'd like to remain static, and acting as a primary key. I’d like to create another table that has a record of what was completed for each day instead of creating a new record for each object and the particular thing that was done for it that day. This table would ideally have: -Date (so a new record for each day) -Object number (that connects to another table) -& A checklist (Checklist options for each object number would be: Dusted Washed regularly Washed with a power hose Waxed No work As well as a space to add notes for the day or notes for the day for each object. Is there a way to create this or is this not possible? (sidetone: Ideally I'd like to mount this on to an iPad for easy record keeping in situ. I'd love to get any tips or ideas! Thank you!
  9. I am struggling with something that should be simple, but cannot figure it out. Below are three tables: Contacts, MaterialsTransactions, and MaterialsTransactionLineItems Within a layout showing records from the Contacts table, I created a portal showing records from MaterialsTransactionLineitems (so contacts could see each item and not just each transaction) Layout = Contacts Table; Portal = MaterialsTransactionLineItems The field on the left is MaterialsTransactionLineItems::Transaction_fk; the field on the right is MaterialsTransactions::TransactionDate Given the relationship, why is the date not showing correctly? Instead, just showing first record for all? Is it the relationship, or the way I have created the portal... both? Thanks
  10. Hello everyone, I have found a stange behaviour with filemaker. I have two tables linked by a third one. I want to navigate using the portal. But if I use a script on layout exit, then the behaviour is abnormal. Please have a look at the enclosed database and try normal, then abnormal layout. Please tell me if you consider that it is a bug or not. If it is a bug, should I report it to Filemaker Inc. and how? Thanks for your help, Regards Possible bug.fmp12
  11. Hello, I am back to working in FMP after a multi-year hiatus, and I am rusty and am currently stuck. Hoping someone can point me in the right direction. I hope I am posting in the right topic. I am building a solution where we have a number of many-to-many relationships that are being used via portals. This is the issue that I am having that I am stumped on. In this instance I have the following db graph: Workshops <--=--> WorkshopStaff <--=--> Staff Each workshops may have multiple Staff and Staff may participate in Multiple workshops On the Workshops layout I have a portal to WorkshopsStaff In order to add Staff to the Workshop I have a button that brings up a popover with a portal that lists all Staff from which to select. I can select a Staff Member and they get added to the WorkshopStaff table. This popover was more or less modeled on the "invoices" starter solution The way I am displaying the portal inside the popover is via a table occurrence like this: Staff <--X--> StaffList (Cartesian relationship) My issue is that the portal in the popover (the result of the cartesian relationship) displays and works as intended as long as I have one related entry in the WorkshopClient table. But for a new Workshop for which I don't yet have any entries in the WorkshopClient table the portal in my popover comes up empty. What I am doing wrong or is there a better way to populate the list from which to select staff? Thanks a bunch. -J
  12. I am so frustrated after two solid days of working on this really simple join table example. I am trying to create a little iphone application in which I can quickly track my homeless outreach contacts on the fly. I have been so frustrated. I made a lot of progress at one point by just deleting the portal and starting over. I attached two databases, test which works just the way it is supposed to. A simple widget model based on something I saw on youtube. and Client test which is my attempt. Test works fine. Client test is very similar with a couple of extra fields including a calculated full name field but nothing significantly different. Right now the problem is the relationship will not create a new record in the join table. Maybe I don't even need a join table. Not sure but the join table was one of my attempts at a solution. I have been using filemaker since 6 but only sporadically. I used to be able to create simple solutions on the fly but I just spent the whole weekend trying to get this to work. I don't have any hair left to pull out! Help! test.fmp12 NewClientTest.fmp12
  13. My database has only three tables... ITEMS - Which is an inventory of tools for the company. • BOOKED - Which records an audit of each time each item is booked in or out of the stores • TESTED - Which records an audit of each time an electrical tool is PAT tested [safe to use] The individual Items are displayed in a list layout called 'Item List' which is basically the 'Home Page'. The BOOKED events are displayed in a portal in a 'form layout' called 'Item Booking'. I've set the sort order in the portal to show the last 'booking' at the top. The easiest way to this portal is to click the small blue "go" icon in record on the "Item Bookings" layout. What I have tried to do is display the last "booking location" from the portal [at the top] in the 'Item List] so that at we can see the item's current location without having to view the portal each and every time. I managed to display the latest Booking Primary Key - [Max ( Booked::Book_Pk )] - but couldn't get it to reveal where it was last booked too. I shall spare you the list of things I have tried but before giving up completely thought to seek help here where I received helped before. Personally, I thought an auto entry by calculation would have been best but I just couldn't figure it out. Please find the file attached. Any help would greatly be appreciated. I have FileMaker 13 on my Mac at home but V15 elsewhere, if you alter the file please export in V13 to spare me having to leave the house to open it up on the other computer [V15]. Test-23.fmp12
  14. Hi i have an event table and a coordinator table. Until now each event had only one coordinator. There has now become a need that at some large events require more coordinators - could be upto 5. I have a login for the coordinators where they could see events which are assigned to them. The relationship is that the cordinatorID in the coordinator table matches the coordinatorIDF in the event table. I created a coordinator2IDF in the event table and tried to relate it aswell to the coordinator table but what happens that it even breaks the first relationship. How could i modify my table it should work like that with my already created table which was until now a one to one relationship? i would appreciate if someone could help me out on this...
  15. Hi Guys, I've been trawling google and many forums for the last couple of days after numerous failed attempts, I'm now relying on the expertise of all of you. I currently have the following calculation: If ( IsEmpty ( Invoices::Search ) ; Invoices::Product Category Filter Popover = All Products | Popover::Category ; PatternCount ( List ( All Products | Popover::Item ; All Products | Popover::Supplier ; All Products | Popover::Internal ID ; All Products | Popover::Resale Price ) ; Invoices::Search ) > 0 and Invoices::Product Category Filter Popover = All Products | Popover::Category ) set up as a portal filter and it performs perfectly to what I needed when I was only testing with a few products in Inventory. I now have 36000+ records and would really like to only show items with a value of more than 0. I found a suitable calculation (subbed in my own field) on filemaker: If (All Products | Popover::Stock < 1; 0; 1) But cannot find the right area to add to my above calculation. Can anyone help??? Thanks Nathan
  16. for some reason my portal field has stopped showing the scroll bar and will not create new records, but alters the last record, effectively wiping it out. This is hell on the billing, since these are essentially purchase orders. I have scroll checked in the portal layout box, but no joy. When I invoke the inspector, the appearance and position tabs work fine, but EVERYTHING in the data tab is grayed out and I cannot check the scoll bar function there, or any other box. Adding to the mystery, when I duplicated the layout and replaced the portal with a new one, the scoll bar reappears, but as soon as i revert to Browse mode, the layout goes back to the original, dysfunctional layout and portal and WILL NOT allow me to change to the duplicate layout with the working portal (visible scroll bar) (a new name and everything.) I have named the portal as an object on the original layout and invoke it first with my script. basical open object, go to last line, set several fields, etc. no conditional formatting, just filter for latest seven records and sort ascending. Maybe I have to call it something else on the duplicate? FMA 11, OSX 11.6. Files too big to post. Menu set to standard.
  17. Good morning guys, I am relatively new in filemaker however it is amazing how quickly you can develop an application that saves us a lot of time. However, it is a week that I got stuck in development. I am creating a database for the management of some recipes, for which I need to select all of the ingredients (in a portal) and make sure to display on another portal the list of the nutritional elements. For this I created three tables "Recipes", "ingredients", "nutritional elements", plus 2 join tables "Recipes & Ingredients" and "Ingredients & Nutritional elements". For example, the recipe "Spaghetti Bolognese" is composed of "pasta 50%" and "tomato 50%". The problem is this: in the portal I must display the nutritional element name and its concentration (10% crude protein), whose concentration is the sum of the protein made from pasta, and the protein made from tomatoes (so it is a field calculated). I ask you for advice on how to proceed.
  18. Is it possible to have the first line in a portal blank for data entry, rather than scroll for the next blank line. If one were to have two years of data, who would care about seeing two years ago data always on the first line?
  19. OK Here goes an question that I hope makes sense. The small POS that i am working on is progressing however, I have just noticed an issue with a popover portal display that i am not sure is correct or how to work around it. I will try and explain. If I create a new transaction record and dont put any data into the portal where the dummy product is In the image i.e. it is blank then when i click on the Green fruit /veg button to the right and the popover displays, i get a blank portal display. whereby i am looking to get When the popover displays. The popover is 7 portals side by side to form a grid. It works absolutely fine if a product has been entered into the left hand side eg where the dummy product is. It then displays. I tried to enter the dummy at new transaction via script and then delete it in the same script but the popover is again blank. The popover portal is based on a seperate table to the portal where purchases are entered. Any clues as to what i might be missing. This is in FM15ADV. on windows 10.
  20. I have a portal showing items, i want to have a column that displays serial number for each item, serial number has to start from 1,2,3,etc. i want the serial number to adjust accordingly when the user deletes any item, i.e. if user deletes item no. 3 i want all the items to shift up and fill the space left by number 3. How do i achieve this.? Am using filemaker pro 13.
  21. GOAL: I would like to either click on a button within main portal and in doing so the Sub Portal FK activate those records that match the Portals PK. CURRENT PROBLEM: When I am within the Main Portal if I want to time-stamp PK record 6 I would have to manually type it into the FK. In addition, it would get confusing because it is showing TimeStamps from both of the Main Portals PK. HELP REQUESTING(Thanks in advance): I would like to write a script that when I click on a button within the Main Portal it only SHOWS those records within the sub portal that are related to that PK. EXAMPLE: Within Main Portal:{See Figure 1 below} I click on the red button. In doing so, the Sub Portal only shows items with a FK of 6. I am hoping then I can go to the last row and add a new time stamp within the Sub Portal should I choose. THANKS: I know your time is valuable and I am really an grateful. **************************************************************************************************************************************************** ****************************************************************************************************************************************************
  22. I'm designing and working with my first Filemaker database using Filemaker 12 Advanced and Ipads using the Filemaker Go app (self hosted). I am having issues with random records going missing from the whole database (in each table and TO). There is no evidence that the record was ever in the database at all and this only happens every once it a while and is not restricted to a single Table; it happens in multiple tables, randomly, with no correlation between the instants. I would say 1 record in 50 goes missing daily. I have 9 main tables that are connected with a key. Each table has TO of every other table attached to share information through portals on each table. Table1 can create/delete records in Table2, but not vice versa, Table2 can create/delete records in Table3, but not vice versa... and so on and so forth. I am the only person who can delete records at all but especially from Table1, which removes the record from every table in the Database. None of the TO have the ability to create or delete. What could my issue be? I checked relationships, scripts and fields. Could it be the Filemaker Go app? Thanks folks!
  23. I have a portal that I will call LIST OF CUSTOMERS. (Photos #1 & 2) My desire is to type the first few letters of a company's name in the global field CallReport::ChooseCustomer and click on a red square button (Photo #4) to populate the portal LIST OF CUSTOMERS with an alpha-sort of my customers' names starting with Customer2::CustomerName >= CallReport::ChooseCustomer at the top and ending with Zywux on the bottom. Everything works PERFECT except the portal does not refresh such that Customer2::CustomerName >= CallReport::ChooseCustomer is listed in the first row of the portal no matter how many times I click on the red square button! (The top-left red arrows on Photo #3 signify repeated attempts to refresh the portal.) However, if I first click on any field, for example, in the field Additional Information shown on the right half of Photo #3, then I need only click on the red square button once for the portal to refresh and list the customer name satisfying Customer2::CustomerName >= CallReport::ChooseCustomer in the first row as desired. I would be grateful if someone can tell me how to changing my programming such that after typing the first 3 or 4 letters of the company's name in the global field CallReport::ChooseCustomer I could then click on the red square button causing the portal to refresh and produce the desired outcome. That said, it would be really cool if I could type "K" and K-Line, the first "K" company would be in the first row; type "L" and Kline would now occupy the first row; type "O" and Kloke would grace the first row. However, if the it too complicated for me to understand, using the little red square button is just fine. Thank you for any assistance you could provide me. Sincerely, Joe
  24. I am adding a new table to a system. The purpose of the new table is to be a personalized gateway into this rather large existing system. I am trying to define a relationship where the current projects for the user are presented in a portal on the gateway layout. So far so good, and it is working… with a catch. The problem is the user might be assigned to one of three different functions in the existing file the data is pulled from. The user's name could appear in one of three discrete fields, in any of thousands of records. I have it working based on a relationship to one of these three fields. But I can only find a way to have an "AND" relationship to the other two fields. What I need is an "OR" relationship: the user name in the gateway table related to function 1, OR function 2, OR function three in the second table. After I got things working with a single relationship I created two more occurrences of the second table in the relationship chart and related the remaining two function fields to the user name in the gateway table, but it still only pulls data from the first relationship I established. Any ideas?
  25. Hi, Am doing my first project as a beginner with Filemaker Pro 12 and am stuck at a point. Please help me out on what to do. am using these fields in a portal: Opening Stock, Closing Stock, Quantity Received, Quantity Sold and Stock Balance So for the first step: Opening Stock = Stock Balance then for the other steps or next inputs: Stock Balance is to = Quantity Received - Quantity Sold. Now, at the end inputs (say for 10 rows), the last value of the Stock Balance is automatically the Closing Stock. Please how can I do this? Is it possible in portal and if not, how can I achieve this
×
×
  • Create New...

Important Information

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