Can a record on an embedded report link "know" the ID of the record it is embedded on?

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have 4 tables with the following relationships:
Clients < Services
Clients < Applied Promotions
Promotions < Applied Promotions
Applied Promotions < Services

On a given Service, I have a report link which displays an embedded tables of all the Applied Promotions which are the children of the Service's parent Client. I'd like to create a single button, displayed on the Applied Promotion in the embedded table, which when clicked will make the Service on which the table is displayed child to that Applied Promotion. Any ideas?
Photo of Jonathan Heuer

Jonathan Heuer

  • 400 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Brian Cafferelli

Brian Cafferelli, Quick Base Technical Marketing Manager

  • 1,628 Points 1k badge 2x thumb
Hi Jonathan, unfortunately a report link doesn't have a way of knowing the Record ID# of the record it's embedded in. However, it sounds like you're trying restrict users so they can only relate the service to an applied promotion that's related to the parent client. Have you tried using a conditional dropdown for this?

- Brian