Using Grok to populate a table of translations

I wanted to get the translated days of the week in a table.

So I created a text file (days.csv)

Then I went to grok.com and I uploaded days.csv and asked grok this...

"Help me Can you fill out this csv (comma separated value) table with the weekday names for each row's language (found in the first colunm)"

And this is what I got...

Amazing!

A simple CRM in nuBuilder

Using

dbdiagrams.com

Creating field validation using chatGPT and regex.

Using Hash Cookies to filter a Browse Form.

Part 1

Part 2

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.)

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

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...

If you're new to nuBuilder here's something worth watching!

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 Total: nuTotal('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.