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

I followes the procedure in shown at https://wiki.saltcorn.com/view/ShowPage/install-on-windows-10

When I try to run command "saltcorn setup" I get the following error:

===================================================

node:internal/modules/cjs/loader:1228
  throw err;
  ^

Error: Cannot find module 'C:\Users\aarce\AppData\Roaming\npm\node_modules\@saltcorn\cli\bin\saltcorn'
    at Module._resolveFilename (node:internal/modules/cjs/loader:1225:15)
    at Module._load (node:internal/modules/cjs/loader:1051:27)
    at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:174:12)
    at node:internal/main/run_main_module:28:49 {
  code: 'MODULE_NOT_FOUND',
  requireStack: []
}

Node.js v20.17.0

==============================================

What is wrong?

Trying to buld a view or dashboard is realy frustrating.

Any formula I'm trying is too complicated to the system.

there is a way to filter rows according to date field of specific format, to rows that belong only to current or last month?

I have just begun experimenting wtih Saltcorn.

I have created some tables with fields but have not added any data (rows).

Is it possible to delete a field from a table?

The wiki indicates you can but I have not found a way to do that within Saltcorn

https://wiki.saltcorn.com/view/ShowPage/edit-a-table

The only way I could find was to manually delete the field and associated json external to saltcorn.

Thanks,

wittrock

Hello.

I started creating a system on Saltcorn platform, and the documentation is very basic.

Now i'm struggling to collect input and do something with it by JS small function, but it seams like I'm missing something fundmental on how that run_js_code works.

I can't figure out how can I query the html elements, since the object 'document' is not accessible that way.

dsadsadsa

I am trying to install on debian.

I am getting the error:

npm error code ENOENT
npm error syscall lstat
npm error path /home/saltcorn
npm error errno -2
npm error enoent ENOENT: no such file or directory, lstat '/home/saltcorn'
npm error enoent This is related to npm not being able to find a file.
npm error enoent

npm error A complete log of this run can be found in: /home/graytill/.npm/_logs/2024-07-01T11_18_15_585Z-debug-0.log

When I first ran the installer, I chose not to create a user for saltbush.

I suspect this may be the problem, but now I can't get it to create a user.

How do I do a fresh install?

Thanks