Jump to content

Search the Community

Showing results for tags 'id'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New Claris Platform
    • FileMaker Pro 19
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • Claris Connect
    • Core ML
    • NFC and iBeacons
    • Add-on Modules
    • iOS Shortcuts and FMGo
    • Save Schema as XML and Upgrade Tool
    • Java Script and the Web Viewer
  • 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 18 Advanced
  • FileMaker Server Administration
    • Previous Version Server Discussions
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
  • Brain Food
  • 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
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

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 4 results

  1. Get ready for a headache! I have this wonderful Finance database that I have been working on (With your guys' help) for quite some time. In this window (Table View) it shows all transactions for a given account. The issue is that the program also manages "recurring transactions" which it automatically creates records for at the beginning of the month. Each record has an "ID" that is a sequential serial added at birth. Problem is, (see picture), when the recurring transaction gets created, it's ID will be lower than another transaction that might occur on the same date, even though the recurring transaction cleared the account AFTER the newer transaction. Now to complicate things, the ID is also tied to another table which houses categories, amounts, etc. So to change the ID in this table means also manually updating the record in the other table (Relationship is built on this ID field) The table is sorted by Date first, than ID, in order for it to total correctly, the transactions must be in the correct order. Basically, what would have to happen in this instance would be I would have to update both this table and the categories table to reflect Row 1 being ID 184, Row 2 - 104, Row 3 - 183 as the RED Pending transaction needs to be last on the list. How can I make this work?
  2. I have a table that contains dimensional data for parts. Each record has a unique ID, but also has another field with the ID associated with the part. I have another table that I'll be storing individual inspection data on. I was wondering if it's at all possible to parse the first table, and copy over all records that have a specific part ID to the second table whenever someone starts a new inspection record. Please let me know if I need to provide any more information and/or pictures. Thank you in advance for any assistance you can offer!
  3. Do folks have recommendation on setting up a system for creating regular, human readable and consumable, IDs with an offline/online-sync and hosted solution? The offline part of the solution allows full creation of new Orders. These Orders will (should? could?) have an OrderID will be visible to the customer and given to them on an invoice at the time of creation in the offline world. (The invoice is generated along with the order and will be emailed to the customer, so the OrderID will be there.) But someone else in a different offline copy, or someone who creates an Order on the server, will also get OrderIDs that might then conflict with each other. How do you reconcile these different creation points? And just using UUIDs isn't a solution; it needs to be something simple that a customer can read off; 6 digit number or some such. Maybe a prefix for each device/salesperson? Maybe try to create and control blocks of IDs that go to each device? Maybe a temporary ID somehow, e.g. a 'purchase order ID' for the offline generated items that then gets translated to a full OrderID when they sync to the server? Then the customer would have an invoice (guess it would be a P.O. now) with one number and an invoice with another. Seems a bit confusing. Anyone have something they have successfully used? Thanks, Justin
  4. I am trying to create an autogenerated Id number for an invoice but this number must be prefixed by the year for example 2012/1 however at the start of each new year these number need to go back to 1 so for example the first invoice next year will be numbered 2013/1. can anyone suggest the best way for this to be done. John
  • Create New...

Important Information

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