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!

Hello. I'm a newbie to Saltcorn, and I'm testing the solution for some of my projects.
I would like to know, how to create an action button like the one on the image below for one of my tables.

Can anyone point me a direction?

Thanks in advance.

Hi there,

I'm a new Saltcorn user. After the installation, there was a message on the main screen asking to update the software, and I did it. But the message is still there after upgrading to 0.9.5-beta.19.

How can I remove this message?

See the logs below.

Starting upgrade, please wait...
npm WARN deprecated @types/[email protected]: This is a stub types definition. minipass provides its own type definitions, so you do not need this installed.
npm WARN deprecated @npmcli/[email protected]: This functionality has been moved to @npmcli/fs
npm WARN deprecated [email protected]: This module is not used anymore, and has been replaced by @npmcli/package-json
npm WARN deprecated [email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated [email protected]: Please use another csrf package
npm WARN deprecated [email protected]: request-promise-native has been deprecated because it extends the now deprecated request package, see https://github.com/request/request/issues/3142
npm WARN deprecated @oclif/[email protected]: Deprecated in favor of @oclif/core
npm WARN deprecated [email protected]: this library is no longer supported
npm WARN deprecated [email protected]: Use your platform's native atob() and btoa() methods instead
npm WARN deprecated [email protected]: Use your platform's native DOMException instead
npm WARN deprecated [email protected]: Use your platform's native performance.now() and performance.timeOrigin.
npm WARN deprecated @oclif/[email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated @oclif/[email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated @oclif/[email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated [email protected]: Please upgrade  to version 7 or higher.  Older versions may use Math.random() in certain circumstances, which is known to be problematic.  See https://v8.dev/blog/math-random for details.
npm WARN deprecated @oclif/[email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated @oclif/[email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated @oclif/[email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated @oclif/[email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated @oclif/[email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated [email protected]: request has been deprecated, see https://github.com/request/request/issues/3142
npm WARN deprecated [email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.

changed 1744 packages in 34s

160 packages are looking for funding
  run `npm fund` for details
Pulling the cordova-builder docker image...
Error: spawn docker ENOENT
Pull done with code ENOENT
Upgrade done (if it was available) with code 0.

Press the BACK button in your browser, then RELOAD the page.

Thanks,

DanPerTech

Hi

How can I phisically delete a file from a view in Saltcorn?

So far, the uploads table will let you delete records, however the phisical file will remain in disk.

Is there a way to remove the file?

Noob question.

How do I display a value as currency?

I am new to Saltcorn but I am familiar with PostgreSQL and am thinking I can build tables very quickly with SQL code. Can I bring prebuilt tables into Saltcorn by pointing to the existing Database?.

Save buton not visible on the Root Pages section so I cannot assign a user level to a page. Just follwoing the intro tutorial.

there is an issue with searching searching base on id of a tablet. i tried to create a calculated valued "D"+id, i worked on search but after adding 5 recored the filed is not calculated after inser. A message of "Dunundetified" is shown.

any suggestion?

The FloatArray data type plugin is very cool.  However, I'm using Saltcorn to capture data from a micro-controller unit, and they like to use integers mostly.  Consider this a feature request for an IntegerArray data type, that would also be very cool.