etsmarines

it works but i can't report on it or use that field in a calculation as it only exists in the portal. -Erik

I have a portal that is displaying a list of items. Each item has a dollar amount and an additional tag on it. Is there a way to create a total of the dollar figure of only a certain selection of the portal records. In my example i have a table called services. It is linked to a table called assets and that table is linked to a table called inventory. My portal shows all the inventory related to the service based on the assets that are related to the service. See the relationship diagram in attachements. With this relationship i can view a portal into the inventory table that looks like the one in the attachement I want to add the total cost amounts seen in the portal but leave out the costs if the related service is equal to the current service i am on. So in the example that you see in the portal I would want to exclude all the items that say LAN because the current service that I am on to view this portal is in fact LAN and i want to add up everything in that portal that has a related service not equal to LAN. Thanks for the help! -Erik

I opened the server that file is hosted on. I gave ODBC 32 bit the same name in System DSN as the ODBC 64 bit system DSN.... now it is working perfectly!! Thanks!!

I have two tables. Expense Items And products The tables are linked by Product Name. So in the expense table i have a product name and a cost for it. In the product table i have the product table and a portal that shows me every expense that was assigned to that cost. How can i make a report layout that shows the product name from the product table and every expense underneath that product name that was assigned to it along with the grand total of the costs. Right now i only show 1 expense item for the product and then it breaks and goes to the next product name in the report. Example I have a product called IBM and in my expense table i have 5 expenses assigned to IBM but in my report it only shows the first expense item and doesn't include the other 4. Thanks for the help as always! -Erik

I have a script that i run that pulls records into a FM solution via ODBC connection. I can run this script fine and the ODBC import works fine when i run it locally and manually run the script. But when i set the script to run via the scheduler from the server that it is hosted on i get an 802 error Schedule "import lansweeper" scripting error (802) at "Inventory Dev 22APR2015 MASS UPDATE TEST : 0 Import Lansweeper Data : Import Records". I can see the ODBC connection on the script. What is going on here? Thanks! ERik

How can i make a script run automatically every 24 hours. I have a database built using FM PRO Advanced 13 and hosted on FM Server 13. -Erik

i don't get a match when using this function. it returns a blank value and i know that i have values in my value list that are contained in the fields I am trying to match against... heres another example of what i am trying to do.... Field1= Microsoft .net framework Field 2 is blank Value List .net framework windows microsoft Take the value list and go through each value and see if i can find a match within the Field = Microsoft .net framework since i sort my value list by length the first value i can match i will assign to field 2. so in this case i will find that the value .net framework is contained within Field1. And i will assign the value .net framework to field2.

I would sort the value list by length the fields that i am trying to match against by length so that if a match is found it takes the first one. For example. Value list Microsoft Corporation Microsoft Field to Match Microsoft Corporation It would come across Microsoft Corporation would be used first and stop looking for a match and not get to Microsoft.

If i have a value list (approximately 2000 values) What is an efficient way to go record by record selecting a text field and see if i can make a match form the value list. Example.... Go to Record 1 select field contents (ex. DOG) go through my value list and see if I can find a value that has the word DOG in it. If i do find a match with the word DOG copy that value (even if there is more to the value than just DOG) and set another text field in record 1 with that value from the list. Example Go to Record 1.... Select field and set variable. Variable is equal to DOG Search through my value list and find a match All Dogs. Go back to Record one and set the other empty field to All Dogs because the value All Dogs has the word DOG in it. Thanks for the help! Erik

If i have a checkbox field. How can i make a script that goes through the checkbox selections and creates a new record for each selection i choose. Example Checkbox field... A B C If I check A and C I want to have a script that goes to a new table and creates a new record for each selection New Table Record A Record C Thanks again for the help!

I have 2 tables. 1 table is a list of products 2nd table is a list of expense reports The goal is to assign a product to each expense report. For example if i have an expense report that was to buy medicine i want to assign the product "Healthcare" to that expense report and have it saved as a unique record in a new table. However sometimes I have an expense report that is for two or more different products. So again for example i may have an expense report that was for buying medicine and also two pairs of shoes. In this case the products that should be assigned to this expense report would be "healthcare" and "clothing". However i want this expense report to show up now in another table as two line items.. Same expense report on each line but with different products assigned. So instead of: Expense Report 1 with Product 1 and 2 assigned to it i would have Expense report 1.... product 1.... Next line item Expense Report 1 product 2.... In other words if i assign 2 or more products to an expense report i want that expense report to show up in a new table as a new line item each time i assign a product to it... How can i take line items from one table... match them to one or more line items to another table and have a new table start auto creating line items based on the number of matches i make? -Erik

In real life think of a CMDB (Configuration Management Database) If i have an application listed in the CMDB and i relate it to another application. For example Windows 2000 is related to Microsoft Word (another application in the CMDB) I should be able to search for Microsoft Word and see that it is related to Windows 2000 even though i only made that relationship from WIN2000 to MS WORD and not the other way around (MS WORD to WIN2000) Right now if i relate one record to another I can only see that relationship if i am on the one record. If i go to the record that i related to i cannot see that it is related to anything. This should happen automatically (although i do not know how).

