0

Open a table as a popup

Can anyone tell me if it's possible to open a table as a "popup" - and if so, how to write that piece of code?

(case: I have a topic-library table containing info that I need to access at different places in the database - for now I have to close the present form, go to the info-table, find the info, and then return to the actual form - very time consuming)

J-)

10replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • as far as I know there isn't a popupTable command

    you could use openTable to go directly to the table

    openTable("customers", "all")

    this opens the tabel called custoemrs on the all view

    but this takes you away from the other table

    Otherwise you could embed a table view into your form and have it on another tab or even hide it

    I'm busy with work at the moment but when i get home I will show you a screen dump of how it have a vew that does this

    Like
  • John

    if you wanted to to see a specifc record in the othet table you coukd use popupRecord() command 

    Anyway

    So when I'm in my jobs table I want to see all the quotes related to that customer as well as the last job done for them

    so I use the popup record for the last job

    and also have a table view that is limited to just that clients quotes (but you just show the whole table for your use)

    So on my form I have a yes /no field called show quotes

    then I added the table view

    and set it to only show when the show quotes is true.

    this has the effect of popping up

    see screen shots

    normal job screen!

    Screenshot 2021-10-22 at 15.26.57 

     

    screen shot when show quote = yes

     Screenshot 2021-10-22 at 15.27.13

    view code

    Screenshot 2021-10-22 at 15.27.50

    Like
  • Pressing the yes button (flag) makes the fields and the table view become visiable and the rest of the job is shuffled down the page out of site

    (I also use a large space attribute to make the rest of the page tidy). Pressing the show quote flag again turns off the visabilty and the job returns as per the first screan shot. 

    As stated, this shows only the quotes that are related to that customer but it does not have to be - You could easily show all the quotes (or whever table you want to show)

    I use the openRecord to show a directly linked quote for that job too and I use lots of variation of this..

    ie when in jobs - show me all the jobs for today (without leaving the current job) etc

    Hope above helps but as ever there will be other ways to do what you want.

    Mel

    Like
  • Have you thought of using a view?  Select it from the layout items and use a select to use it.  When you click on a record this pops up.  You can also use an embedded field.  Andy from Nioxus explained this in one of his webinars and it works well. 

    Like
    • John
    • KAXIG ApS
    • John.1
    • 9 mths ago
    • Reported - view

    Guys, thanks,

    my aim is to avoid all the "navigation" back and forth (or actually forth and back :)

    The most appealing solution, for now, is the openRecord() function, since that will need only a button on each page (many pages)

    But thanks again for your effort - I'll have a play with it.

    Have a nice one :)

     

    / John.

    Like
  • Hi John

    Just remember the openRecord will only open 1 record wher as the table view as sateated by me and john will open all or a filtered list of records

    Like
    • John
    • KAXIG ApS
    • John.1
    • 9 mths ago
    • Reported - view

    Thanks guys,

    the "view" solution may be better - The only problem (I think) is that it isn't possible to add new records in views - but I've made a way around that with a tiny button :)

     

    So it'll have to do for now.

     

    Have a nice one ☀️

    J-)

    Like
  • It's easy to add a button to add a new record.  Make a button and make the code like this 

    let c:= create "Table Name"

    you can use c.fieldname to add any default informaton.  You can have numbers codes 

    closeRecord()

    popupRecord(c) 

     

    that will add a new record to the table and it wiill show up on the view.    

    Like
    • John
    • KAXIG ApS
    • John.1
    • 9 mths ago
    • Reported - view

    Thanks Nick,

    I have made such a button already, but sometimes one will have to see all the records in the lookup table, which is why it would be easier if it could just open "on top" instead of closing everything down, ( closeAllRecords(), openTable() ) which is easy enough - it's the way back to where you were, that is mildly frustrating.

    But I'll live with that.

    :)

    Like
  • then don't use the closerecord button().  On a view you can size the form that pops up to see all of the other records.  You will have to go back to the original table of the view and size it there then it will work on your form.! 

    Like
Like Follow
  • 9 mths agoLast active
  • 10Replies
  • 760Views