Skip to main content
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
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3421
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: sibling tables
@UKenGB said: Trouble is that once in the 'view' you're just looking at c2. So you can access any of p's data, but no way that I've found to get anything from c1 as that 'link' has been lost.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: statistics
can you upload a test db so I can see your structure?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy text field to reference field
@Sam said: Fred Will you have multiple records in Table1 linked to a single record inTable2? yes So you can try this: let t := this; let newData := 'DATA ITEMS'.Data + " " + t.Data1; 'DATA ITEMS'.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy text field to reference field
@Sam said: Fred I think it may be linked through the dMC ‘Other Data’ The Dynamic value is: let xTemplate := number (‘Other Data’); (select Table2)[‘Other Data’ = xTemplate] dMCs do not create a…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy text field to reference field
@Sam said: let j1 := (create Table1); j1.(Data := i.Data); j1.(Table3 := xCurrRec) Question: is there a reason why you don't create the link to table2 when you create the records in the dMC trigger?…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy text field to reference field
Since Table1 has the reference field to Table2 (called Data Items) that means there is a 1 to many relationship between the tables, 1 record in Table2 has many related records in Table1.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy text field to reference field
Most things are possible.
@Sam said: The reference fields DATA ITEMS and the Dynamic multiple choice field are pointed to the same table. Table2. The Dynamic multiple choice field is located in…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Get time in minutes from the duration field type
The duration field (or Time Interval) is a tricky field. Here is Ninox's definition of the field type (scroll down to Time Interval): Time Interval A Time interval is the time between two points in…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Cannot save views
I'm still on MacOS11 and Ninox app v3.6.8. Now you have me worried about updating the app.
Don't know if the issues are related but to make sure your new views are saved you need to turn on Admin…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Body of Email field
Looking back at my code Ninox changed it so you can try: {if 'Is PPC to be included in report' then ‘Google Data Studio Link' end}
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Body of Email field
When I tested it, it knew code from text. What is your experience?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Body of Email field
If PPC is a yes/no field and you want check if it is set to yes, then you can do something like: if PPC then {'Google Date Studio Link'} end For a yes/no field just by putting the name of the field…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Get Previous Month
@John Halls I found out that Ninox does something similar when I created a solution to this post. You can just add to months and Ninox will increment the year as you pass 12, 24, 36, etc. months.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Get Previous Month
think this is the first time we posted at the same time.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Get Previous Month
I'm not sure what you want done. A simple formula to get the previous month as a month name could look something like in a formula field: let x := month(DateField) - 1;…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Show hide fields on mask...
Ninox doesn’t use the double equal sign so things should start working if you remove one of them.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filter Choice (Dynamic)
Well I would say that it is a limitation of cascading dynamic choice fields. I don’t think there is anyway for Ninox or any DB to figure out all the possible combinations that the cascading fields…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filter Choice (Dynamic)
I get the issue now. When you have a cascading dynamic choice field (dC), Ninox can't properly execute the code in Level 2 - Level 5 to create the lists since it is dependent on what is selected in…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filter Choice (Dynamic)
Ok, I'm not sure where you want to filter. Is it in a formula? or table?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filter Choice (Dynamic)
Ok, I'm looking at your DB. Can you walk me through what you want to do? What table are you in? What View are you talking about?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Filter Choice (Dynamic)
Can you provide a sample code you are working with? How is this different than your previous post?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Track selection of Dynamic Multiple Choice field
Which changes worked? 1) the removal of the variable? 2) Jacques?
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
What happens is you want to keep the history of the selections? Well I've modified the DB to now have a table (withHistory) where you can see how you can now have a history of the selections.…
Attachment
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Jacques TUR said: let dMCArray := for i in numbers(dMC) do record(Table4,i) end; I like this part. I didn't think of putting a loop in a variable to get an array of a dMC.…
Fred
Fred
2 yrs ago
1
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
It is only for this test DB since dMC and dMCJ both write to the Child table, making selection/de-selections in both dMC at the same time will cause the Child table and dMCs to not align.
Fred
Fred
2 yrs ago
Learn and share
Reported - view
1
97
98
99
100
101
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
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
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
@Sam said: The reference fields DATA ITEMS and the Dynamic multiple choice field are pointed to the same table. Table2. The Dynamic multiple choice field is located in…
Don't know if the issues are related but to make sure your new views are saved you need to turn on Admin…