Jump to content

Primary Key Field Not Showing Up During Configuration


This topic is 2513 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm setting up a new MS configuration (v. 2.109) with about 12 tables. All tables have the primary key and creation/modification dates on special MS layouts as required. When I get to the screen that allows me to define the primary key field for the tables, the key field for one particular table is not appearing in the drop down list. I've tried removing it and re-adding it to the layout with no effect.

 

I noticed that there are far fewer fields in that drop down list than exist in the table. What are the criteria for a field to be available in the list?

 

Thanks,
Jason

Link to comment
Share on other sites

If you're using developer-managed keys, then we show all text and number fields.

 

if it's MirrorSync managed, then it's all text and number fields that are also set as auto-entered values.

Link to comment
Share on other sites

Sorry, I checked closer there's an extra condition: we don't allow you to select a field if we detect that it matches the FileMaker UUID pattern (because you should select developer-managed if you're using UUIDs)

Link to comment
Share on other sites

  • 2 months later...

I am using a developer-managed schema & have an auto-enter text field that is not showing up during configuration.  The auto-enter is not at all close to what a UUID would look like.

 

To give you a little more info... The field that does not show up during mapping is in my sales order line items table and is named ID_Inventory.  There is another field named ID_Inv_DataEntry that is visible to the user to input the product identifying info (UPC, ISBN, ID_Inventory, etc.) during data entry.  Based on what is input, the auto-enter calculation on the ID_Inventory field inputs the ID_Inventory from the Inventory Items table.  I don't understand why this text field is not showing up...

 

Thanks for your help!

Link to comment
Share on other sites

This topic is 2513 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Similar Content

    • By 360Works
      How to Build FileMaker Web Apps for High Traffic using MySQL Backend and 360Works MirrorSync
      Why Sync FileMaker and MySQL?
      FileMaker is the best tool for rapid application development, but it is not the most reliable or scalable option for high traffic web sites. MySQL provides that reliability and scalability, but can't compare to FileMaker for development productivity and user friendliness.
      360Works MirrorSync bridges this gap, letting you use each tool for its best purpose. Quickly create layouts, scripts, and schema in FileMaker Pro, test and refine them, then use MirrorSync to publish all your record data to MySQL and keep both databases in sync moving forward. You can use industry-standard tools and frameworks (or hire from a vast talent pool) to create highly reliable and scalable web apps.
      In the event that FileMaker Server is down or rebooted for any reason (such as software upgrades), your MySQL web app will continue running and serving users. MirrorSync will detect when FileMaker Server comes back online and bring both databases back in sync.
      Video Demonstration
      This video, narrated by Junior Perez of 360Works, takes you on a step-by-step walk-through of how to sync between FileMaker Server and MySQL. Junior demonstrates how to start with a completely empty MySQL Server, create the database and tables, and set up an auto-scheduled sync to run every 60 seconds. The process is the same for any other JDBC-compatible database such as SQL Server, Oracle, or PostgreSQL. The license price for syncing one FileMaker Server with any one of these databases is $1,800, with discounts available for educational and non-profit organizations.
      If you would like to involve 360Works in configuring your sync, or in creating a web application backed by MySQL, please contact us for consulting and development assistance.
       
       
      Read More on MirrorSync or Download Now!
      360Works MirrorSync     Stay updated with 360Works
         
    • By 360Works
      360Works 25 Year Anniversary and New Portfolio Offer
      We are celebrating 25 years in business! Thank you for your support. If you are using a FileMaker plug-in or two from 360Works, we encourage you to try the 360Works Portfolio Bundle to receive all products.
      Now through next week enjoy a 25% off sale on our Portfolio Bundle!
      You already receive 75% off the entire suite of plug-ins with the Portfolio Bundle deal being offered at $1,995, and with our 25th Anniversary Offer you get an additional 25% off, making your final cost only $1,496.25!
      Use code: 360is25 at checkout. (Online orders only, discounts cannot be combined, new portfolio)
      This offer is for new Portfolio Bundle purchases only and will be on now, through next week, ending Friday, April 9, 2021.
      Already own a product or two from 360Works? You can apply your licenses to receive credit for select products upon checkout of the Portfolio Bundle.
       
      New Website Design
      Have you noticed the new look of our website? Be sure to stop by and take a look: https://www.360works.com/products/
       
      New Product Updates
      We recently released a new major version of the 360Works Email Plugin, to include OAuth support for Gmail and Office 365. Additionally, we released a new major version of our FileMaker Server offsite backup, 360Works SafetyNet, with improvements for increased safety, reliability, speed, ease of management and lower cost.
       
      Case Study: MirrorSync in Africa for Promasidor 
      Learn how FileMaker synchronization happens across the continent of Africa using 360Works MirrorSync in a solution for Promasidor Food and Beverage with experience shared from Technology Professional, Serge De Pauw at Promasidor. Read the story.
       
       
       
       
       
       
    • By Crawfcol
      We are relatively new to MirrorSync (6.12).  We can have a system which is syncing with no issues.  We create a new record on the FMS in a table that is synced to the Spoke (iPad).  After the iPad syncs and receives the new record, the next time the iPad tries to sync, they receive an error that there is a Duplicate ID...  
      On researching the issue, whenever we create a single record on the Hub, 2 records with the same ID are created on the Spoke with the same ID.
      This effectively breaks the sync and needs remediation by the user of the iPad by the deletion of one of the records.
    • By 360Works
      Free FileMaker Training Webinar This Week!
      Join Jesse Barnum, President of 360Works, and Richard Carlton at FileMaker Training TV for live FileMaker training this week (7/20 - 7/24) starting at
      1 p.m. Pacific Time/4 p.m. Eastern Time!
      Curious about FileMaker sync for worldwide replication across different cities & offline sync? You won't want to miss this week's live training at FileMaker Training TV covering FileMaker for Enterprise and featuring 360Works MirrorSync!

      MirrorSync is an elegant synchronization product that makes it simple for people working at home or in the field with poor network connection to work on offline copies of your hosted database, whether on iPads, iPhones, or laptops! It can sync between any combination of FileMaker Pro, FileMaker Go, FileMaker Server, SQL database (MySQL, Oracle, SQL Server, or any database that supports JDBC), Salesforce, WordPress, Amazon DynamoDB, and Amazon RedShift.

      During the live training this week, we will cover offline access for your FileMaker customer solution and help you set up multiple servers to support your worldwide FileMaker Team with Server Replication. Here is an overview of the schedule:
       
      Day 1 - We’re covering the basics, including having the Amazon servers already setup. Day 2 - We’re doing the installation of MirrorSync and discussing the mechanics of Synchronization. Day 3 - Final deployment, and Open Q&A. Day 4 - We’re inviting everyone around the world to log in to the closest server. Feel free to edit and add data. Day 5 - Open Q&A: Lean Design & the Enterprise  
      PLUS, we are offering a special discount for those on the webinar. Be sure to tune in so you can grab your discount code!
      Sessions are approximately 1 hour long. View the full schedule and register for FREE at the link below (sessions will be streamed via Twitch).
          Watch the FMTraining TV Live Stream!    
      Stay updated with 360Works
         
       
    • By 360Works
      Case Study: FileMaker Clinical Data Capture Software Uses 360Works MirrorSync
      Learn how MirrorSync is being used in the ConnEDCt app built with FileMaker for medical research and healthcare improvements across the world
      “We have used MirrorSync from versions 3 to 6 for FileMaker Pro/Go to FileMaker Server. In our experience it is the most reliable technology for syncing FileMaker databases over inconsistent and slow connections.”
      
- Caleb Ruth, Data Performance LLC
      At 360Works, we believe in making FileMaker plug-ins and tools with outside-of-the-box thinking to help FileMaker Developers build what works best by extending the functionality of their FileMaker solution to solve real-world problems.

      FileMaker Developer and Business Owner, Caleb Ruth, was generous enough to spend time sharing with us some of the aspects of his work with health information systems which leverage 360Works MirrorSync.
      Read the Full Story   Stay updated with 360Works
          
×
×
  • Create New...

Important Information

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