The Error

net::ERR_CERT_AUTHORITY_INVALID at https://my.server.local/files/serve/2afbfeda-35f6-49ec-9f4f-c806829cac17.html

i think its from the cromium-browser on the server, saltcorn use it internal.

http:// works for the Plugin

no plan for add the Cert in the this internal Cromium.

Hello, how actually insert_joined_row action works?

Im trying to insert joined row from A to B, but getting 'Cannot access 'joinTable' before initialization' error message.

Here's my field to join :

A table with reg_number field (string, unique, required), its unique generated by fill_formula_button at view.

B table with reg_number field key to A.reg_number.

at configuration it has relation A.reg_number but getting that error message.

Hi,

i am the new in saltcorn ;-)

i have install and setup saltcorn 

Saltcorn Version    0.8.4
Node.js Version    v14.21.1
Datenbanktyp    PostgreSQL

like: https://wiki.saltcorn.com/view/ShowPage/install-on-ubuntu

but is opensuse 15.4  (i work over 20 years only suse)

it run and i have 3 /tenant/create

it runs on the delault port 3000 ,  all good.

i work on acivate ssl. i have create a cert 

and copy the content in the Fields at SSL selfsingn (cert and key). it schow activate.  Restart the server but nothing.

port 3000 always uncrypted  and no other port open.  can i see anny log for errors?

hi everyone 

how can i hide messages from other users and only show those who are owners to see them?

Is there some formula for Aggregation Join, in Listview or i must use Aggregation Type.

I need this for makeing sum of two aggregations.

I dont see units and decimal places in tables and views whe i add it

Hi there. 

I trying a proof of concept for a DB which would havr some similar features to a music app, or shopping app (it isn't either, but these make a good metaphor) I am attempting to build out a "shopping cart" or "playlist" where users can filter an exisiting table, and then "pick" items from the table to be added into a personalized playlist or shopping cart type table (the user would see a show view of that table when they view it). 

So for instance, we might have a joined table with song info (title, artist, year, label, album, genre etc.) and a page with a filter and list view of that joined table (I can do this part). But then I'd like a button to "add" songs to a new "playlist" which populates as the "songs" are picked by a user. The user could then view their "playlist" (or shopping cart) on seperate page (or in an accompanying view) and interact with it (add or delete, make notes, export as pdf etc.). It would be great if they could have multiple different "playlists" viewable only to them, (or possibly shareable with other users).

Would this be possible? Is there a tutorial or explanation on how to do this?

Thanks for your help!

Hi Everyone!

Absolutely loving Saltcorn!  I have been playing with it for a few weeks and I am very impressed.

I have enabled periodic snaphots, however, snapshots do not get created unless I manually hit the button to create them.  Is this the expected behavior?
I am running 0.8.3-beta.1, but I don't think they worked in the previous version either.  Anyone else notice this?  Am I missing an OS package that I might need I wonder?

Thanks!

-Mark

I created a table which shows certain data in a view, placed it on a "page" to add an add button and clicking it shows me another view created to add the data I want to add another row to the table, but setting the view to add a link to another view to edit the data of a row that shows me the same view of adding a row does'nt show me anything.

But if I uninstall the "flatpickr-date" module or stop using it in the date data I have to modify it already shows me the view from the link to another view.

From the Saltcorn.com page I log in as administrator, but it doesn't allow me to make any changes to both my own user and the project itself. I tried installing it directly to the system and trying to access from the localhost does't allow me to even log in as administrator.

First, I would like to thank you for a very useful tool, I hope it will develop very dynamically.
I'm having trouble designing a tree view, is this possible ?

i have tabe Flights, Shipments, Package

          Flights (with information)

                          |

   Shipment1                 Shipment2

Pak1 Pak2 Pak3       Pak1 Pak2 Pak2

all will be wit relations

example - https://exontrol.com/extree.jsp?config=/js#groupby

Hello,

When I'm trying to run saltcorn via a docker container, I'm getting the following error on the console when trying to add the first time admin user:
invalid csrf token

Has anyone seen this before or have any ideas on how to solve it?

test

Can we add otp verification for a form field mobile number developed using saltcorn ?

Hy, I'm developing my first application with Saltcorn to get to know the tool and I'm really enjoying it. I am currently encountering my first difficulty.

In my application, when I add an item to the database, it automatically generates a field like: [email protected], so that I can generate a temporary email for each user who registers in the system. For this, I used the String option in the temp-mail field and the "Calculated" option, but I have no idea how I can do it in the Formula to generate this.

I googled for Genarete Hash Saltcorn and found a method for generating passwords, but it didn't work: generate_password()+"@multiti.com.br"

Would anyone have an idea how to go about this? As a last resort, I thought of uploading a table with thousands of random emails generated via shell in Linux and ordering it to get it from the bank, but I found this option to be a great kludge.

Thanks in advance for the help.

It seems, currently the Integer field cannot take BigInt values (e.g. 9898989898).

I would like to be able to have a field capable of these values, as, among other use-cases, one important use-case is to save a user's mobile number.

Where i'm from, mobile numbers are 10 digit numbers, hence the requirement for BigInt.

Hi, I'm new to Saltcorn and am trying to connect a custom domain to my web app. I read through the wiki, but I still can't find my Saltcorn server's IP address. Where is this information?

Thanks!

Hi,

I want to filter date-column in order to view row after today.

With sql, I have the function now() wich return the current date.

How do I fill the "Row inclusion formula" field in order to get the date ?

is it possible to manipulate date in "row inclusion formula" ?

and how to get row between date range ?

Thanks !

First off, thanks for all your efforts on this project.  I have been evaluating several platforms for a project I am working on and Saltcorn is by far my favorite so far.  One thing that I am struggling with is summing data across tables.  For example, lets say that I have three tables.  The first table contains employee information with a key field being the the employee number.  Another table is a list of project which has a key field of project number.  The third table is a table that contains time spent on projects.  It contains three fields - the time spent, the employee number and the project number.  What I would like to be able to do is create views that summarize in a list the projects and total accumulated time as well as another view with a list of employees and accumlated time.  Is this possible and if so, could you share some instructions?

thanks!

Hi Saltcorn fans - hoping there a way to have the column names when in table data edit mode display the complete column name and offer a horizontal scroll bar instead of trying to squeeze  all columns onto a single layout... https://snipboard.io/szUTBK.jpg

I find that my tables can easily contain dozens of columns, so I can't imagine what this will look like if I have 2 or 3 times the amount of columns - thanks