I using Saltcorn since a few month and it worked fine for me. As i want to use a view on my pgsql-database in saltcorn and i have some problems with this, i updated my saltcorn-Version from 1.0.0 to 1.4.0. After the update, some Relations where corrupted and i got errors like this:
 

Errors

Page SuK Abrechnung: In SuK_Abrechnung_Filter view (Filter viewtemplate):
Relation »public.SUKsUnterstütztePerson« existiert nicht

Page SuK_Abrechnung_gruppiert: In SUK_Abrechnung-gruppiert view (List viewtemplate):
Relation »public.SUKsUnterstützungstermin« existiert nicht

Page SUKS-Seite: In SUKSFilter view (Filter viewtemplate):
Relation »public.SUKsUnterstützungstermin« existiert nicht

The tables in the database still exists, but saltcorn could not see them anymore. Any chance to get them back to saltcorn?

Hello, Saltcorn developer!

I was surprised to find your resource, and it is very functional! Even better than some popular no-code platforms! But, unfortunately, I noticed that this platform is not being developed (or am I mistaken?)...

My first question is about code-free customization of the sidebar menu. Currently, it has a somewhat "fixed/standard" appearance - for example, I cannot change the color of the menu, I cannot make it "sticky" (so that the main menu container stays in one place and does not scroll asynchronously from the main page), move the sidebar collapse button up, freeze the menu logo header on top, etc.

How can I do this (apart from making global changes to HTML/CSS in the application's general settings)?

In conclusion, I can say that this is a very cool product with powerful "internal stuffing" (its functionality is so advanced that it is sufficient for creating fairly complex web systems for business). It lacks a little freedom in visual design. I would be happy to help within my capabilities (consulting as a user, testing capabilities).

Hi all,

I'm exploring options to connect Saltcorn to my data, since I have a postgres in place already. It is maintained and filled by other applications.

So I'm looking into two possibilities;

1. Connect to an external Postgres by using the following module. But I get this error message.
   
    
2. Making use of an existing database by adding this into docker-compose.yml.
   I have put this one into place and put some traefik secuirty measures on it; https://github.com/saltcorn/saltcorn/tree/master/deploy/examples/test.
   But I cannot run the script onto the existing database.

Here are the specs of my instance:

Maybe someone has anice trick up his sleeve to get going. Otherwise saltcorn is not very useful for me.

Thanks already!
Greets, Merijn

Any help on how to install Saltcorn on my Windows 11 laptop. I am actually strugging. I have  entered all the commands given on the officlal wiki but still not able to install locally

I am new to the whole Saltcorn Concept. I am struggling to install saltcorn locally on my laptop. Any help please

First of all, I want to congratulate you on the wonderful work you're doing. I'm not a programmer, and I'm having a lot of fun with Saltcorn. However, I have a small request. I don't install the beta versions, and every time I reload the main page, a popup appears telling me there's a new version. I find it annoying when you reload the page a hundred times a day. This option should be configurable or displayed once a day, for example. Thank you for considering it! ;-)

Danny

I want to create a button that when selected will filter a list based upon the current date (whatever day it happens to be when the button is clicked). I have a filter view created and embedded the associated list view.  I cannot seem to find the "magical" item to use for the formula. An Action button with the action set to run_sql_code seemed the best choice but cannot seem to get this to work due mostly to not fully understanding the inner workings of SC.  From a SQL view, the following formula -- select * from bidlist where biddate = current_date works fine so I used this in the SQL box for the action button but, comes back with an error "syntax error at or near biddate" There is a row parameters box near the bottom but I am not sure how to use this in case this has anything to do with it. I know there are specific requirements needing to be fulfilled in order to use formlas but the docs do not go into enough depth & cannot yet find anything else.  Help??

Saltcorn v3 stable installed in a Docker container on Ubuntu 24.04. I created a new database with fields to match the data being exported from an existing Postgres database with several hundred records. I exported the data to a CSV file using comma delimiters.  Upon executing the upload of the comma delimted CSV file into the database, Saltcorn reports "Imported 21 rows but rejected 311 rows". If I choose to have Saltcorn create the database from the uploaded CSV file, it all works fine except one numeric field is created as a text field.  Ideas??

Hi,

I have the same HTMLCode object in a ListView and in a Edit View, but in the Edit View I can not read fields. Instead, the same code in List View works fine.

This is the code. I try to retrieve the status name in his assigned color.

"<span style="color: {{ idstatus.statuscolor}}">{{ idstatus.name }}</span>"

Anyone knows how to access to fields and joinfields in a HTMLCode located in a EditView?

Thank you,

J.A.

Hi, 

Every time i select a viewlink , for example an edit of show view. The program just get stuck.

Is there a workaround for?

Cor 

Maybe some html code, of is it fixed in updates?

Iam currently running 

Cor 

Saltcorn looks really promising for my bookseller inventory app, but before the big push can I ask where the most vibrant/active builder/dev forum for Saltcorn is please?

Thanks

Nick

I want have the following issue:

There is a table with rows. In one culumn there´s a reference to the users table. Now I need to create a view that shows all records where logged-in-user = user in  linked-user-column. This isn´t a cosmetic issue, it´s a security question, because the content of the table is partially sensitive.

I found the "default search form values when first loaded" where I can achieve something like that. But it doesn´t seem like a secure way to do that

Hi.

Is there a possible way when i add al the tables, and make views ,  i can copy one view to another table?

I've designed one view i took me 4 hours to make a nice view , 

Now i got 40 more tables that needs the same view. 

that wil save weeks of work :) 

