0

How to show AND link a 'last' field

Okay so here's something that's both good but also really annoying.

I have a table of Clients and a table of Jobs.

I can show the name of latest job with the last function in the column options or 'footer'

When I look the formula ninox creates is 

last('Jobs'.Job Name)

In the customer table this then shows the last created job. Great! But when I click the table cell it just shows the customer's information, not popup the job.

Is there a way I can create some kind of field or table entry where it jumps to the job and not the customer?

5 replies

null
    • Mconneen
    • 5 yrs ago
    • Reported - view

    I am guessing you have a database that looks something like this.. 

    dataModel

    And you have a Client view that looks something like this.. 

    ClientsLastJob

    Assuming YES... The reason you see the Client record when clicking on it is because the Client table is the source view. 

    Try something like this.. 

    Jobs

    In the above view.. Note that Jobs is the source table.   I have added a filter column that compares the Job.Job Name to the associated Customer.Last Job .. and set the filter to YES. 

    filter

    Now.. when you click on it.... You will see the "last job" job record.    

    • dmage
    • Ul_Vohrerdmage
    • 5 yrs ago
    • Reported - view

    You have correctly assesed the layout of my database; however the above, though useful, isn't really a solution that's useful to me.

    This is a very busy fine art printing company. If I have a very long list of Clients I would like to be able to scroll the top level data base and click on either the Job name or the thumbnail and for it to jump to said job. This would be useful in either the table or the form view, however it would not save time if I was already within the jobs table to click it.

     

    Kind regards,

     

    Ian 

    • Mconneen
    • 5 yrs ago
    • Reported - view

    @Ian...   OK..  As we like to say.. the devil is in the details.... or put another way,  clearly outlining the use case is key.   :)

    Just from the above, how about a Kanban card view of "Jobs"?  I assume jobs have a status... scheduled date, etc..   What the Kanban columns would be are dependent on the use case.   They could be by job status, scheduled within N days.. etc. 

    That said, if you want to "click the row" and jump to the job.. I do believe the job table needs to be the source.... so you may want to create a dashboard (has buttons / etc)  and then jump to the view you desire..   

    Perhaps schedule a call with either ninox support.. of another partner to discuss your use case in detail.. they can certainly help you short cut your path. 

    • Mconneen
    • 5 yrs ago
    • Reported - view

    @Ian.. Here is a very quick / dirty Kanban view.. I totally guessed at what the job status might be..   You can make this view your opening view.. or you can put it on an opening view dashboard / switch board view..   You could also filter this view to be within a date range..    As you said a "very busy....."   I am not sure that a calendar view would be useful.. Might be too many entries on a single day. 

    jobStatusKanban

    • NIOXUS
    • 5 yrs ago
    • Reported - view

    Bilderblitzberlin - we have a Job/Project/Workflow Management Application that may be the solution for which you are looking.  If you like, go to WWW.NINOXUS.COM, sign up for a free password and then log into the User Portal.  Once there, look under the Data Models menu for the Project Management solution.  This tool has been used by many of our clients who have very similar needs to yours, including two large printing and print media production companies.

Content aside

  • 5 yrs agoLast active
  • 5Replies
  • 2022Views