Vermaji

vermau81

Database App Developer

Joined: 01 Jul 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: Best practice to duplicate a record
@Fred I removed "Do as server" and 1. Its pretty fast now 2. I didn't know there was an inbuilt duplicate() function, so I don't have to write my custom code 3.…
- Database App Developer
- vermau81
- 2 hrs ago
- Get help
- Reported - view
Re: Best practice to duplicate a record
I am using the Ninox cloud and the macOS app. 1. When I scope newItem variable outside "Do as server", an empty record gets created and still no popup. var itm := null; var newItem :…
- Database App Developer
- vermau81
- 2 hrs ago
- Get help
- Reported - view
Best practice to duplicate a record

Hello friends, I am using the Ninox macOS client (now that it has been updated to 3.13.3) I have created a "Duplicate Product Item" button to create a duplicate record of any product item in order to…
- Database App Developer
- vermau81
- 11 hrs ago
- 7replies
- 24
- Get help
Re: Floating windows in Ninox
@Sotirios Zormpas Thank you mate. Appreciate your help !
- Database App Developer
- vermau81
- 11 hrs ago
- Get help
- Reported - view
Re: Auto-increment?
@jurgenpeter This is how I do it. I have this script in the "On Create" of the tables wherever I need it. It generates unique alphanumeric series. "Script to auto generate a new SO Number on creation…
- Database App Developer
- vermau81
- 2 days ago
- Get help
- Reported - view
Re: Floating windows in Ninox
@Sotirios Zormpas Thank you.. If I want to go by point No. 2, what is the starting point? How and where do I write the HTML and Javascript code? Can you please give me a small example?
- Database App Developer
- vermau81
- 6 days ago
- Get help
- Reported - view
Floating windows in Ninox

Is it possible to create floating windows in Ninox for taking some input? I have customers making pmt for their invoices in parts sometimes. So I want that whenever a part arrives,…
- Database App Developer
- vermau81
- 6 days ago
- 5replies
- 78
- Get help
Re: Trigger After Update does not get Triggered
@John Halls OH!!! I was sooo much distracted by the DCF that I did not think through clearly. Thank you John. However I learnt this today that the 'Trigger After Update' on DCF does not get executed…
- Database App Developer
- vermau81
- 7 days ago
- Get help
- Reported - view
Re: Trigger After Update does not get Triggered
@Fred Thanks for the reply mate. So what is the solution in this case then? How do I: 1. Make 'Contact Person' automatically go null as soon as the 'Business Name' is set to null 2.…
- Database App Developer
- vermau81
- 7 days ago
- Get help
- Reported - view
Trigger After Update does not get Triggered

, Hi@fred @sean I am facing a very weird issue. I have some code written in the "Trigger After Update" event of a DCF (Dynamic Choice Field). When I physically choose "empty" from the list in DCF,…
- Database App Developer
- vermau81
- 7 days ago
- 8replies
- 33
- Get help
Re: How to track the selected item in a DCF
I realised my mistake in the code above. It has to be as below: let rec := this; let itemName := ""; for i in rec.'Order Items' do itemName := text(i.'Item Name');…
- Database App Developer
- vermau81
- 9 days ago
- Get help
- Reported - view
Re: How to track the selected item in a DCF
@Sotirios Zormpas Oh, thank you man. I didn't know that something like this exist. I learn something new everyday in Ninox. But writing that code made a few things clear in my head.…
- Database App Developer
- vermau81
- 9 days ago
- Get help
- Reported - view
Re: How to track the selected item in a DCF
@Sotirios Zormpas No no here in this code I am trying to run script for already existing 200 records. For the future there will be no button. The code is there already in the After Update Trigger for…
- Database App Developer
- vermau81
- 9 days ago
- 1
- Get help
- Reported - view
Re: How to track the selected item in a DCF
@Fred I guess I resolved the problem. I wrote the code in a bit different manner and it gave me the desired result (Copy the name of Product Item from the 'Item Name' DCF into the 'Product Name' text…
- Database App Developer
- vermau81
- 9 days ago
- Get help
- Reported - view
How to track the selected item in a DCF

@Fred @Sean I was following the below post, but I think it got too long and complicated for me to understand.…
- Database App Developer
- vermau81
- 9 days ago
- 8replies
- 49
- Get help
- Answered
- Answered
Re: Selecting Product Items based on Product
@Alain Fontaine I checked the sample DB and actually liked the way you have stored the value of selected Product Item ( 'Item Name' ) in the reference field.…
- Database App Developer
- vermau81
- 11 days ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Fred@Alain Fontaine I used the SELECT statement in the DCF to filter 'Product Items' and I think it went pretty well. Now the DCF shows all relevant filtered 'Product Items' based on the chosen…
- Database App Developer
- vermau81
- 11 days ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Alain Fontaine So what you are suggesting is that we store the ID of every record in a PrimaryKey field on the creation of a new record so that we can use it later.…
- Database App Developer
- vermau81
- 11 days ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@John Halls Thank you John. The formula element thing worked like charm. I completely missed the formula element. Also on the side I was always of the opinion that if we use a formula field in any…
- Database App Developer
- vermau81
- 12 days ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Fred You remember I told you that the support has strictly told me that we should not use DCF in a situation where there is a possibility of deleting records in the future 'cuz the records gets…
- Database App Developer
- vermau81
- 12 days ago
- Get help
- Reported - view
Selecting Product Items based on Product

Hello@Fred I have a Reference field where I select the main Product from Products table. Product Items is a child table of Products. I have added a button (Update Records) and a new column (Product…
- Database App Developer
- vermau81
- 12 days ago
- 13replies
- 66
- Get help
Re: Populate text field based on selected option from a DCF
@Fred Thank you Fred. It worked like a charm.
- Database App Developer
- vermau81
- 13 days 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
- 2 wk ago
- 2replies
- 36
- 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
- 2 wk 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
- 2 wk ago
- Get help
- Reported - view

1 2 3 4 5