Vermaji

vermau81

Database App 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

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
- Database App Developer
- vermau81
- 4 mths 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"));…
- Database App Developer
- vermau81
- 4 mths 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 :…
- Database App Developer
- vermau81
- 4 mths 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.…
- Database App Developer
- vermau81
- 4 mths 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,…
- Database App Developer
- vermau81
- 4 mths 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,…
- Database App Developer
- vermau81
- 5 mths 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.…
- Database App Developer
- vermau81
- 5 mths 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.…
- Database App Developer
- vermau81
- updated 5 mths ago
- 17replies
- 76
- 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…
- Database App Developer
- vermau81
- 5 mths 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,…
- Database App Developer
- vermau81
- 5 mths ago
- 4replies
- 48
- 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 ?
- Database App Developer
- vermau81
- 5 mths 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.…
- Database App Developer
- vermau81
- 5 mths 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…
- Database App Developer
- vermau81
- 5 mths 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,…
- Database App Developer
- vermau81
- 5 mths 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.…
- Database App Developer
- vermau81
- 5 mths ago
- 7replies
- 52
- 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.…
- Database App Developer
- vermau81
- 5 mths 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.…
- Database App Developer
- vermau81
- 5 mths ago
- 8replies
- 52
- 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…
- Database App Developer
- vermau81
- 5 mths 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…
- Database App Developer
- vermau81
- 5 mths ago
- Get help
- Reported - view
Re: Print and Delete buttons are not active
@John Halls That’s a good idea. Set the status to archive and then filter the records acc to the status. But the business owner still wants to print.
- Database App Developer
- vermau81
- 5 mths ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
@Sean It worked like a charm. Thank you @Sean and @Fred for all your guidance and support. It's 'cuz of a community of helpful and knowledgeable people like you that newbies like me get to learn a…
- Database App Developer
- vermau81
- 5 mths ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
@Sean Thank you Mate. I am definitely going to try it once I reach home. just curious, where are all these things documented about Ninox?
- Database App Developer
- vermau81
- 5 mths ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
@Fred Thank you for your quick response and help as always. @Sean has advised a solution and I am going to try out when I reach home. I understand what you mean and I am up for that.…
- Database App Developer
- vermau81
- 5 mths ago
- Get help
- Reported - view
Re: Print and Delete buttons are not active
@Fred looks like we can’t do anything in Ninox, but we can do everything else that is apart from “Anything”
- Database App Developer
- vermau81
- 5 mths ago
- Get help
- Reported - view
Re: Change a field's background color: is this possible?
@Fred That’s true. Theee are such basic UX things that should be there. Now see my business owner has this specific requirement that’s very basic and I can’t fulfil it for him.…
- Database App Developer
- vermau81
- 5 mths ago
- Get help
- Reported - view

1 2 3 4 5

Welcome to the Ninox community

Vermaji

My Posts

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

Re: Print and Delete buttons are not active

Re: Change a field's background color: is this possible?

Re: Change a field's background color: is this possible?

Re: Change a field's background color: is this possible?

Re: Print and Delete buttons are not active

Re: Change a field's background color: is this possible?

Overview