Started project for Admin, creating lookups, moving tables around, etc.

Skip to first unread message

Drazen D. Babic

Nov 27, 2020, 1:03:21 AM11/27/20
to Users Mailing List
Hi everyone,

since Black Friday, I wanted to add a project I've started.

The App enables to quickly select all Internal Users and change their Role or Admin rights.

It also enables to quickly modify lookup lists, and most importantly, moving the tables from one Group to another (still work in progress).

It works only for v6. It can be modified for v5.


Screenshot from 2020-11-27 13-27-05.png

Roles, priviledges:
Screenshot from 2020-11-27 13-26-47.png

Let's say there is a new Test Group with id 39:

Screenshot from 2020-11-27 13-31-49.png

And want to move some tables to Test group #39:

Screenshot from 2020-11-27 13-32-29.png


Screenshot from 2020-11-27 13-32-48.png

To move it back, set PARENT to #2, and restart App. 

To use this App, Import and set database to admin.sqlite in some project, not the just imported one (have a backup first!).

It can be extended to many things, like creating common fields, etc.
Btw, not supported by the Dev. 


Drazen D. Babic

Jan 15, 2021, 12:51:49 AM1/15/21
to Users Mailing List

this App is now supporting changing the Table Names and the Table Field Names.
Which means no need to click on many places and one can actually search through the complete App for some field name and find the Table with that name.

Screenshot from 2021-01-15 13-24-24.png

Here I've changed the Artist field name to Artist!!! and Dashboard!!!  and bounced the Demo App (it would be great to know how the App knows when something is changed, which admin.sqlite filed is it using for this, so we just refresh the App :) Andrew?

The Form in green is copy/paste screenshot with the actual App.

You'll notice Sys_fields added to it.

BTW, Andrew will not support this approach, but I've found it very useful for quick changes!


To put this into some perspective, this is the Items count for my App :)

Screenshot from 2021-01-15 13-47-27.png

So the next part we are working on (Andrew mostly), is the F_Name translation table and translations Import. Stay tuned...
PM me if needing the App.


Александр Рюмин

Jan 15, 2021, 7:32:42 AM1/15/21
to Users Mailing List
Hi, Drazen!
I've wanted to dig into system tables for a long time. Where can I see this App? 

Aleksandr Riumin
пятница, 15 января 2021 г. в 10:51:49 UTC+5, Drazen D. Babic:

Dražen Babić

Jan 15, 2021, 10:40:39 PM1/15/21
to Александр Рюмин, Users Mailing List

Sent u the link.


You received this message because you are subscribed to a topic in the Google Groups " Users Mailing List" group.
To unsubscribe from this topic, visit
To unsubscribe from this group and all its topics, send an email to
To view this discussion on the web visit

Александр Рюмин

Jan 16, 2021, 4:05:18 PM1/16/21
to Users Mailing List
Thanks a lot, I got the file. 
I will definitely write my opinion.

суббота, 16 января 2021 г. в 08:40:39 UTC+5, Drazen D. Babic:

Dražen Babić

Feb 6, 2021, 4:26:37 AM2/6/21
to Users Mailing List
Just to clarify, this is a portable App if remember well:

So just unzip and run. Open Builder and set the DB to full path of some project admin.sqlite file.

Reply all
Reply to author
0 new messages