Search the Community
Showing results for tags 'fields'.
Found 22 results
-
So I created a solution in Filemaker Pro and its appearance looks great.... until I open it in WebDirect on a web browser. Fields are cut off at the bottom, styles like Condense condense wrong, and rectangle boxes don't show at their full size. Also, the padding spacing on radio buttons is completel...
-
Hello Is there a simple way to import various files (more than 2000) where tabs separate 9 different fields so that each import would populate the fields as they are? The files are in UTF8 and PLAIN TEXT Importing them with the FileMaker function : FILE->IMPORT->TEXT FOLDER simply bri...
-
I am currently working on a database that will score our company's suppliers. I have one table that contains all contact information for the suppliers (Suppliers), and another related table that contains the actual score entries (Scorecards). Suppliers are scored on pieces shipped on time an... -
I am designing a database for the inspection sheets used in our quality lab. Each of our parts has a different number of criteria that they need to be inspected for. This ranges anywhere from 5-15 dimensional requirements. I am wondering if there is anyway in FileMaker to display a varying number of...
-
I have a database that keeps track of computer system information. I have a record for each system (one per room). Within this system there are a number of different computer devices and I want to track settings such as IP addresses subnet masks and other network type information. I have a tabl...
-
I am not sure if I should be in this forum or the printing forum. Here is what I have. I have an inventory database. Everything is done but I need to be able to print a receipt for any inventory not turned in. It is a student database so the primary key is the Student ID. I have nine fields that are... -
I have a db with two tables: 1) Company_info 2) Contact_info. I would like the ability to create new contacts while in the Company_info table. I set up a popover button in the Company_info table to do that, but it only creates a new record in the Contact_info table without any related data. When...
-
I have a multi user db and I'm finding that people are locking records b/c they are leaving the cursor in a field after doing a specific task. Is there a way to script all fields to have NO focus after a task is complete? I have tried to change focus to other objects on the screen, like a...
-
Is there a limit to how many fields a table should have? My solution requires the management of 6 categories. Each category has up to 34 sub-categories, although most have 9-12, and each sub-category has several items requiring data entry. This leads to 91 sub-categories and hundreds of fields...
-
I have been working with FM 13 and it has been a thorn in my side now for sometime that the old layout creation ability to have all fields added to a layout upon creation is gone now, or so at least I have discerned. My question is there a way to add all fields for a table in one action now to a la...
-
Hi - I have several fields that I want to show zero if the value is zero (rather than be blank). Some are calculated fields and some are user editable. On the data tab of the inspector, I have left UNCHECKED the option Do not display number if zero. Yet, they remain blank if zero. The fields are f... -
This is probably an easy design concept, but my dense brain isn't seeing it. I'm working on a timecard system, and I'm running into a problem where I have co-dependent fields. In my hours table, I have a field which calculates the amount of VTO (Variable Time Off - like vacation time) that is u...
-
I have layout called (studentinfo). Studentinfo layout show records from "STUDENTS" table from database. when I run the code below I get all fields data expect: inq_FAM Family 1 [c]::BB_studentID inq_FAM Family 1 [c]::BB_ParentA_ID inq_FAM Family 1 [c]::Pa_first inq_FAM Family 1 [c]::Pa_last...
-
A simple question: When a create a portal and I activate the option of alternate colors, how do I get the fields on my portal to follow automatically the same background color than the row where they appear. I tried pasting formats from some templates I found, but it doesn't work.
-
Hello Filemaker developers, I need some help. I have a portal that could have one or many lines. I need to build a calculation field on the main table that can have all the lines of the portal row. The result will be used on and email that will be sent to the client. The result should be li...
-
to the FMP Guru's out there, My solution contains a layout based on Table A that has two portals, one portal shows records from a related Table B that is only one relationship away. it works perfectly fine. The other portal is based on Table C which is related to Table B and ultimately Table A....
-
Is there an easy way to check whether a field is used in any scripts and/or present on any layouts? I have a database that's been around for quite a while and I suspect that some of the fields are no longer used/needed. I've determined that we don't directly need the data in these fields (either i...
-
I am using FM 12 advanced  I have a Membership application. It has a global table that holds things like: Organization Name, Address, City, State, Zip, Phone etc...  The problem centers around the fact that there are multiple versions of the program. If I 'release' version 22 it is rel...
-
In FM 12 Pro Adv... I have an already existing layout with fields populating it from a table. I went to Manage Database and created 12 more all new fields in the same table. Now I want to add those 12 new fields to the same already existing layout. It seems that all I can do is to individually dr...
-
OK, I've done it - again! I have to take full blame for this mess (you always do as a developer). Without going into a lot of sordid detail, my Child table is in need of adjustment. Seems on a large percentage of records, the ChildLastName and ChildFirstName are reversed. I now need to swap t...
-
Hi guys.I have a room allocation database. I have made a global number field, and when a room is allocated, it reduces the available number of rooms by one. Very simple and It works fine, but the number does not match for other shared users. I want the number to match for everyone. I thought global...
-
Hi All, I have a table called "Vessel Logbook" which is used to record daily fuel consumption for our companies vessels. I have 6 Fields "Vessel Name", "Date", "Consumption", "Loaded", "Transferred" and "R.O.B" (Remaining on Board). What i am looking for is a calculation for the "R...