Tnx 

Cor 

I am trying to set up saltcorn with Authentik IDM using oauth2 authentication. I found somewhere that this IS the redirect URI:

https://sc.example.org/auth/callback/oauth2/

But Authentik says its incorrect. What IS the correct redirect URI?

Hi all,

Is it possible to create a List-view where each second row has a different fill-color? How can I do that? And is it possible to display a border around a field or text-box in de the list- and show-view?

Thanks for any help!

Regards,

Friso

Hello, I am very passionate about this product, I would like to create an interface to control my proxmox server(PVE). PVE exposes APIs that I would like to consume from saltcorn, but I didn't understand if there is a way to authenticate and use them to update view information. I tried with blocks to connect to the PVE APIs but I have no way to manage the required authentication tokens.

I would be really happy if someone would put me on the right path to deal with this problem. Thanks in advance.

Hi wise people! Please someone help me understand the "On Change Action" configuration point for the field, some field types have it, specificly my case is a Dropdown from linked table. 

But i couldn't make use of it, cos it only shows "None" as an option, no matter what triggers and actions i create within the view. 

Is there any clear documentation on this or some video or clue, please help

No soy experto y apenas tengo conocimientos informáticos. Sin causa aparente, he dejado de poder seguir construyendo una app. Escribo la direccion web -----.saltcorn.com , me muestra la interface (pagina de inicio), pero no logro entrar. 

Me he logeado https//------.saltcorn.com/ auth/login pero tampoco he podido. Alguen me puede ayudar? Gracias

I have an Edit View, let's call it "Maintenance-Edit" that I'm opening via a ViewLink from a ListView called "Equipment-List" to add new maintenance records for that piece of equipment. On the Maintenance-Edit form, i have an Embedded View of a List View called "Maintenance-List" that has all records from the maintenance table. I want to filter that List View to only show records for the same EquipmentID as the Piece of equipment I'm adding.

I've tried to do this via the "Extra state Formula" on the List View, but I can't figure out the forumula. 

I'd truly appreciate some help.

Hello!

My applaud to the developers of Saltcorn - it seems to be user friendy but yet versatile, just what I'm looking for. So I really would like to use it, but I've met one difficulty that totally halts me. I hope someone can help me with this:

I have watched several times on YouTube the "Saltcorn table relationships" tutorial but I'm not able to reproduce what they do there. My case is very simple. I have two tables: "Table1" which has as a main parameter "electronic-device" (a number), and then a "Table2" which has a main parameter "installation-site" (also a number). I then add a key in "Table2" pointing to "Table1.electronic-device", and I can manually add electronic-devices to the chosen installation-sites. (There must be a unique relationship so that an "electronic-device" can only appear in one "installation-site"). So far so good. But when I create a view for "Table1", I would like this view to show also as a Join Field the "installation-site", which should appear in the same list-row as the "electronic-device" as the latter was assigned to in "Table2", but I just can't make it work no matter how hard I try. I get no error-messages but the "installation-site" never shows up.

Is there a bug, or is there a trick to solve this? I'm using:

Saltcorn version    1.0.0-rc.5
Node.js version    v18.20.4
Database type    PostgreSQL 12.20

On Ubuntu Linux 20.04.6

Thanks in advance for somebodys answer.

- Einar