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

Using the automated install on ubuntu gives the error

npm ERR! code ENOENT
npm ERR! syscall lstat
npm ERR! path /home/USER/.local/lib
npm ERR! errno -2
npm ERR! enoent ENOENT: no such file or directory, lstat '/home/hex/.local/lib'
npm ERR! enoent This is related to npm not being able to find a file.
npm ERR! enoent

Creating this file gives the error

npm ERR! code EEXIST
npm ERR! syscall mkdir
npm ERR! path /home/USER/.local/lib
npm ERR! errno -17
npm ERR! EEXIST: file already exists, mkdir '/home/hex/.local/lib'
npm ERR! File exists: /home/USER/.local/lib
npm ERR! Remove the existing file and try again, or run npm
npm ERR! with --force to overwrite files recklessly.

npm ERR! A complete log of this run can be found in:

Running with --force doesn't seem to help.

Hello,

I'm trying to make a proof of concept, and one of my tables have a Date field (with a day_only attribute). However, if I try to input a date in an edit view (with a normal "edit" field view or with flatpickr), I get a "time zone not recognized" error. Does anyone have an idea of what's wrong? For context, I installed Saltcorn on WSL (Ubuntu).

Thanks in advance!

I've just spent the last few months building a prototype integrations dashboard for my organization.  The only user was myself, and I've been getting ready to demo the site.

So today I added a new non-privileged user, and changed the role on pages/tables to the a role called "staff" I created for this purpose.  I also clicked on "Enable 2FA" on my main admin account but didn't follow through because my authenticator app said it would overwrite settings.

Now BOTH my accounts are non-admin and I'm locked out of doing anything except viewing.  What can I do??  Please help!!!

LATEST:  I thought I had my access back after setting up 2FA, but all it did was restore the admin menus, then deny me access to everything.  Argh!

I’m trying to evaluate whether Saltcorn will meet my needs for an upcoming project. Four times a year, I need to be able to create customized PDF documents for a set clients that include information from various tables. The created PDF files need to be stored in the filesystem of the server, where they can be accessed outside of the Saltcorn application. Additionally, I would like to store these PDF documents within a Saltcorn table, so that they might be displayed within the Saltcorn application.

I think I can use a view template to build the desired layout. What I want to know is if there is a way to trigger the creation of all the PDF files with a single action. Something like: “Click this button to prepare all quarterly reports”.

As I’ve read through the documentation, I think I can figure out how to do this one document at a time, but I need to do them as a bulk action. Is this something Saltcorn can do? If so, I’ll dig deeper into it and start trying to put something together.

Thanks for any information or hints you might have!