Fred

San Francisco, USA

3701
591
5

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: getting started
email Ninox support directly.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
@Rafael can you show your JSON code and your word doc so others can see what you did?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
@Rafael carbone does not like spaces in names. Please see my previous comments about using JSON and Ninox's recommendation in this post.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
@Alan Cooke said: Where/how do I use the JSON? This will be a first for me. Under Test Print there is a switch for Custom JSON, flip it on. Then click on the Fx button.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
I think you need to put the [i] after d. {d[i].SYSTEM} Then the 2nd line would be: {d[i+1].SYSTEM} Since SYSTEM, CATEGORY, AND NOTES are fields in a record,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Local, iCloud or Public Cloud ?
First time I've heard this asked. I've never come across any function to do that, but then that doens't mean it can't be done.
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Problem time field sum
nothing is wrong. 80 minutes is 1 hour and 20 minutes.
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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 field?
- Fred
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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. The current method gets all of the data that…
- Fred
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 52 53 54 55 56 149

Welcome to the Ninox community

Fred

My Posts

Re: getting started

Re: Dynamic Reports

Re: Dynamic Reports

Re: Dynamic Reports

Re: Dynamic Reports

Re: Local, iCloud or Public Cloud ?

Re: duplicate bug?

Re: loop in query for view -- how to aggregate?

Re: Retrieve the data from a button variable

Re: Retrieve the data from a button variable

Re: Retrieve the data from a button variable

Re: Generated an array with record numbers in a formula field.

Re: loop in query for view -- how to aggregate?

Re: single choice dynamical always selected

Re: Retrieving the past 14 working days dates

Re: Retrieving the past 14 working days dates

Re: Problem time field sum

Re: Count of records/table per day

Re: Known difficulties when using dynamic printing and their solutions

Re: Importing Data into a Dynamic Choice Field

Re: I Need the sum of 'total Time' for each time I change Client Choice

Re: I Need the sum of 'total Time' for each time I change Client Choice

Re: Is it possible to create a button that opens the corresponding table by inputting the table name?

Re: Count of records/table per day

Re: Count of records/table per day

Overview