Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Vermaji

vermau81

Database App Developer

120
12
0

Joined: Mon Jul 01 13:39:27 UTC 2024

I am a database app developer enthusiast. I am new to Ninox and quiet impressed with its simplicity and low code platform.

My Posts

Latest Posts

Re: Populate text field based on selected option from a DCF
@Fred Thank you Fred. It worked like a charm.
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Populate text field based on selected option from a DCF

Hello @Fred@Sean I am trying to populate the email field based on the selected contact person option from the Dynamic Choice Field on the Sale Order form.…
- Database App Developer
- vermau81
- 4 mths ago
- 2replies
- 43
- Get help
- Answered
- Answered
Re: Data in the OrderItems table changes on its own
@Fred There is definitely something wrong with the code in the latest version 3.13.1 that it treats the archives differently when uploaded to iCloud or local machine and Ninox cloud.…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Fred Or we can just use SELECT queries combined with WHERE clause to fill the dynamic field. This way no matter how many times the data gets scrambled 'cuz of defragmentation,…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Fred Two things Fred: 1. Data glitch only happens when the archive is imported and uploaded to either the local hard drive or personal iCloud account. When the archive is uploaded to Ninox cloud,…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Alain Fontaine That is exactly my point. This is not a small bug that people can live with for some time. This is data breach. Thank God that there were only a few entries in the Sale Order as the…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Fred 'Item Name' is a Dynamic Choice field which shows the Product Items based on the Product that is chosen in the Product field (which is a reference field).…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Data in the OrderItems table changes on its own

Hello, I just noticed a weird think happening to my database. Today I was working on the CRM database in the office where I work in the cloud version (since they have windows OS).…
- Database App Developer
- vermau81
- 4 mths ago
- 13replies
- 92
- Get help
Field of type JSON

Hello Friends, As I make a database app for my own food business, I am in the process of designing the menu table. The menu items come in varied units like (piece, container, plate, meal etc.).…
- Database App Developer
- vermau81
- 4 mths ago
- 3replies
- 102
- Get help
Table architecture with a 3 levels or deeper hierarchy

Hello friends, By any chance is it possible to have a Table architecture with a 3 levels or deeper hierarchy in Ninox? Below is the current structure of my database and desitred structure (if…
- Database App Developer
- vermau81
- 4 mths ago
- 2replies
- 77
- Get help
Re: Ninox 3.13 available
@Mel Charles I am working on the macOS app. I am still in the old version (3.12.8). I guess that they haven't updated the macOS app yet. This is happening with me as well.…
- Database App Developer
- vermau81
- 4 mths ago
- Learn and Share
- Reported - view
Re: Ninox 3.13 available
@John Halls @Fred I love you guys and love this community. Saved me from a big headache. This CRM I am developing is for my workplace. Although I am doing it all for free for the owner,…
- Database App Developer
- vermau81
- 4 mths ago
- 1
- Learn and Share
- Reported - view
Re: Ninox 3.13 available
For me, I can’t delink the reference value from the field. There is no delink button. The sales guy had a product item assigned to a wrong product category by mistake and I created a sale order using…
- Database App Developer
- vermau81
- 4 mths ago
- Learn and Share
- Reported - view
Re: Add/Insert record on button click
Awesome, I could not remember that just like even though Customer is a reference field in the Orders or AccountReceivables form, we still have to select the customer from the Customers table,…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Add/Insert record on button click
@Fred please excuse my little knowledge considering I am still a starter in Ninox. customers is linked to both AccountReceivables and Orders tables separately,…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Add/Insert record on button click
@Fred Thank you mate. It worked like charm. Just one little problem and one clarification. Clarification: What does this signify here? does it refer to the whole table in context or the current…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Add/Insert record on button click

@Fred Hello, I am trying to create a new record on button click, however it is not able to find the specified column in the target table. Am I missing something?…
- Database App Developer
- vermau81
- 4 mths ago
- 6replies
- 92
- Get help
- Answered
- Answered
Re: Query regarding View Element
@John Halls Hello John, thank you for your input and advise. My idea is similar to yours except for the fact that in my case there is no need to generate as invoice and give to the customer as mine…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Query regarding View Element
I think I have a solution to this problem. I will create a Record Payment button on the Order form and write the code in the click event of that button.
- Database App Developer
- vermau81
- 4 mths ago
- 1
- Get help
- Reported - view
Query regarding View Element

@Fred Hello, I was going through your post " https://forum.ninox.com/t/g9hbyt2/pass-current-viewing-record-id-to-a-view-element-column-formula " as my query is also almost the same,…
- Database App Developer
- vermau81
- 4 mths ago
- 3replies
- 42
- Get help
- Answered
- Answered
Re: Extract color or icon from styled field/var
Hello everyone, first of all thank you everyone for all your help and support in this query. This was not a very big matter if Ninox could provide the right way to do the right thing.…
- Database App Developer
- vermau81
- 4 mths ago
- Learn and Share
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Fred I actually implemented the above solution in the end. My only worry is that we have to calculate the allLineItemCharges and orderTotal at least 4 times on the same form.…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Sotirios Zormpas @Fred Thanks to both of you for helping me resolve this problem. After Fred's advise I wrote the below code to resolve the problem..…
- Database App Developer
- vermau81
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Sotirios Zormpas But the $ sign denotes that this is a currency field. It is customary to have $ sign in any currency field to differentiate it from any other numeric field that is not currency.…
- Database App Developer
- vermau81
- 4 mths ago
- Get help
- Reported - view
Re: Extract color or icon from styled field/var
@Jacques TUR It is a formula field. Script in the field is just two lines let allLineItemCharges := sum(OrderItems.Subtotal); styled(text(allLineItemCharges),…
Attachment
- Database App Developer
- vermau81
- 4 mths ago
- Learn and Share
- Reported - view

1 2 3 4 5

Back to top

Overview

View all topics