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.

Match/relate next "task" record of a join table.

pezagency
in Relationships

Featured Replies

  • Author

Hello,

New to FM Forums, glad to be here. :P-)

I'm having a little trouble determining the best way to display the "next task" on a contact view layout.

I have three tables:

Contacts, Tasks, Join Table

The Join Table is for the many-to-many relationships created with multiple tasks and multiple contacts.

On my contact layout, I have a "next step" calculation which is currently related through the Tasks table. (Tasks::next)

My problem is finding a way so only the most important task shows up on the contact layout. The most important task ("next step") is the one that is still active and due before the others.

Can anyone please help me with the relation query please? I've thought about just creating a key in the Contacts table that contains the "next step" task, but I just need the matching record.

Thanks in advance,

johnny smile.gif

Hello,

New to FM Forums, glad to be here. :-)

I'm having a little trouble determining the best way to display the "next task" on a contact view layout.

I have three tables:

Contacts, Tasks, Join Table

The Join Table is for the many-to-many relationships created with multiple tasks and multiple contacts.

On my contact layout, I have a "next step" calculation which is currently related through the Tasks table. (Tasks::next)

My problem is finding a way so only the most important task shows up on the contact layout. The most important task ("next step") is the one that is still active and due before the others.

Can anyone please help me with the relation query please? I've thought about just creating a key in the Contacts table that contains the "next step" task, but I just need the matching record.

Thanks in advance,

johnny smile.gif

  • Author

Hello,

New to FM Forums, glad to be here. :-)

I'm having a little trouble determining the best way to display the "next task" on a contact view layout.

I have three tables:

Contacts, Tasks, Join Table

The Join Table is for the many-to-many relationships created with multiple tasks and multiple contacts.

On my contact layout, I have a "next step" calculation which is currently related through the Tasks table. (Tasks::next)

My problem is finding a way so only the most important task shows up on the contact layout. The most important task ("next step") is the one that is still active and due before the others.

Can anyone please help me with the relation query please? I've thought about just creating a key in the Contacts table that contains the "next step" task, but I just need the matching record.

Thanks in advance,

johnny smile.gif

  • Author

Hi,

Okay I solved it, I just needed to sort the records in the relationship.

  • Author

Hi,

Okay I solved it, I just needed to sort the records in the relationship.

  • Author

Hi,

Okay I solved it, I just needed to sort the records in the relationship.

Create an account or sign in to comment

https://fmforums.com/topic/32113-matchrelate-next-task-record-of-a-join-table/
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.