Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Displaying a record in another table
@iliper LTD Do you want Daily Estimations linked to GM TABLES? You have it setup to be N:1 from Daily Estimations to GM TABLES. It would work better if it was switched,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD In your workflow, do you always create hourly estimates for all tables? do you want the ability to select the tables you want to create hourly estimates for?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying a record in another table
Take a look at the attached DB. It will open to a dashboard. You can play around with the selecting a GM TABLE record then a table record then you can click on Create Hourly Estimate and see that it…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying a record in another table
Are GM TABLE records differentiated by Date? So there is only 1 record in GM TABLE for each day? Your Daily Estimation table seems a bit redundant if your GM TABLE is also daily.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD said: let d := format(Date, "DD.MM.YY"); (select 'Table2')[format(Date, "DD.MM.YY") = d].number if ш use this formula, having previously created the 'Date' fields,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD said: I created a new field, I thought to add a button, but it creates a record, but when I open a new day, it is empty. I'm looking at the new DB you uploaded and I can't find any other…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD Are you updating the button in Table1? or creating a new button? in which table?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD said: in table2 there are records. And if in table3 I create a day, and on this day in table2 there is a record, it should be displayed in table5 I need to work with tables,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying a record in another table
@iliper LTD said: now the system is set up so that I need to enter the same data in table 5 p in fields 'tab.name' - 'number' - 'group' and the rest will go automatically.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox 3.13
The example Nioxus gave is probably not too common, we know we shouldn't have too many fields that are labeled field01 and field02, etc. But it can be useful if you creating a dashboard that you want…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox 3.13
@Sotirios Zormpas That is correct. You can use the plain language field name and Ninox will convert it to the Ninox field name on the fly.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button that creates a new record for the next month
@John Halls I did know that. It is very handy of Ninox to do the math for us. Now you can just add 12 to your months to add years as well.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Countdown Date
Just a thought process. 1 month is about 2.6 billion milliseconds. But what about February? 1 day is about 86 million milliseconds. So three days difference in Feburary is about 258 million…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: ninoxLocales.AggregationName is not a function
Check out this post.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox 3.13
@Sotirios Zormpas I can already see a big change for my DB with the get/set function.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox 3.13
Nioxus did a better presentation of the get/set function. Ninox is more focused on the UI customization changes.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Countdown Date
To be more accurate it would have to take into account multiple years: let x := if year(Date) > year(today()) then (12 * (year(Date)-year(today())) ) + month(Date) else month(Date) end;…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: API Down on Public Cloud Yesterday
I hear you, brother. A company that won't list their bug fixes is one that is in serious need of communication help.
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Button that creates a new record for the next month
@iliper LTD You need to tell Ninox where the Date field is coming from. If it is not in the table the button is on then you need to tell it where to get it from.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Countdown Date
You can also try: let x := if year(Date) > year(today()) then 12 + month(Date) else month(Date) end; month(today()) - x It is not as short but a bit more understandable to those new to Ninox date…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Ninox hanging, not letting me edit and very slow
@TKay I'm glad things are moving in the right direction. We have all been there with select statements. I emailed Ninox about the same thing when I got started as well.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: What is the max number of characters that a text field can be defined to hold?
There is the multi line text field as well that can hold more. You can also try out the rich text field. The text field is not meant to hold multi line data.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Problem with "choice" the correct operation of fields
Glad it works. Looking closer now (because my brain works very slowly), why do you need Choice = 3 or = 4, if Show 14 is always 0 when they are selected? Wouldn't it work just with:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox hanging, not letting me edit and very slow
@TKay what level of subscription do you have with Ninox? you can only do what Mel describes at the Pro level.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Problem with "choice" the correct operation of fields
Try putting ( ) around the Choice fields? 'Show 14' > 0 and (Choice = 1 or Choice = 3 or Choice = 4)
- Fred
- 1 yr ago
- Get help
- Reported - view

1 35 36 37 38 39 153

Welcome to the Ninox community

Fred

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Displaying a record in another table

Re: Ninox 3.13

Re: Ninox 3.13

Re: Button that creates a new record for the next month

Re: Countdown Date

Re: ninoxLocales.AggregationName is not a function

Re: Ninox 3.13

Re: Ninox 3.13

Re: Countdown Date

Re: API Down on Public Cloud Yesterday

Re: Button that creates a new record for the next month

Re: Countdown Date

Re: Ninox hanging, not letting me edit and very slow

Re: What is the max number of characters that a text field can be defined to hold?

Re: Problem with "choice" the correct operation of fields

Re: Ninox hanging, not letting me edit and very slow

Re: Problem with "choice" the correct operation of fields

Overview