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
3617
572
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 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
3 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Jacques TUR Again you are correct. My change to ">=" actually broke the tracking and when I changed it to =0 the tracking of selection worked again. I've updated the test DB and have included it…
Attachment
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
I wonder if this will fix the non-delete in the web version? Looking at your code I wouldn't have thought this up as it seems like Ninox would run both loops.…
Attachment
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
Looking again at my code the top part can be better written: let t := this; let childArray := Child; let dMCArray := numbers(dMC); let childCnt := count(childArray); let dMCcnt := count(dMCArray);…
Fred
Fred
3 yrs ago
Learn and share
Reported - view
Re: Track selection of Dynamic Multiple Choice field
Just tried it on my iPad and it works fine. I guess something in it the web version doesn't like. That is very interesting. Just noticed on line 6 I put the main part of the code in a variable then…
Fred
Fred
3 yrs ago
Learn and share
Reported - view
1
105
106
107
108
109
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
@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…