JOIN/UNION and Column Auto numbering ( not UUID)

GRIST is a wonderful product, that could be made even more wonderful if you could please add a couple of power features.

  1. The ability to create a table based on a query of multiple other tables ( like a VIEW)

  2. The ability to join/union tables based on a common criteria

  3. A simple function that enables auto numbering ( or incrementation of cells) in a column based on the last number + some formula and also auto sequences.

Many thanks

Keep up the good work

2 Likes

For the 3, you should be able to refer to the precedent record within a trigger formula. For example, this trigger formula gives letters in alphabetical order (replace “A” by the name of your column):

id = table.all.id[-2]
chr(ord(table.lookupOne(id=id).A) + 1)