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
3863
posts
624
likes received
5
followers
Badges
Latest Posts
Re: Embedding a multiple choice dynamic field
@Holly M what is the error message? You did change to the appropriate table name?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Embedding a multiple choice dynamic field
The one issue I see with using a dMC in your dashboard is that it will make people think they can change the root data by changing the dMC. When that is not the case.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Embedding a multiple choice dynamic field
Just to be clear, you want to create a field in the Dashboard that shows the value of a dMC in Projects? How do you want to show the values of the dMC from Projects? In a formula field? In a dMC?…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Embedding a multiple choice dynamic field
Let me see if I understand the post. You want to create a dynamic multi choice (dMC) field in a form that is in another table, but you want that dMC to be influenced by the data in the dashboard?…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: When creating a new record in ‘Ride Log’ I need to do 2 things with that number: Set field ‘Route ID’ in ‘Ride Log’ to ‘Route ID Match’ Set the link reference field Route_ID in…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Filtering contacts from a specific client
You are trying to constrain ATTN, so you need to use another field, which in the Quotes table would be the field called Customer. I’m guessing Customer is a reference field to Company,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Leave formula field empty if .....
@Bernd Krell said: If Qty is more then one, then 'Total Sales Price' is empty and so is TOTAL field. That is weird. I was able to duplicate it. You can try the other way Fabio recommended:…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
Ok take a look at this attempt. I've used a "dashboard" to interact with your data. It will open to a new table "Dash1". From there you select the Conference,…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: More Vieweirdness
Alan brings up a good point. Can you share a formula that you have issues with?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Linking tables after importing from database
can you give us a bit more information? what are the table names? what are the reference field names in the tables?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Filtering contacts from a specific client
Constraints are not very obvious. Since you didn’t tell us what your fields are I’ll use the example from this original 3 year old post. When you open the constraint window on the left hand side you…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: Each speech is based on different language pairs and directions depending on the speaker. You see on "slides" I have a Language VO (source language) and a Language VI (target…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: I also have one "Slide" where the fx field (ConceptNr) is populated although no concepts are clicked. This is a bug in Ninox. Check out this post for more info about this.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
Since Concepte is based on 'topics n:m' table (but called 'Related SubTopics' in the Main Topics table), the formula for the view 'Trems' is: let dmcselection :…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Column Filter Date?
For the formula you can try: concat('Previous Order'['Date of Previous Order' = date(2022, 10, 17)].'Date of Previous Order') I’m guessing ‘Date of Previous Order’ is a date field.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Column Filter Date?
Can you try = “(fill in date)”
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. don't know. never seen that before. yeah, try to keep it simple and small.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. That is correct. You save an archive then click on the paperclip to upload the file. Don't worry about the mess. You should see mine. It has grown organically as I've learned so it is…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: can I hide a table only for one user?
@Javier Gómez Here is a sample. A user wanted something that they can make a table "read-only". You can view the post if you want. Going this route will mean a ton of work on the front end as you…
Attachment
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: with all the different relations between the tables perhaps the index numbers in "Concepte" (I need to change the typo) are not the same indexes in "Sub Categories" ?…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: can I hide a table only for one user?
@Javier Gómez Have you considered using dashboards for all interactions for the general user? All data entry is done through dashboards so you control ever part of the UI and actions?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
Some questions about the the field Concepte: record('Main Topics',number(Speeches.Conference.Topic)).SubList order by 'Sub Topics' 1) what table is this field in? 2) is SubList a reference field,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Two condition nested If not working
I got focused on the wrong element of your code. Yes subtracting date fields is a bit confusing in Ninox. In the background, Ninox uses milliseconds to keep track of date/time fields,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Two condition nested If not working
@Holly M said: That tells me the coding is correct, and there perhaps is a bug? Hi Holly Your code does not allow for the option of "yellow" to ever be the result.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Warning of dynamic multi choice bug
An update, looking over my root table I did make changes. And I do make changes all the time. Sorry for the incorrect statements earlier. So it looks like if you never delete records from the root…
Fred
Fred
3 yrs ago
2
Learn and share
Reported - view
1
96
97
98
99
100
155
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
Private Cloud Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
View all topics
