0

Views

Hi,
I would like to know how to show timeline in calendar?

For exemple:
I have contract from 1.07.2016 till 31.10.2017, and the second from 1.08.2016 till 31.07.2018 (I have around 100 such contracts).
I would like to put the beginning date and end date (and that part is easy) but I can not show this period in calendar as a line.
I thought that If I put an appointment that would work but not. If you put even 10 appointments to the calendar is un useful.
I am looking for something like all day appointment like in mac's ical or like todo's record which is on the top of calendar.
Any ideas?
38replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Steve
    • Steve
    • 4 yrs ago
    • Reported - view
    The way it's being planned looks very natural and clever to me. But that also makes the learning curve a bit steep for general user. May I suggest to put all those "Font Setting" "Cloud setting" into the menu, under separate title "Preference" / "Cloud/Sharing".

    I understand the technical issue involved, as it would be safer to close the database first, before changing those. But we can always do a popup windows to say "Database will be closed for this action".

    Please consider this seriously. It took me so long to find out the global font setting. I am sure many will have the same feeling.
    Like
  • I want to create a view that does not show related tables as sub-tables. I just want the single-valued fields in the form.
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    For every field - even subtables - there is the property "visible if": Just give the word false to make fields invisible.

    Birger - Ninox Support
    Like
  • Great...
    Like
  • Is it possible the change the displayed column heading or field label in a form or view without changing the column name in the table?
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    It is possible. But the other way around :-)
    Click the column Head in table view and change the display name. Now you can rename the field in the form view as much as you want.

    Birger - Ninox Support
    Like
    • donnydave
    • donnydave
    • 4 yrs ago
    • Reported - view
    Hi,
    Is there a limit to the number of fields displayed in a table grid view ?
    I have 12 fields but only 8 (incl. id) appear in the table grid view.
    All 12 appear in selected record view.
    Like
    • Birger H
    • Birger_H
    • 4 yrs ago
    • Reported - view
    By default only the first 8 fields are displayed in table view. Click any column head and select "Show column" to have more fields displayed.

    Birger - Ninox Support
    Like
    • donnydave
    • donnydave
    • 4 yrs ago
    • Reported - view
    Hi,
    Thanks, that worked fine.
    Like
  • I have two fields that have values crated according to certain criteria. However, when I try to drop them into a list of fields to display in a view, they won't add. See https://screencast.com/t/o5B71zEZsLDj
    Like
  • Hi Paul,
    thanks for your hint. This looks like a bug. Could you provide us more information? Which Ninox version and which OSX are you using. Please write to support@ninoxdb.de
    Best regards and thanks for your help, Alex
    Like
    • millesoli
    • millesoli
    • 4 yrs ago
    • Reported - view

    I want to sort two columns:

    1st is a text (descending), 2nd is a number (ascending).

    How can I do that? how can I combine correctly a third column?

    THKS

    Like
  • You can create a thrid column as sort number. 

    the formula:

    ---

    let TT := yourtext;
    let NN := yournumber;
    cnt((select YOURTABLE)[yourtext > TT]) + 1 + cnt((select YOURTABLE)[yourtext = TT and yournumber < NN])

    ---

    now you can sort this column (ascending)

    Leo

    Like
Like Follow
  • 4 yrs agoLast active
  • 38Replies
  • 13191Views