Skip to main content

Ninox-Documentation

Fred

Fred

San Francisco, USA

2565
376
2

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: Latest update broke Ninox!??
@james said: On the Mac App Store, Ninox is now at 3.7.6. Has anyone updated to this version? Is it still buggy? So far so good for me. They fixed Jason's issue and sorta of fixed mine.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Where is Working Phase Lookup????
@Mauro Schiappelli said: In the new created record the Field WorkingPhase is null. But newWorkPhase contains value!!! That was my first question. If you put: let currentRow := this; let newPhase:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Newbie Formula Question
Welcome to the world of DB. What is the reference field name that links your two tables together? Can you post a picture of your data model?
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Time calculation problem after the update
if you create two more formula fields and put: number(Time1) in one and number(Time4) in another you will see that they are not the same time. Time1 is exactly 3,600,000 and Time4 is 3,646,313.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Choice field: There can be only one!
One possible solution is to put this in the Trigger after update of the Status field: let t := this; if Status then for loop1 in (select child)[toTable2 = t.toTable2 and Id != t] do loop1.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Enforcing Referential Integrity
You can always change Composition to "No" then when you delete a record in the old Parent it won't delete the child.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Enforcing Referential Integrity
Ninox already does what you are wondering. You can always build a test DB and try it out.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Choice based on field content
Take a look at the substring function to find out what is in the 5th position of the text field. Do you need help with setting the choice field?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button for create a new record which has a connection to a record
I can try. You have a good start with: create TableName The issue you are encountering is you have not specified the record to link to the new record in TableName.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Ninox DB viewed in a Wordpress Website
Hi Carlos - If you want to provide interactive function (allow them to select their name and pull up specific data on just them) on your site then you will need to use a third party service like…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Formula needed:
Here is one solution: let t := this; let x := first((select AVANCES_PROYECTO)[Semana = t.Semana - 1]); 'Horas Ganadas Real' - x.'Horas Ganadas Real' It will give you a blank for the first record and…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Formula needed:
Would you like me to post a possible solution or would you like my help in figuring out a solution?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formula needed:
Can you post the code that you have written so far?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to get a Max numeric calculated value
Steven is correct. Ninox either 1) allow the code to go through since there is no error message or 2) shouldn't allow it and error out. bad form on Ninox's part.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Can I use a "sum" function to add up just the items found through a search?
I actually didn't answer your question. To take your formula: sum((select collections).value_av) and to then filter it you can add the following sum((select collections)['title or name' like "Rex the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trying to copy Date and Date + Time to new Field
You can do some regex in Ninox. But it is always better to have clean data to start with.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Can I use a "sum" function to add up just the items found through a search?
You have two options: 1) You can use the table form (all) in your collections table. You can display the field value_av. Then you can sum the value_av column.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninext loading modules not requested
I posted this on Friday but I didn’t realize that I lost the ability to post for the whole weekend, this post was held up for moderation. After I posted I saw that you posted your new info.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Ninext loading modules not requested

Hi @Jacques TUR I just saw that my DBs are now loading all modules even when I specify only specific ones. Here is what I have in my formula: var configLoadModules := { badges: true, evalJS: true,…
- Fred
- 1 yr ago
- 2replies
- 55
- Get help
Re: Array trouble after update
I'm currently running 3.7.3 as well and I haven't noticed anything so far and I uses arrays in my formula everywhere in my main DB. What I don't do is use the array function,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: The Formula don't work. For Approval view
You wrote the same if statements: if 'Rev 0' != null and if 'Rev 0' is not null are the same thing.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Script for transfer record N:1
let tx := Deliverable first(select 'Control_Table' [Deliverable = tx]) There is no 'Deliverable' field in Emisiones, so this code won't work.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Fonts, Colors and Borders
Oops, didn't notice the date of the post. Thanks.
- Fred
- 1 yr ago
- Learn & Share
- Reported - view
Re: Fonts, Colors and Borders
Can you upload it here? It won't get deleted by anyone. :)
- Fred
- 1 yr ago
- Learn & Share
- Reported - view
Re: Select multiple rows from en embedded table
You have two choices here: 1) you can create another Contacts reference field, yes you can have multiple links to the same table. Then you can select a second Contact record.…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 58 59 60 61 62 103

Back to top

Ninox-Documentation

Overview

View all topics