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: Formula returning a record causes type mismatch
Ninox has two ways to reference records, one through the table and record Id (called nid), and one with just the record Id (called rid). When you do a select, Ninox will return a nid.…
Fred
Fred
8 mths ago
Get help
Reported - view
Re: calculate stock
My guess is it had something to do with where you put the sum() and number() commands. I put this in a formula field in Fakturalinier Materialer: let getAllRecs := (select 'Fakturalinier Materialer');…
Fred
Fred
8 mths ago
Get help
Reported - view
Re: calculate stock
can you post a sample DB?
Fred
Fred
8 mths ago
Get help
Reported - view
Re: Show value in Choice (dynamic)
@iliper LTD Good start. Can I recommend that you look at your previous post where you learned about the record() command. Here is the link again.
Fred
Fred
8 mths ago
Get help
Reported - view
Re: Show value in Choice (dynamic)
Take what you learned in your previous post and extend it to the new subtable. Post your code, if it works or not and we can help troubleshoot.
Fred
Fred
8 mths ago
Get help
Reported - view
Re: Formula for deriving the value
Since Salary is dynamic choice field you can use the record() command to get that record and then you have access to all of the data. record(Salary,number('Choice (dynamic)')).Number1
Fred
Fred
8 mths ago
1
Get help
Reported - view
Re: Dynamic Choice/Multi-Choice
@RoSoft_Steven Wow, that would be awesome. I haven't heard anyone talk about this yet.
Fred
Fred
8 mths ago
Get help
Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Forgot the part of showing the data: let selected := unique(Table1.numbers(multichoicefield)); let allPossible := select tableroot; let notSelected := allPossible[(var v := this; not selected[= v])];…
Fred
Fred
8 mths ago
1
Get help
Reported - view
Re: Duplicate a quote a change its number
Depending on how many fields that need to be duplicated, you can always put the Quote# code into your button so it will do the exact same thing as when you create a new record.
Fred
Fred
8 mths ago
1
Get help
Reported - view
Re: Trigger on create with numeric fields
@Mario Cuzzi can you post screenshots of the edit fields window for each table?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Trigger on create with numeric fields
Can you post a sample DB?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Trigger on create with numeric fields
Just to verify that Monto and 'Monto Prov' are actual number fields and Fecha in both tables are date fields.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Well that was dumb of me, you said so in your post. First step is to get a list of selected choices. You can try: unique(Table1.text(multichoicefield)) This will show you the dynamic value name of…
Fred
Fred
9 mths ago
1
Get help
Reported - view
Re:
Ninox E-Invoicing
Is this for both public and private cloud?
Fred
Fred
9 mths ago
Learn and share
Reported - view
Re: Dynamic multi-selection in the subform: Display of selected and unselected items.
Is the Muliple Choice field in Table1 a simple or dynamic field?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: Mimic spreadsheet
@gyannes Glad to hear it works out. When you have a moment, please mark the post answered.
Fred
Fred
9 mths ago
Learn and share
Reported - view
Re: Mimic spreadsheet
One possible solution is attached. I'm not very good with Ninox charts so hopefully someone who is more knowledgable can help out there. I'm sure you can do something like you post in an html table.…
Attachment
Fred
Fred
9 mths ago
Learn and share
Reported - view
Re: How to write code for data filtering?
@我是我的我 said: test.2 is the second method that was discussed (it did not correctly output the total for the specified date). You wrote: let getCopy := (select Data); let Onlyname :…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to write code for data filtering?
@我是我的我 Using the DB you uploaded, are you saying: date(time) doesn't give you just the date?
Fred
Fred
9 mths ago
Get help
Reported - view
Re: How to write code for data filtering?
@我是我的我 I’m talking about just the name of the date+time field.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: adding eg 7 days to a date+time field
@Kruna Please mark the post answered.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: goto another record from calendar
You may have to look into@Sotirios Zormpas great html calendar in his dashboard post. Since it is HTML based you can probably redirect to where you want to go.…
Fred
Fred
9 mths ago
Get help
Reported - view
Re: adding eg 7 days to a date+time field
@Kruna use@John Halls
Fred
Fred
9 mths ago
Get help
Reported - view
Re: adding eg 7 days to a date+time field
@John Halls Of course, I put my parenthesis in the wrong place. I was trying to do something like this. Thanks for the simpler way.
Fred
Fred
9 mths ago
Get help
Reported - view
Re: adding eg 7 days to a date+time field
@John Halls I get an function not defined error message of number, number, string.
Fred
Fred
9 mths ago
Get help
Reported - view
1
18
19
20
21
22
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