Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Creating new record Portal still shows data

bishop7262
in Portals

Featured Replies

  • Newbies

When I click create New Record all fields should be blank.  But my Portal, which has fields inside, pulls data from a different record.  I am not sure why it is doing this but since it is a New Record all the fields in the Portal should be empty.  Please any advice is appreciated.

Screen Shot 2016-12-06 at 10.47.18 PM.png

There could be a couple of reasons why this is so.

How is the relationship for the portal set up - which field in the Parent is related to which field in the Child (portal) table?

 

Why not post a copy of your file. That way we can see the Schema and we can either modify your file or suggest the changes using the actual fields, layouts, scripts, etc.

Lee

  • Author
  • Newbies

The user: admin and password is bigsky72  

There is an Add Client button that is just New Record to create a new record

Thank you so much!

XFile.fmp12

You have advance, did you watch the Add Client script run? I get an error that the Layout Object “infoTab” is missing?

The script doesn’t need to have the Enter Browse (You already are in Browse Mode).

You don’t want to halt script in this case.

This is an XPOST with FileMaker Community where the problem was correctly guessed at by keywords, even without a copy of the file.

Big problem with the client ID: 34 duplicate records.

Next value for client ID: 1014

Max existing client ID: 1168

pkClientID index.png

pkClientID next value.png

Edited by BruceR

Some graph cleanup.

 

XFileGraphMod.pdf

 

Screen Shot 2016-12-07 at 10.48.13 AM.png

Edited by BruceR

    • Like 1
    • Author
    • Newbies
    50 minutes ago, BruceR said:

    Some graph cleanup.

     

    XFileGraphMod.pdf

     

    Screen Shot 2016-12-07 at 10.48.13 AM.png

    Hi, thank you guys for all the help.  I am really new at all this.  I am not sure what I need to change to make it work...

    Oh dear.

    If the solution wasn't obvious the moment the record ID problem was revealed, then you have much much bigger problems.

    How did you come to be in possession of this solution in the first place? It is a rather complicated mess.

    The smallest and most immediate problem is fixing the next value for pkClientID.

    But you now have a lot of records that have duplicate values for the client ID; and THOSE records will have to be fixed.

    And they in turn, connect to other records, such as trainer records, and THOSE connections will have to be fixed.

    I think you should think strongly about getting a developer to fix this all for you and implement UUIDs, etc.

    Create an account or sign in to comment

    https://fmforums.com/topic/100802-creating-new-record-portal-still-shows-data/
    Go to topic listing

    Important Information

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

    I accept

    Configure browser push notifications
    Chrome (Android)
    1. Tap the lock icon next to the address bar.
    2. Tap Permissions → Notifications.
    3. Adjust your preference.
    Chrome (Desktop)
    1. Click the padlock icon in the address bar.
    2. Select Site settings.
    3. Find Notifications and adjust your preference.