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
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3614
570
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: How can I structure the extraction of inventory data?
@我是我的我 The second method is also quite doable. I am not talking about copying each record from the two tables, but a summary of the data from the two tables.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How can I structure the extraction of inventory data?
Can you merge the two tables together? It seems like the data would be exactly the same except for one or two fields. Otherwise you would have to create a button that would copy the data you want…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Scaling up - multiple users
One option is to use a website or google form that then uses some middle-ware like Zapier or Make to then make the changes to Ninox.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Why is there no response?
@我是我的我 said: What's even stranger is that the same code works fine in the database in the Public Cloud, but no data is returned offline). I'm not sure what you mean by this.…
Fred
Fred
1 yr ago
1
Get help
Reported - view
Re: Why is there no response?
Looking at 1 and 2 you don't need the contains() command. Since each record in "copy here" has only 1 value for name you can do a simple equal. let s := this; select 'copy here' where name = text(s.…
Attachment
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Pop-up field showing wrong columns
It is not a bug. Just not intuitive. I haven't played around with reference field Show Field As and I notice that fields now change depending on the type selected.…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
@Rafael said: hi Fred Now this is my Code. But the problem in this example, I should only appear year 2024 but appear 2023 too. Ok, well looking at your code closer (which I didn't do very well…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
@Rafael The code looks ok to me so I don't know why you are getting records that seem to fall out side the filter. Can you upload a sample DB with no personal info?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: I have two questions about HTML code.
For the 2nd question, you are correct your code can become very long if you repeat the table as well in your conditional statements. You can put your conditional statements inside the <style> part of…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
@Rafael what does your version of the code look like? I would also switch the now() to today() since you don’t need the time data that now() has.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How to use code to calculate the number of days in this year or next year?
@我是我的我 Do you want to know the number of days left in the year from today? You can try something like: days(today(), date(2024, 12, 31)) If you don't want to hard code ending date then you can create…
Fred
Fred
1 yr ago
Get help
Reported - view
Re: How to use code to calculate the number of days in this year or next year?
Can you be more specific?
Fred
Fred
1 yr ago
Get help
Reported - view
Re: Dynamic Reports
@Rafael add “order by JSONfieldname” at the end of your JSON, after the closing curly bracket.
Fred
Fred
1 yr ago
Get help
Reported - view
Re: getting started
email Ninox support directly.
Fred
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
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
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
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
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
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
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
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
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
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
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
Fred
1 yr ago
Get help
Reported - view
1
48
49
50
51
52
145
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
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
Usage overview
Process monitor
View all topics