Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About netcode

  • Rank
  1. I have a quick question about using filemaker on your website. I have done this before, however I want to change the setup of the deployment. I have an external web host that I want to use. I have done a lot of reading and what to ensure that I am correct with my thinking. To connect our external web server to our filemaker databases (web publishing engine and the actual databases) I need to install Filemaker Server on the web server so that the web server module is installed and that server is made into a worker? Is this correct, or can I simply include the filemaker API on the web server and go? Because I have included the API on the web server and when I go to change my deployment setup, I unfortunately get an error when I type in the server's IP address. I assume I am getting this because the web server module is not installed on that server. Let me know if I am correct or incorrect and maybe what I can do. Thanks all. :)
  2. Hello. I took a look at your database. I didn't dig into the code, or the structure so I cannot comment on those aspects. However I really like the presentation. It is very well laid out and the design makes its easy on the eyes and easy to use. Very well done for the first time around. I am fairly new to FMP and am self taught as well. I have been using it for about one year now and I have yet to step into the realm of design. Thumbs up -B
  3. I figure out a solution. It had to do with the record not being committed. So I simply just created a script that would delete the portal row and then commit. It works now : Funny how its always something simple like that. However I haven't fully tested out the second issue yet, as the first one was solved I moved onto something else. I will be doing that very soon and I will let you know the outcome **Outcome: I guess the context will change dynamically with the relationship? Not sure but it seems to be working fine.
  4. Hey there, I have a calculation set up to find the total of a few related records via the sum function. Here is how it works. I have a Contracts Table that is Related to a table called InKind. They are related through a unique ID number that is given to each Contract in the Contracts table. Each entry in the InKind table has a cash value. The calculation resides in the Contracts table and is as follows: Sum ( AFF_InKind::Cash Value ) However it doesn't work that way.... First Issue: The InKind table is being displayed in a portal, when I delete a portal row the TOTAL does NOT update. If I add a portal row or update the cost of one of the entries the total will calculate without issues. Second Issue: I have multiple TO's of the contracts table and the inkind table. The calculation only allows me to pick one table for "calculate in the context of". So when I am working in the other TO's it is showing me the calculated total from the wrong table. Just found this... It even says in the help file: "Summarizing data in portals You can summarize data that's in a related field displayed in a portal. The portal can contain records from a related table or from the same table, using a relationship defined from and to the current table (a self-join). To summarize data in portals: 1. Create a calculation field in the table in which you want the summary to be displayed. See Defining calculation fields for more information. 2. For the calculation field, define a formula that includes an aggregate function for the type of summary calculation you want to perform. For example, if you are in the Invoices table and want to define a calculation to total the related values in the Price field of the LineItems table, use the formula Sum(LineItems::Price) 3. Place the calculation field on a layout of the table in which it is defined. See Placing and removing fields on a layout for more information. " But that doesn't work ... frustrating
  5. A contract cannot be archived and be active at the same time. However there are multiple active contracts. (ps we are talking contracts, not contacts) Yes I see how yours is dynamic, so is mine. Creating a relationship that is dynamic is not the problem (ya I don't really know why I even asked that question in the first place, guess it was to get an official statement if it is supposed to be possible). The relationship is fine, its the data in the portal that doesn't update that is my problem. Any data that is NOT within the portal, yet still comes from the relationship WILL update, however data in the portal won't until I click somewhere else in the layout. Maybe if I just send you the file, and you actually saw the problem you might have a better understanding. If you want to do this I would rather send you the file privately, just in case, these forums are open to the public. Let me know and I can set you up with the file in the next few days. I am at home now and not at the office.
  6. I did investigate it, implemented it, and the portal continued to do the same thing. I even changed the field to a Number. used a button to change the number in the field. And the portal still showed the same issue. Are dynamic relationships even possible without the use of plugins? Maybe dynamic relationships are not the solution in the first place and maybe I should be thinking of another solution? And all those ID fields get their value from a script triggered by a button called create new, then the user chooses the type of contract and the record is created in the contracts table and then that # is put into the appropriate field depending on which type of contract they have created.
  7. I now see what you mean. However even if I separate the two, and create two different TOG's it still does the same thing. The portal will not update the data when the relationship is changed until I click outside of the portal. I think I have another solution. That solution is to script a button that will change the ID # and then do a go to object script step so that the portal data will update. Simply just automating the action of someone clicking outside the portal. **EDIT** Just implemented that go to object script step on the button... guess what, doesn't work! Ahhhhh! Nothing will work unless you manually click on another object, once you click on another object the data will change in the portal. So strange... so so so strange. Anyways here are some pictures that will explain better my situation I think. Here is the relationship graph. I have removed everything else so we can focus on this relationship. As you see "Contracts" and "Sponsors 2" are connected through the "ActiveContractID" in the sponsors table and "ContractID" in the contracts table. Now the layout... Ok this isn't a screenshot of the actual layout but it shows my layout. As you can see the portal is showing records from the "Benefits" table. Now the buttons there labeled "Contract 1" and "Contract 2" will change the field "ActiveContractID" and change the relationship between sponsors 2 and contracts, hence changing the related benefits. However the data in the portal will not change until you manually click on the layout somewhere. Thats where the problem is... once the data changes the data is correct. So everything is fine structurally.
  8. I do not know what you mean by anchor buoyed/squitted, sorry. I have attached the file with color coded tables that share the same table. I also wrote a note below explaining the tables that are outlined by the purple line. Anyways hope this helps. Glad to be making progress on this : http://www.atlanticfilm.com/filemaker/RD-Color.jpg *Note the group of tables that are outlined by pink. That is basically the same set of tables. However note the multi criteria relationship with the field "archive". Basically this set of tables is used as an archive. When someone clicks (on the layout) a button called archive it sets the field "archive" in the contracts table to 1 and therefore creates a relationship with the sponsor, these contracts that are archived are shown in a tab called "history" and the active ones are not. Anyways that isn't the focus of this, just thought I would give you some background about that part of the database.
  9. Thanks for the response! I use a calc field to determine the relationship between "Sponsors" and "Contracts". Why I did this was because there are multiple contracts for each sponsor (one sponsor PER contract however) and I wanted the users to have control over what one they are viewing by using a radio button which controls the field "ActiveContractName" and you will see that in the Case function which changes the field "ActiveContractID" to the appropriate contract ID. The ID's are found in, for example, the field "AFF_ContractID". Here I will add a screen shot of the relationship diagram. The forums might resize it so here is the link: http://www.atlanticfilm.com/filemaker/RelationshipDaigram.jpg Hope this helps. I would love to get to the bottom of this because how I see it, it SHOULD work. Again it only seems to do it if the portal is in focus. Anyways take a look let me know what you find out :
  10. Concerning the 2nd bug that I was talking about (which really isn't the biggest concern for me) here are some screen shots. The first screen shot You see here that the first item in the portal has the category of web banner. This was selected from the popup menu. The second screen shot Now you see here when scrolling down through the portal the data from the category popup menu floats through the portal. I have circled it in red.
  11. The popup already does use a value list that pulls its data from a field. Its just the relationship changes based on a calculation. The actual data is not the result of a calculation. And the relationship between the items in the portal and the contract is not human readable, its an ID # I would like to continue working this out with you, your help is appreciated. Anyone else ever experienced this problem with popups in portals? The only data not being updated when the "ActiveContractID" changes (changing the relationship) is the data in the portal. And soon as I click outside of the portal it updates, it just acts so much like a bug
  12. I have noticed 2 things with a portal that seem to be acting as if there is a bug, however I could be doing something wrong. So I am looking for input. The following is my situation. I have two tables that are related through a field called "ActiveContractID". In the first table (the table being browsed) the field is a calculation as follows: Case ( ActiveContractName = "AFF" ; AFF_ContractID; ActiveContractName = "VF" ; VF_ContractID; ActiveContractName = "SP" ; SP_ContractID; ActiveContractName = "FIAV" ; FIAV_ContractID; ActiveContractName = "alFresco" ; AlFresco_ContractID; ActiveContractName = "Inspired Doc" ; ID_ContractID; ActiveContractName = "Inspired Music" ; IM_ContractID; ActiveContractName = "Inspired Script" ; IS_ContractID; ActiveContractName = "Short Film Face Off" ; SFFO_ContractID; ) Each of those ContractID fields holds the appropriate ID of the contract. Then I have a radio button field on my layout that displays data from "ActiveContractName". Essentially when you click on the radio button it will change the contract (change the info in the portal). HOWEVER, if I change the active contract, edit some information in the portal and then change back to a different contract the information from the previous contract stays in the portal.... UNTIL you click the radio button again, then it changes. EDIT** Noticed that this only happens if the portal is still selected. If you click on another object before clicking the radio button the portal will change like it should. Thats the first bug I noticed. The second is as follows: When using a pop-up menu in a portal if you choose an item in the pop-up menu in a new record in the portal that item seems to float above everything when you scroll up and down. So if you choose something in the pop-up menu and scroll back up the text of that item will float over all objects. Let me know if you have experienced any of these or if you have any input. Thanks :
  13. thanks bcooney. in regards to creating a summary field in the ticket table.. that will do the trick.. IF your layout is based off the ticket table. If your browsing the sponsor table that summary field will only calculate the related records. I found my solution, just create a report (columnar) that uses the ticket table. Then the summary field works and I have my totals : I don't think what I initially wanted is possible, to be browsing the sponsor table yet still see a summary of records in the ticket table. Anyways thanks for the input!! :)
  14. Hey there, I am trying to get a total of ALL the records in the portal, related or not. Maybe using "portal" is not the correct wording because the data is in a table, and portals only show related records. But here is how it is set up.. I have a sponsor table and a ticket table. A sponsor can request tickets, when an employee finds out a sponsor wants tickets they enter in the # of tickets that the sponsor as requested. I want the total of ALL tickets that have been requested across all sponsors. I tried using summary fields and summary parts but summary parts seem to only calculate data on a group of records currently being browsed. And as the user is browsing through records based on the sponsor table the summary fields are only calculating the related records. Any suggestions would be wonderful :
  15. It looks like that really may be the best solution, despite if I want that to be the solution or not :)
  • Create New...

Important Information

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