0

expanding popupRecord

from a button script --- opening another table record from another table form is great where I know the id of the other form I want to open.

ie popupRecord(record(Quotes,72)) “opens record ID72 of ”Quotes“ table
However do not want to a form by its ID i want it to open by. sepcific field with the Quotes form ie ”QREF“ the quote refence number

so I know I need to copy the Qref from my current form 

let xCopy := ”Qref“;

popupRecord(record(Quotes,xCopy) -- does not work because it is expecting a record !! how do i change to find the recods that has the matching QREF

Then grab that ID or simply open it by the QREF field?

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    with a select statement you can do that.(this gives back a ID)

    e.g.

    let xCopy := “Qref”;

    let i := first(select Quotes where Qref = xCopy);

    popupRecord(i)

     

    Steven

    • Mel_Charles
    • 4 yrs ago
    • Reported - view

    Cheers Steven - Works a treat :-)

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 471Views