Monday 4 November 2024

nuBuilder's backup and global string replace.

 

Using a backup to globally change every instance of a field name.

In its table structure, Objects in Forms and code (JS, PHP, SQL, CSS and even custom HTML.)



Wednesday 30 October 2024

Creating a simple invoice Form

This video shows how you can make a simple invoice Form in nuBuilder 4.5 

and a link to the SQL that will recreate it. Simple Invoice




Sunday 27 October 2024

AI and nuBuilder

 I found this interesting the other day while playing with a new editor called Cursor

I asked the AI (Copilot) to write some code that returned the number of rows in a Subform.

Its first attempt used a function that wasn't correct, so I told the AI and this is what it said...




Saturday 20 May 2023

Using the Calc Object in nuBuilder Forte

The Calc Object

The Calc Object in nuBuilder makes a nuBuilder Form work a little like a spreadsheet by creating Objects that are automatically updated anytime certain other Objects are edited or updated.

In some cases the Calc Object is updated from other Calc Objects.

In cases like this, you will need to make sure they are being calculated in the correct order.

Otherwise, you can get into a situation like this...


There are 4 Calc Objects on this invoice Form and this is what they calculate...

Unit TotalnuTotal('iit_units') * nuTotal('iit_unit_price')             eg. Units * Unit Price

Total: nuTotal('item_sf.iit_unit_total')                                         eg. Sum of all Unit Total

Tax: nuTotal('inv_total') *  ( nuTotal('inv_tax_percent') * .01 )    eg. Total * Tax %

Grand Total: nuTotal('inv_total') + nuTotal('inv_tax_total')        eg. Total + Tax

In the example above Grand Total is calculated before Total Units, Total and Tax, which isn't correct.

To make Grand Total calculate correctly it must be calculated last and to reorder this we need to select Arrange Objects from the Form's menu () and move Grand Total down below Tax Total.


Then all the Calc Objects will calculate properly...


Reordering any Objects will also reorder the tabbing order of those Objects on the Form.





Thursday 11 May 2023

nuBuilder Forte backed up for 1000 years

nuBuilder Forte is part of Git's Archive Programs project.

"What is that?" I hear you say.

Git describes it as this...

The GitHub Arctic Code Vault is a data repository preserved in the Arctic World Archive (AWA), a very-long-term archival facility 250 meters deep in the permafrost of an Arctic mountain.

"How do I know nuBuilder is backed up here?" I hear you say again.

Here's nuBuilder Forte's badge at https://github.com/smalos ...



Friday 5 May 2023

GPT-4, AI and nuBuilder

GPT-4 has recently been released, which is Artificial Intelligence software that can answer an amazing array of questions using ChatGPT Plus.

For example...


Or you could ask this...


It can also write code...


And it knows a bit about nuBuilder too but it can sometimes just lie.


GPT can be very helpful but be careful and don't always trust it. Remember this...