0

goto another record from calendar

Hi there,

have anybody ever tried to jump to a record from calendar where the record I not the one which created the calendar event.

I have this situation that I am in a table where I create a project lets call it table 1 - here I have a link to the table 2, where I chose a person to take the job and the appointment date and time, and then I go back to table 1 again where this activity now occur for further handling (offers, invites and so on). At the same time the appointment which was created in table 2 occurs in calendar.

When going to calendar and click with the mouse on the calendar event it goes back to table 2.

How do I force the system to got to the right record in table 2 ?

I have in table 2 a formula where I create the calendar text derive from information in table 1, and one of the ideas I had was to use the on click in formula in table 2 to go the record. and tried with below - but off course this does not work

 

let Xid:=this;
let Xpo2 := Masterprojekt;
let xGoto:= (select 'Table1' where Hovedprojekt= Xpo2 and 'table 1'=Xid);
popupRecord (xGoto)

Anyone has any idea of it is possible to do this.

rgds

Leo

9 replies

null
    • Leo_Woer
    • 1 mth ago
    • Reported - view

    Sorry one naming error :

    How do I force the system to got to the right record in table 1 ?

      • Leo_Woer
      • 1 mth ago
      • Reported - view

       

      Hi all - solved it somehow.

      What I did was to create a number field in table 2 which contains  the ID of the record in table 1.

      From the appointment field I placed in trigger after update which set the record ID of table 1 in the number field and then I created a button in table 2 with the text "Do you want to see the whole activity".

      In the click formula I placed the open record(table, nr)

      Script in Appointment field:

      if 'numberfield' = null then
          let Xpo := 'Projekt nr';
          let Xakt := number(last(select 'table 1' where 'Projekt nr' = Xpo)); (it will always be last in table 1)
          'number field' := Xakt
      end;

      Script in button:

      let Xakt := 'number field';
      let p := record('table 1',Xakt);
      openRecord(p)

    • Fred
    • 1 mth ago
    • Reported - view

    You may have to look into  great html calendar in his dashboard post.

    Since it is HTML based you can probably redirect to where you want to go. I'll leave it up to the creator to answer if that is true or not.

      • szormpas
      • 1 mth ago
      • Reported - view

        Hi, indeed, in theory we can open any record we want as long as it is somehow related to the current appointment.

      Assuming that Ninox will continue to support the internal function "ui.popupRecord()" in the future.

      • Leo_Woer
      • 1 mth ago
      • Reported - view

       Hi Fred thank you for your contribution - se what I answered all who wants to see

      rgds

      Leo

      • Leo_Woer
      • 1 mth ago
      • Reported - view

        

      Hi Sotirios thank you for your contribution - se what I answered all who wants to see

      rgds

      Leo

      • Leo_Woer
      • 1 mth ago
      • Reported - view

        Hi Sotirios

      have looked into your dashboards - and I must say that they are impressive. If I bumps into a customer who want such an impressive dashboard - can I then contact you for some help ?

       

      rgds

      Leo

      • szormpas
      • 1 mth ago
      • Reported - view

        Hi,

      I'm happy you like the Dashboard Template. If you need any help, please feel free to share your issue here on the forum so we can all contribute ideas and try to find a solution.

      • Leo_Woer
      • 1 mth ago
      • Reported - view

       Absolutely - I will

Content aside

  • 1 mth agoLast active
  • 9Replies
  • 64Views
  • 3 Following