Forum Discussion

JonathanHeuer's avatar
JonathanHeuer
Qrew Cadet
6 years ago

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

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?
APIs and custom code
Formulas and functions
Quickbase Automations
  • BrianCafferelli's avatar
    BrianCafferelli
    Quickbase Staff
    6 years ago
    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