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: Neither of the two formulas work
To do a series of dates you need the for loop command. Which means you need an array of the dates you want to create records for. One way is to create the array in the formula.…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Related table field reference
I've made a few changes you can check out. @Gianluca said: I need to sum all the purchases made by a person, grouped by a "category" specified in the "Catalogue" table (in this sample: guitars,…
Attachment
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Neither of the two formulas work
You have to remember that select statements always return an array. So for the first one you need to do a few things: let xDoc := first(select 'DOCUMENTOS'); let xFld1 := xDoc.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Date function
Yes, this whole "no code" advertising is very mis-leading. You can use the format function: format(datefield,"D MMM") Here is a list of formats available.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Related table field reference
@Gianluca said: And to make things more complicated: would it be possibile to add more conditions with references to more tables? something similar to the wrong one here below: let a := Customer.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Related table field reference
@Gianluca said: with both formulas (used in both tables) I get this error: "Expression does not return multiple values". You get this when you try to follow a link in the wrong direction.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Filter on hidden columns
Welcome to the unwritten logic of Ninox. When you switch from pop-up to combo box, Ninox changes how you modify what is shown. If you have the reference set to Pop-up,…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Filter on hidden columns
It will helps us all if you can post the code you are using and any information about the table structure that could help. Thanks,
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Filter on hidden columns
Just to be sure, you are talking about a view like a new table view or form view or chart view. Or are you talking about a view element?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Related table field reference
Are you creating this new sum formula in Table2 or Table1? John's formula works if you are in Table1. If you are in Table2 then you have to use the select function.…
Fred
Fred
3 yrs ago
1
Get help
Reported - view
Re: Help with wedding base
Sorry to hear about the crashing. I too use the app version. I've only experienced that when trying to delete a lot of records. If it happens every time then I would recommend reaching out to Ninox…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Return to my Topic
Maybe I'm not following correctly, but it seems like for the %_Plan field in the Avances table should be your master number for your DB. This will force a big rethink of the design of your DB.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Return to my Topic
Got the DB. Now I'm not sure what you want '%-Plan' in Plan_Real to be equal to.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
Thanks Steven, Just needed to switch things around. I guess I should have asked that before posting in the wish list.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Conversion into Ninox of old relational data
Glad things worked out. John's suggestion is good for a repeating task. I figured once you imported everything, you only needed to link them once and any future records would be linked manually or…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
I think it would be great to be able to use if statements to create variables and then use them in formulas later. for example: let t := this; if field1 = null then let var1 :…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Return to my Topic
Can you send me an updated test DB? You are showing a new table that I don't have.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Conversion into Ninox of old relational data
You can follow @Alain Fontaine advice in this forum.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to query a table using a dynamic combo box value?
Reading it again there is no mention if the dynamic choice field is a choice or multi-choice field. This current solution only works if it is a single choice field.
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to query a table using a dynamic combo box value?
oops, I again didn't read the subject line. I guess your solution will work if the record Id from Assigned To matches the one from Staff. We don't know which table Assigned To pulls from.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Return to my Topic
I like that you now track the weeks in a separate table. I think that is a good idea. I'm not sure what you are doing with the select statements. Why are you specifying a specific record?
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: How to query a table using a dynamic combo box value?
Hi there: May I suggest you try: let i := 'Assigned To'; first((select Staff where 'Full Name' = i).email) In Ninox you put the field you want at the end of the select.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Help with wedding base
Still learning new things everyday. I didn't even know you could import a CSV as a table. Try opening a table, then select the gear icon and then select Import data and here is where you match…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Formula for combine two Alerts Date's
let curRec := this; let xDate := cnt(select FERIADOS where Fecha = curRec.FechaR5); if xDate > 0 then let result := dialog("", " Esta Fecha es un Dia FERIADO.…
Fred
Fred
3 yrs ago
Get help
Reported - view
Re: Help with wedding base
While your new plan for a new DB will work, John offered to show you how to script the transfer of data between your current tables and a new consolidated table.…
Fred
Fred
3 yrs ago
Get help
Reported - view
1
115
116
117
118
119
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
