Jump to content

Search the Community

Showing results for tags 'record'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


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

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 15 results

  1. hi everyone. i'm new at this forum and i'm beginner user of fm. i'm not sure about this is the right topic for that , if it's not sorry about that.  as you see i have file including 1656 record. i have to split that records as  0 to 1243 and  1243 to 1656. i can't find way to this. could you help please?  thank you already.
  2. Hi Anyone have an idea on how to display the Record number in a field? I want the field to display the record number every time I got to the "Next or Previous" (scroll through) record. Thanks in advance for any help. pyorkie
  3. I am sure this is one of those simple ones… that has me bamboozled for nearly 2 days now. I need to limit access of my users viewing only a limited set of "Company" records after they log in. The companies that they are allowed to see are listed in each respective user's profile. My opening script goes to the user's profile and creates a global variable for each company that they are allowed to view. When I go to the "Manage Security > Edit Privilege Sets > Records > Custom Privileges > Limited > Script", and use any of those variables (e.g. $$Company01"), the records table returns no records at all (i.e. as if there were no matches). When I test the script and use text for any one (or several) of those companies by name (e.g. "ACME PTY LTD"), the access rules work perfectly. To be clear: The global variables themselves are correct. I know this this because they work in other scripts absolutely perfectly, so the variables DO match the names in the field. The script looks like this: $$Company = Table Manufacturer or $$Company01 = Table Manufacturer or $$Company02 = Table Manufacturer or $$Company03 = Table Manufacturer or $$Company04 = Table Manufacturer or $$Company05 = Table Manufacturer In every respect, the variable matches the actual text, but I can only imaging that there is a problem with my syntax? Please advise. Many thanks
  4. I have a little database that the sales people here can access via IWP (it's a FM 12 Advanced database). I have provided a function where they can look at a list of new companies, and assign themselves to those companies. This has the effect of showing that company on their Dashboard. I have also provided the rather useless function of hiding the portal row when they're looking at the list of companies. Useless, because as soon as they revisit the list, anything they've hidden comes back again. I would like to provide a feature where they can click the same 'hide' button, and that company record is permanently hidden from view per user. So Adam hides it, but if Chris or Bob log in, they can still see it...Adam will never see it again. I'm thinking I need some sort of join table with the sales persons UID linking to the companies UID, and a script behind the 'hide' button to do the work, but I'm not quite sure how to get started and implement it...or even whether I can get the 'hide' script to work with the limitations of IWP. Any help much appreciated.
  5. Hi, I want to create a Dropdown List of numeric options to select a range of records. For example, the Dropdown list would contain: 5 10 20 50 100 ------- edit... Each option would select the next 5;10;20;50 or 100 records to the right. A Checkbox would be populated (with an X) in the selected number of contiguous records; Then, a Find Selected Checkboxes would return the selected records. The contiguous selection should be independent of whatever the current state of Found (Sorted/Unsorted) is. Any help will be gratefully acknowledged. Best, Daniel
  6. I have a table called Patients that stores a variety of information, including a list of medications being taken and a checkbox field indicating all drug classes represented by the medications listed. Each record in this table represents a patient. Per another user’s advice when I first attempted to solve this problem, I have created a new table MedLibrary in which each record represents a different medication and contains two fields: DrugName and DrugClass. I wanted to be able to search all records in that table to match existing medication name/class entries, so I watched this video and created a second TO (MedLibrary2) with the following relationship: [MedLibrary2::SearchTerm = MedLibrary::DrugName] When I set the search layout to display records from MedLibrary and use a portal to MedLibrary 2 records that displays DrugName and DrugClass, everything works GREAT. However, I ultimately want to apply an OnObjectEnter script trigger to fields in the portal so when I select a particular record in the portal, it inserts DrugName and DrugClass into the list of medications being taken in a particular patient’s record (i.e. a field in the table Patients). I am not sure how to go about this. I have tried several things, but I’d rather just ask for suggestions than explain all my failed attempts so far. The only other important piece of information is that each record in Patients has a unique identifier that is currently used to link data from multiple tables within each record. I have a hunch I may ultimately need to create a relationship with this field, but I’m not sure how to do it without screwing up the search/portal functionality I’ve created. What I want to know is: What relationships need to exist in my diagram (and between which fields)? What table should I be displaying records from in the search layout? Will my OnObjectEnter script trigger idea work as planned? Thank you in advance for your help! You guys are lifesavers!
  7. I have two identical tables only one of them has data inputted into it the other table has no user access. After a user has created a new record in Table A i want all of the data to be duplicated into Table B and just stored there. This is because Table A can later have individual records deleted and we need to keep a backup of all the data entered into Table A I did write and export script which exported the record from Table A to excel and then imported the excel file into Table B but this does not work very well over our network. Any suggestions would be appreciated.
  8. I'd like to hear folks' ideas about the best way to edit some related records in a script. I have a layout based in TableA, with 3 portals each showing related records from TableB. There's a simple relation TO from A to B via an ID from A. Each portal only shows one record, so I can view 3 records at a time. There are buttons that set a few fields between records, though, or copy from one record to another. E.g. a button to assign a name in Record2 to the same name as in Record1. My current process is to use an 'Edit' relationship: TableA is related to a new TO of TableB via a key field and a global-field selector. So if I want to edit record 2, I set the global selector to 2 and then write to fields through the 'Edit' relationship. I am also using this 'Edit' relationship to READ data from a record. But would it be better to do a variety of 'go to object'...'go to portal row'... steps in the script? Does it really make a difference? Or is there yet a better way? (I don't think that I want to do a new window-find record-edit record-close window sequence.) This was originally designed in 13, but I am playing with 14 now, so any options are available. -- Justin
  9. In one layout, I have a formula that auto enters a serial # and assigns it to each new record. The layout contains a portal to another table that I would like to link to this serial #. Is there a way to make the contents of the portal saved as it's own record automatically whenever a new record is created in the main layout? They would be related by the serial number. I want the portal record to be all automatically filled out and not directly editable by the user. It's just a "record" of what was entered into the main layout.
  10. I am new to filemaker and am using Filemaker 14 with starting point. I am connected remotely to my network. I am in the account section of starting point and for some reason when I click the create new record button it is randomly adding data from another record in the database and linking a contact to it. Specifially in the Tabs at the bottom "contacts" "projects" Does anyone know how to change this and make the new record completely blank?
  11. I am working on a web page that displays portal records that allow user to update record fields. Once the data is entered I have a button that runs a script that sets variables from the contents of the active records fields then preforms a scripts based on the variables created. My problem is that IWP is not recognizing the active record. Most of the time it uses the last portal record and occassionaly it uses the active portal record. The script works fine in Filemaker without a problem. What do I do to make IWP recognize the active portal record?
  12. Hello,   Trying to add records in a portal and have them link to a specific foreign key. Normally filemaker would do this automatically, but the layout I am on is not the table I am trying to link these new records to. The reason is because I already have another portal on this layout, and I need to add records to it as well. That portal, is the one I need to link my second portal to.  So I have my first portal, which is working fine, called levels ( as in levels of a house ie Basement), then I have my second portal, rooms. I have a select button on the first portal which, when clicked, executes a script that saves the primary key to a global variable. Then when I create a new portal record on my second portal, it runs a script that sets that saved primary key as ITS foreign key.  But - it doesnt work. The records get all kinds of weird results. Mostly, it seems like the newly created records are always linked to the primary key of the FIRST record in my other portal, rather than the one I selected last via my button.  How can I make this work? Right now my work around is sending the individual to another layout, which looks exactly like this layout but is linked to the correct table. But that method isnt that great, because it confuses the user when they now cant add records to the first table without hitting a button.  Any help would be greatly appreciated!
  13. Hey guys, I have a layout called "Aircraft Hours" where I enter in details for an aircrafts flight. The field I am interested in this one is [date]. I have another layout called "Maintenance" where the maintenance for the aircraft show up. I wish to have this layout display the last time that aircraft flew. I am new to this kind of stuff. I am using from what I have read I need to use the 'lookup' function but I am guessing I need an "IF" function as well? I want the calculation to look up the last record entered on the "Aircraft Hours" layout and grab the date from the date field however I need the aircraft field to match on both layouts. The "Aircraft Hours" layout will have records for all different aircraft. I need the calculation to not only look up the last entries date but last entries date for the correct aircraft. Gosh I hope that makes some sense... Cheers!
  14. Hi, I have a portal with five fields - 3 text, 1 date, 1 number; the first row displays all five fields correctly and the following rows display only the text fields. Any ideas as to what I'm missing here?
  15. Fellow developers, a question I must ask (I'm sorry if this seem so unusual; my filemaker development is not the most common) I have a database of paragraphs. The idea being, each paragraph is a record, in a Table named Reference. The whole idea of this database, which has more tables but could work with just one, is to make a manual, a handbook for the company I work for. Let me give a example: we have a specific instruction on how to deal with taxes at importation. We create a record named: taxes at importation, and we related this record to another record in our self-related table (taxes, or importation). So: RecordID_pk FatherID_fk Title R1 1 0 Importation R2 2 1 Taxes at importation the idea is to have a list of related records, with order numbers self-created, all of which I ALREADY HAVE. So our database already does the following: - organize the record relating it to parents - performs searches easily (thanks for fmsearch for that) - easily allows to change parent record - order the records in a unified string -- 01; 01.01; 01.02; 02, etc. My problem is: we have people (trainees) that need to read the whole manual over and over again (because they want to memorize, and they seem to think this is a good way - who can argue?). We have a "create pdf with all records" button, but they insists on reading live material. And there is some point to that. If the person is reading a theme, and it changes after the PDF is created, it obviously wont go to the pdf (unless another pdf is made). I know that whatever was read before will not be revised (like, any changes in chapter one will be missed if the person is already in chapter two) but he will re-read it eventually; no big deal. As the reading may be exausting, and the trainees have, obviously, other tasks to do, we have a 1000 pages manual, which is something like 60 hours long to read, which the trainees will read 2 hours a day (more or less), 4 days a week. This means that if the trainee generates the PDF today, and we have a change in some topic, he will have to read the whole manual once (60hours/8hours per week aprox = 7,5 weeks) and them re-read the theme, which can cause some stress in this almost two months delay. So, we need to do live reading. My problem is: how to make the best reading experience in filemaker for lots of records with different sizes of text? Some paragraphs are two sentences long. Some, two pages long. Some are just titles. When I print to pdf is very simple (with the slide up feature), but when I make a layout, all I can offer, so far, is a list view with fixed sizes or a form view, with go to next record. What I want? First, any suggestion if there is some obvious way to do what I need that I'm missing Second, a way to display all (or some at least) of my records in a list-way in a webviewer. Kind like a wikipedia page has sub-topics (ok, it doesn't need all the fancy jump-to-section, although it would be awesome). Right now, I'm not trying to have the full-implementation, but just to understand which way I may/might follow. Thanks for the help in reading all this long text. Ps: If necessary, I'd be willing to do some html trick or something like (it already has some html tricks in the webviewer)
  • Create New...

Important Information

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