Vermaji

vermau81

Ninox Developer

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

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,…
- Ninox Developer
- vermau81
- 1 yr ago
- 3replies
- 62
- 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.…
- Ninox Developer
- vermau81
- 1 yr 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.…
- Ninox Developer
- vermau81
- 1 yr 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..…
- Ninox Developer
- vermau81
- 1 yr 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.…
- Ninox Developer
- vermau81
- 1 yr 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
- Ninox Developer
- vermau81
- 1 yr ago
- Learn and share
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Sotirios Zormpas Hello Sotirios, below is the snapshot of my code. Just two lines:.. This is just to give gray background color to the formula field for UI/UX to show that this field is not manually…
Attachment
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Fred I have done all this and banged my head against the wall many times. The moment I hard code a value in the first line ( let f := formatJSON(styled(text(90), "#F7F8FC"));…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Re: Extract color or icon from styled field/var
@Jacques TUR Thank you for the prompt reply. That thing worked in the console as advised by you. But my real code on the SaleOrder form is not working. let f := formatJSON('Order Charges'); let p :…
- Ninox Developer
- vermau81
- 1 yr ago
- Learn and share
- Reported - view
Re: Extract color or icon from styled field/var
@Jacques TUR Hello, I tried your above code in the console, but to my surprise, there is no result when I press the Run button. I have the macOS Ninox app.…
- Ninox Developer
- vermau81
- 1 yr ago
- Learn and share
- Reported - view
Re: Can't calculate the GST and Balance Pmt formula fields
@Fred Hello mate, Thanks for your solution. You caught it right. This is exactly what I was looking for. I implemented your solution exactly given by you in my app,…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Re: Styled number field maintaining it numerical?
@Cristóbal Hi, did you find a solution to this problem. I ran into same problem today. Styled() still does not support numeric parameters and once we convert them to text,…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Re: Change a field alignment in script
@Sean This is amazing Sean, thanks for the code. I wish Ninox adds the alignment parameter to either "styled()" function or provide an "align" property to the formula fields in the new version 3.…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Can't calculate the GST and Balance Pmt formula fields

Hello Friends@Fred@Mel Charles , I can't wrap my head around this problem. I have four formula fields on the form 1. OrderCharges, 2. OrderTotal, 3. GST, 4.…
- Ninox Developer
- vermau81
- updated 1 yr ago
- 17replies
- 83
- Get help
Re: Change a field alignment in script
@Fred No, I don't want to use the Style. I want to use the code to right align in a formula field. If there is no function to achieve this through the code then I will use the Style sheet of course…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Change a field alignment in script

@Fred@Mel Charles@Sean Hello friends, I can't figure this thing out. Is it possible to change the alignment of a formula field to right aligned inside a script without using HTML,…
- Ninox Developer
- vermau81
- 1 yr ago
- 4replies
- 67
- Get help
- Answered
- Answered
Re: Query regarding the sale price per item in Sale Order
@Mel Charles But with this setup won't we have to create duplicate fields (of OrderItems table) in the main SaleOrders table ?
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Re: How to maintain rates in old transactions
@John Halls I thought over it and I think I have a solution. 1. Reference field to show Item Name only 2. Formula fields to autofill the Rate. Formula fields are non editable.…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Re: How to maintain rates in old transactions
@John Halls I am not sure if I am correct or not, but I am only going to have a link for the Item name from the menu. For the price I will use a text field that will autofill by picking the price…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Re: How to maintain rates in old transactions
@John Halls Thank you for your reply. I was going to do the same but just confused that when I change the price in Menu say next year, and I open the SaleOrders table,…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
How to maintain rates in old transactions

@Sean@Fred@Sotirios Zormpas Hello friends, This query might sound very basic, but I have some doubts about it. I am starting to develop a small sale-order system for my own food business.…
- Ninox Developer
- vermau81
- 1 yr ago
- 7replies
- 64
- Get help
Re: Query regarding the sale price per item in Sale Order
The only way I can think of right now is that the rate from the Menu table will only be copied to the Rate field in OrderItems table if the it is empty.…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view
Query regarding the sale price per item in Sale Order

Hello friends, This query might sound very basic, but I have some doubts about it. I am starting to develop a small sale-order system for my own food business.…
- Ninox Developer
- vermau81
- 1 yr ago
- 8replies
- 60
- Get help
- Answered
- Answered
Re: Conditional formatting
@Jacques TUR This one definitely works on text fields. Thanks to @Sean for bringing this to light for me. My business owner was asking me to highlight all the active clients in GREEN colour in the…
- Ninox Developer
- vermau81
- 1 yr ago
- Learn and share
- Reported - view
Re: Print and Delete buttons are not active
@Mel Charles Oh I am too novice for reporting yet. I am still learning everyday and adding on to this project as I learn. Was just thinking of a quick solution to fix this up for the owner and then…
- Ninox Developer
- vermau81
- 1 yr ago
- Get help
- Reported - view

1 2 3 4 5 6 7

Welcome to the Ninox community

Vermaji

My Posts

Query regarding View Element

Re: Extract color or icon from styled field/var

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Extract color or icon from styled field/var

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Extract color or icon from styled field/var

Re: Extract color or icon from styled field/var

Re: Can't calculate the GST and Balance Pmt formula fields

Re: Styled number field maintaining it numerical?

Re: Change a field alignment in script

Can't calculate the GST and Balance Pmt formula fields

Re: Change a field alignment in script

Change a field alignment in script

Re: Query regarding the sale price per item in Sale Order

Re: How to maintain rates in old transactions

Re: How to maintain rates in old transactions

Re: How to maintain rates in old transactions

How to maintain rates in old transactions

Re: Query regarding the sale price per item in Sale Order

Query regarding the sale price per item in Sale Order

Re: Conditional formatting

Re: Print and Delete buttons are not active

Overview