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

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.…
- Ninox Developer
- vermau81
- 1 yr 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,…
- Ninox Developer
- vermau81
- 1 yr 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…
- Ninox Developer
- vermau81
- 1 yr 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,…
- Ninox Developer
- vermau81
- 1 yr 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,…
- Ninox Developer
- vermau81
- 1 yr 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…
- Ninox Developer
- vermau81
- 1 yr 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?…
- Ninox Developer
- vermau81
- 1 yr ago
- 6replies
- 137
- 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…
- Ninox Developer
- vermau81
- 1 yr 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.
- Ninox Developer
- vermau81
- 1 yr 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,…
- Ninox Developer
- vermau81
- 1 yr ago
- 3replies
- 65
- 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
- 86
- 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
- 69
- Get help
- Answered
- Answered

1 2 3 4 5 6 7

Welcome to the Ninox community

Vermaji

My Posts

Re: Ninox 3.13 available

Re: Ninox 3.13 available

Re: Ninox 3.13 available

Re: Add/Insert record on button click

Re: Add/Insert record on button click

Re: Add/Insert record on button click

Add/Insert record on button click

Re: Query regarding View Element

Re: Query regarding View Element

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

Overview