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.)
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.)
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
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...
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 Total: nuTotal('iit_units') * nuTotal('iit_unit_price') eg. Units * Unit PriceIn 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.
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 ...
GPT-4 has recently been released, which is Artificial Intelligence software that can answer an amazing array of questions using ChatGPT Plus.
For example...