Skip 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.

Struggling with relationship and records...

Featured Replies

Below was my first post... The work around I found is if I have a Dialog Box and ask for the Test field, I can enter the Quote Number, then set that as the variable and everything works fine. However, I can't figure out how to set the variable automatically. It always pulls the first or last one.

I have a table called Quotes. Each quote may have 0 or more Flyers. They are related by the Quote ID and I have a portal in Quotes. My goal is to add a Flyer, which makes a nice PDF of the FLyer with the info I put in. THe problem is, all the Flyers have the same Quote ID so they don't Save As PDF correctly. Here is my script:

Commit Records/Requests

Set Variable [ $number; Value:Quotes Flyers::Quote Number ] <--Each quote has a quote number

Go to Layout [ "Quotes Flyers" (Quotes Flyers) ]

Perform Find [ Specified Find Requests: Find Records ; Criteria: Quotes Flyers::Quote Number : "=$number" ]

Set Variable [ $filename ; Value:Quotes::Name & "Quote -" & Quotes Flyers::City & " -" & $number & ".pdf" ]

Set Variable [ $folder ; Value:Quotes::Quote ID ]

Go to Layout [ "Quote" (Quotes Flyers) ]

Save Records as PDF [ File Name: "filewin://XXXXXXXXXXXXXXXXXX/$folder/$filename" ; Current Record ] <--X's just mean my file path

Go to Layout [ Original Layout ]

My problem is, it saves the first quote each time, not the correct one. Any advice on how to make that work?

Thanks!

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.