Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3920
posts
633
likes received
5
followers
Badges
Latest Posts
Re: duplicate bug?
You are correct. The record gets created but Ninox does not take you to the new record. I am also running 3.11.4. This does NOT happen for public cloud DBs in the app or in the browser.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: loop in query for view -- how to aggregate?
So you want to end up with records in Benefices where the entry equals the entries of the current record? Wouldn't this work? let my_event := this; let my_entries := unique(this.'is testified by'.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Retrieve the data from a button variable
@Sébastien Guillet I think I get it. You can't access information in a button. Your button writes to the field 'text_birthday' you can access data in that field.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Retrieve the data from a button variable
@Sébastien Guillet Try: from: loop1.Entreprise.'E-mail', to: loop1.'E-mail principal', subject: "Happy birthday", text: "Bonjour" + if loop1.'Prénom' then " " + loop1.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Retrieve the data from a button variable
Or you could put the code from the button that generates the text into your loop.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Generated an array with record numbers in a formula field.
Take the base of the Total Time formula field and make a change to line 3. let t := this; let cc := record(clientchoicetablename,number('Client Choice')); cc.'Booking Time'[Date = t.date].…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: loop in query for view -- how to aggregate?
You may want to look at this post to compare two arrays.
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: single choice dynamical always selected
I was not able to reproduce the error. Are you using the app local DB, or public cloud, or private cloud? Can you upload a sample DB?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Retrieving the past 14 working days dates
Here is another way to do it: 1DayBefore switch true do case weekday(Date) <= 0: Date - 3 default: Date - 1 end Then the next field is: 2DaysBefore switch true do case weekday('1DayBefore') <= 0:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Retrieving the past 14 working days dates
Here is one possibility: The code is: 5DaysBefore switch true do case weekday(Date) <= 4: Date - 7 default: Date - 5 end 4DaysBefore switch true do case weekday(Date) <= 3: Date - 6 default:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Problem time field sum
nothing is wrong. 80 minutes is 1 hour and 20 minutes.
Fred
Fred
2 yrs ago
2
Get help
Reported - view
Re: Count of records/table per day
@Christoph said: What is the value in Number in Table1? I have various values in the Number field. I also have multiple records that fit each day of Month, otherwise average doesn't work very well.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Known difficulties when using dynamic printing and their solutions
I would like to see how to modify the appearance of tables, i.e. have different rows in different colors.
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Importing Data into a Dynamic Choice Field
I'm confused on what is being asked anymore. @Dave Irving , are you trying to update the choices in a dynamic field (to add more choices) or update the record of the selected choice in a dynamic…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: I Need the sum of 'total Time' for each time I change Client Choice
oh, yes forgot about that. Maybe try: let cc := 'Client Choice'; let date := Date; sum((select 'Booking Time' where Code = cc and Date = date).'Total Time') Or you can do it through the dC field:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: I Need the sum of 'total Time' for each time I change Client Choice
maybe something like: sum('View by Choice Client'.'Total Time')
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Is it possible to create a button that opens the corresponding table by inputting the table name?
Sadly there is no direct way of doing that. The table names we assign are like domain names, they are just a front for the real name that is assigned by Ninox.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Count of records/table per day
@Christoph said: I think there should be a function to group in a select statement! I don't quite understand why you would need to group in the select.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Count of records/table per day
@Christoph I changed the field from sum to average and got: Here is the change in the Edit Columns: I changed the Name and Footer.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Importing Data into a Dynamic Choice Field
@Dave Irving Sorry for not being very clear. I'm talking about importing into the root table of the dynamic field. It is a table so you can do all regular table functions.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Importing Data into a Dynamic Choice Field
Since dynamic fields are based on tables, you just need to import the data into your tables. You can tell Ninox which field is the key and it won't import data that is already there.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Count of records/table per day
@Christoph If you want to do charts then you probably don't need to create any more fields. I don't use charts but was able to create the following very quickly, after watching a Ninox video.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: moving database from one account to another
@AlexisOYeah that is a very limiting "feature" of the starter edition. If you have access to a MacOS computer you can download the app and there you can download ("export") a copy of your DB.
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: CSS Framework & Ninox
Very interested in this topic as I've just started using html in my forms. What I found out that is that I could only reliably modify text and format when inside a table.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Why does NINOX recommend entering data from a form?
Not to throw too much at you, but when you get the a chance you should see if your brokers allow API calls so you can access your brokerage data in Ninox (if you have a public cloud account).…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
1
61
62
63
64
65
157
Ninox-Website
Overview
Learn and share
Get help
Service status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