I have a table called services. I want to be able to create a portal inside that services layout that allows me to relate one service to another. I want the service that i related to also show that relationship in the portal on its record. So in other words lets say i have three services. A B C If i relate Service B to Service A in the portal I want to be able to click on Service B on the services layout and see that it is related to service A. Currently if I relate B to A on the A record, when i go to record B it does not show that it is related to A. Thanks for the help guys! -Erik

Ignore my last post. I found it online. Here was the problem. One of my portals had a field in it that was not part of the table the portal was referencing. I removed that unnecessary field and search started working again in filemaker web direct again. Gltich or working as designed.... very interesting that a field in a portal would cause the perform functionality in web direct to fail. Thanks for the pointer. -Erik

thanks for the response. Where do i get this guide?

I am serving a filemaker solution through filmmaker web direct using Filemaker Server 13. Suddenly I am no longer able to perform a find using web direct. I can perform find when viewing the database outside of web direct. In web direct however, when i click find it goes into find mode with the magnifying glasses in all the fields. When i click on a field, the text cursor blinks once and then I can't type anything in that field. The only way i can type is if I click and hold the mouse button down inside that field. Even when i get text into the field (in a very strange way of holding down the mouse button while typing) when i click perform find nothing happens and i cannot click out of find (cancel find). This happened suddenly and I do have another filemaker solution in which perform find is working in filemaker web direct. Thanks for the help. This is very confusing to me. -Erik

I have a file in filemaker with a specific view. The problem i am having is that when i am on that view/layout and click on a button that saves the entire view as a pdf it cuts off most of the layout. Only part of it will fit on an 8.5 X 11. I have to make the print layout be A3 sized and landscape to fit it all in. I can set my print options on my local system and it works fine every time but if someone accessing the file remotely (since it is on filemaker server) tries to print it, it cuts off the layout and they have to change their print settings locally. this is problem because there are potentially 100's of users that will print from this layout and they will not all know to change their local print setup settings to accommodate the space that the view needs to print on one page. is there a way to 1) Set the default for the file to print on A3 landscape regardless of who is accessing it remotely? 2) Setup so that what it saves as a PDF is scales to 1 page for all who are trying to save it as a PDF? Thanks again for the help as always! -Erik

When i am doing a lookup how can use the closest match not the next higher or lower. For example I have two fields: 1) Version 2) Service Pack I run a lookup that takes the version number from one table and gets the match from the next table and copies the Service Pack. In the case that there is no match i am forced to use either the next higher value or next lower value. I want to choose the closest value be it higher or lower. How can i do that? Thanks again! -Erik

Thanks guys but I'm getting my numbers in a weird format. I didi exactly what you listed above in the first Position formula. It is making the first decimal a comma.

I have a field called version. Some of the values contain multiple decimals for example 10.12.73.10 I want to trim them down to only contain 1 decimal so in other words 10.12.73.10 would become 10.12 another example would be 7456.342.4728.123 would become 7456.342 how do i do that? Thanks again! -Erik

Thanks!!

How can i make a field be required to be filled if another field in the same table has data in it. In other words. I have a date field that if i have a date listed in there i want to have a compliance field be required to be filled. If the date field is not filled it can be empty. Thanks again filemakers! -Erik

I have a table called Services I have another table called Versions. This table services has a portal into the Version table and shows all software versions associated to a given service. So for example if I am on Service A the portal window shows all Versions of software that are part of that service. I have conditional formatting setup so that a version row is out of date in more than a year it is filled in green If it is out of date in less that 6 months it is filled in Amber. If it is already out of date it is filled in Red. It looks at the support date field and compares it to the system date and colors it accordingly. Some services show lots of record in the portal with greens and reds and ambers...some with all red.... some with all green... some with all green and maybe on one red. I want to create a quick score card at the top of the Service Page that says if any fields in the portal are red it will show a red square at the top of the layout no in the portal. If any are green it will also show a green square on the layout at the top and the same with the amber. So i want to be able to scroll through the services layout and see a possibility of Green, Amber or Red or a combination of the three depending on what the conditional formatting looks like in the portal. The question is.... how to do it.... thanks again!

Thanks for the help guys! It seems to be working better. Im sorry to be such a nuisance but i am very new to the world of scripts and variables. I notice that software with the same keywords is getting different product names. For example Microsoft SQL Server Native Client is getting the mapped product name of Integration Manager for Microsoft Dynamics GP. It should really be getting SQL Server. I think it is mapping to Microsoft in the product name but SQL Server is a product name in the list of products and really is a better match. What should I do? Is there a way to list more than one result? ​Thanks again for all your help!

i didn't ignore it. I tried it out. It only would perform the script on one record. Then to get the next record done i had to run the script again. Also it only looks at the left word in the entire software name not all of them. Therefore sometimes the software name actually has the product name embedded in it which would give a match but because only the left word is looked at it returns a possible match on the left word of the string and ignores all the rest.