0

OpenRecord not popupRecord

Is there a scrip to open record instead of popupRecord, l replaced the popup with openRecocord and it didn't work  

popupRecord(record(CUSTOMER,CUSTOMER.Id))

any suggestions appreciated 

'Michael 

4 replies

null
    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    openRecord(recordID)

     

    example openRecord(record(Invoices, 500). .... opens invoice number 500

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    Micheal -- sorry that should have an extra bracket on the end - i missed it off

    openRecord(record(Invoices, 500))   .... opens invoice number 500

    also see example on page 80 of user guide - under heading on this site "support manual"

    • Central Park Furnishings
    • Michael_McKenna
    • 3 yrs ago
    • Reported - view

    Hi Mel, l have used this script before and works well if you reference the Id of the record however l was looking to reference a Customer table search function and open the record from that in a button script. 
    ln my non code brain l was thinking 

    openRecord(this,Customer.ld) but l guess l have to reference the linked customer to the script somehow. 

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    Dunno if this helps

    I have a table called JobDockets 

    in that table I have a field that stores the last job number and a button next to it containing the following script.

     

    let xCopy := 'Prev Ref';
    let i := first(select 'OldJobs' where 'JobRef' = xCopy);
    openRecord(i) or (
    let i := first(select 'NewJobs' where 'JobRef' = xCopy);
    openRecord(i)
    )

    This looks for that record (JobRef) in an archived table 'OldJobs' or the current table 'NewJobs'

    then jumps to that record

    I think this is what you are trying to do?

    Mel

Login to reply

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 820Views