Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Table or Sub-Table?
@Michael Cornelissen Seems like Work Orders doesn't need to be a child of Invoice. Invoice is what the goes out to the client, and work orders are internal.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Table or Sub-Table?
@John Halls Was not implying you made any of DB mistakes that I made.😉 I agree that you should try to use as few tables as possible. Some go the other way and create new tables when all they needed…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Table or Sub-Table?
Don't worry about too many tables. 😂 The important thing is if the data is different enough to need a new table. Most people don't make enough tables. If you find yourself making field names with a…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button for writing to another table
@iliper LTD said: What is interesting is that the record is displayed in the "advance" table itself, but it is not in the sub-table that is in the employee account.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Vermaji said: Please advise me if I am wrong about using SELECT statements. I am not knowledgeable at all of how Ninox's backend works, so I can't say if using select statments will make any…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Vermaji said: I don't want to leave Ninox. I don't understand what should I do at this stage !! One option is to create another tables that stores the selection made in the dynamic choice.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button for writing to another table
@iliper LTD 1) the variable i is the new record in the ADVANCE table so that is where it is looking and it looks like there is no field called EMPLOYEES.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Sotirios Zormpas You would only see this in root tables that have deletions as now gaps have been created and defragging closes those gaps. You should ask Ninox about the manual defrag operations.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Button for writing to another table
let x := dialog("NEW RECORD", "CREATE NEW RECORD?", ["No", "Yes"]); if x = "Yes" then let d := Date; let xCurrRec := Id; let xNewName := Name; let xNewAmounnt := Amount; let xNewComment := Comment;…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ninox 3.13 available
@Sotirios Zormpas What I don't understand is how that issue slipped through since Germany doesn't use the USofA date format.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Data in the OrderItems table changes on its own
@Vermaji Sadly I've reported about this over a year ago. Lucky for me I was only using the dynamic choice field as a UI element and not as real data. This post can help you with the code to put in…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Button with script to populate table
@John Halls love these posts where the original poster hasn't responded but others continue it.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Ninox 3.13 available
@Mel Charles That really sucks. Didn't this happen with 3.11 as well?
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Button with script to populate table
1) just to be clear, you have reference fields in table 6 that links to table 4 and 5 separately? or is Table 6 a child of table 5? 2) Where will this button sit? Table 4 or Table 5?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamik Choice field
@iliper LTD you have to decide between openRecord(nid,string) and popupRecord(nid,string) openRecord() takes you to the table then opens the record, so when you close the record you are in the new…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Dynamik Choice field
@iliper LTD In Dynamic Values: 'GM TABLE'.Tables order by fieldname
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
what kind of field is Item Name in Order Items?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger - Update Number Field with Formula Value - en masse
a couple of suggestions were posted in FB. what do think would work for you?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamik Choice field
in the code for the dynamic choice field add order by fieldname select tablename order by fieldname
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum the value of the result field from table1 when the value of deportment is "1"
@iliper LTD Try: sum(estimation[Departmennt = 1].result)
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Sum the value of the result field from table1 when the value of deportment is "1"
is this formula in the same table or in another table? If another table, are they related?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Synchronization not working
@jesusfreakk_alex to get the app version: 1) open the app 2) click on the icon in the upper right corner 3) at the bottom of the new window it will say is this the iOS or Android version?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Synchronization not working
What version of the app? is your DB stored in the cloud or iCloud?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Field of type JSON
My answer to your immediate question about rate is to create a subtable to Menu called variations, or whatever makes more sense to you. Then it is in this table that you track Units/Container…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: FeatureRequest: Show FunctionDefinition in Editor
If you haven't already, you should email it to Ninox. They don't really respond to this forum.
- Fred
- 1 yr ago
- Learn and share
- Reported - view

1 32 33 34 35 36 153

Welcome to the Ninox community

Fred

Re: Table or Sub-Table?

Re: Table or Sub-Table?

Re: Table or Sub-Table?

Re: Button for writing to another table

Re: Data in the OrderItems table changes on its own

Re: Data in the OrderItems table changes on its own

Re: Button for writing to another table

Re: Data in the OrderItems table changes on its own

Re: Button for writing to another table

Re: Ninox 3.13 available

Re: Data in the OrderItems table changes on its own

Re: Button with script to populate table

Re: Ninox 3.13 available

Re: Button with script to populate table

Re: Dynamik Choice field

Re: Dynamik Choice field

Re: Data in the OrderItems table changes on its own

Re: Trigger - Update Number Field with Formula Value - en masse

Re: Dynamik Choice field

Re: Sum the value of the result field from table1 when the value of deportment is "1"

Re: Sum the value of the result field from table1 when the value of deportment is "1"

Re: Synchronization not working

Re: Synchronization not working

Re: Field of type JSON

Re: FeatureRequest: Show FunctionDefinition in Editor

Overview