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 

Hi guys,

Not sure why this plugin is not working for me. I have install and SSH and installed "sudo apt install chromium-browser" on my server on Digital Ocean marketplace.

I put the action button on a page and set it to the page, save to file, A4 size 

Anything else I need to do?

 

Hi!

We are a team and would like to develop a modular open source software together.

We imagine our development process as follows and would like to know if this be possible or if there is a better way:

* Saltcorn Server operated in multi tenant setup
* Each developer gets his own tenant
* The latest release of the application will be fully released as a PACK. Every developer installs this PACK in a tenant
* Based on the current version, each developer develops the application further
* For a new release, each developer creates a new DEV-PACK with HIS new development
* The DEV-PACK is sent to an integrator who integrates and tests all DEV-PACKs on a RELEASE tenant
* The integrator then creates a new RELEASE-PACK and distributes it to all developers

Questions:
1. Is such a procedure with SALTCORN feasible and sensible
2. Is it possible to create DEV-PACKS only with DELTA DEVELOPMENT?
3. If it is not possible to implement such a development model with SALTCORN, what would be the closest?

I am very curious what your experiences are?
Thanks and Regards
steph

 

 

 

 

Bla bla bla

Hi,

I wanted to know if there is any constraint for using the API without HTTPS. That's because I was able to use the API in my test *.saltcorn.com installation. Now I made a test installation in a VPS, without HTTPS, and can't call the API. It claims "timeout expired".

 

Saludos,

Hi,

  I was using an old release without any issue.

  After installing the last one with the following command :

  npm install -g @saltcorn/cli

  I obtain the following error when starting Saltcorn server :

  C:\>saltcorn serve
    Error: Package subpath './models/scheduler' is not defined by "exports" in
    C:\Users\Olivier\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\@saltcorn\data\package.json
    Code: ERR_PACKAGE_PATH_NOT_EXPORTED

Thanks

Hello,

I'm trying to make LDAP authentication work using @saltcon/ldap-auth plugin. Every attempt to log-in using LDAP results in saltcorn page freeze. The output of the saltcorn container in moment of login attempt is following:

saltcorn        | ldap {
saltcorn        |   label: 'LDAP',
saltcorn        |   postUsernamePassword: true,
saltcorn        |   usernameLabel: 'UID',
saltcorn        |   strategy: Strategy {
saltcorn        |     options: {
saltcorn        |       server: [Object],
saltcorn        |       usernameField: 'email',
saltcorn        |       passwordField: 'password'
saltcorn        |     },
saltcorn        |     getOptions: null,
saltcorn        |     name: 'ldapauth',
saltcorn        |     verify: [Function (anonymous)]
saltcorn        |   }
saltcorn        | }

I'm running saltcorn in docker using docker-compose. I tested, that I can access the LDAP server from docker container (can open port).

Is there any way how to debug what is happening and why is Saltcorn waiting?

Thanks,
Radim

Plz, take a look - there is a bug on date type saving. After page refresh it has 1654 year. I checked on DB level - same, it's not UI bug

Hello forum.For those who hate reading - you may check it via youtube link https://youtu.be/JO4t6pZlToo

Let me show an example how-to use triggers\event\js_code. 

Let suppose we have a task: I have two tables, one has project names and second has tasks for project. Each project has similar tasks and I need to populate them for particular project. Example is a bit synthetic, but it’s simple.

So my tables are:

I didn’t find any options to fill third table except by automated way.

I've read documentation few times – and didn’t find a pictures, thus I’m sharing it with you.

So it’s definitely automation, let start.

Overall way:

1 need to create a trigger

3 add automation to trigger

4 somehow bind trigger to input form.

Step by step:

1 Expand settings  ->Event- > Triggers and call “Add trigger”

1. Any name
2. WHEN – Never
3. Action == blocks (or if you know NOW how to use js_code you may choose run_js_code)
4. Safe a trigger. And return to all triggers.

 

 

Ok, time for “automation”.

5 Call “configure” for your just created  trigger and you will see some not overcomlictaed UI (Scracth has muuch more blocks, not sure if they all are usefull, but more:)))

 

 

So, 

workflows are simple: when I initiated trigger for particular raw in Project table, it some should copy all tasks from Task table to my third table with particular Project . So I need cycle, I need read a table and insert operation in table for each item in Tasks table

I spent a lot of time fighting with empty table as a result, my problems were in few areas:

• I didn’t declare proper types
• I was not able to convert query to list items.

After few iterations I fixed it all and you may see the algo as a picture bellow

 

And bigger picture

 

 

 

safe the changes and now time to find a way to call the trigger,

Open “views” -> create new -> give some name, default template “list” is fine, table – in my case “Project” -> configure

So you may see only one table in rectangle and have to add another with type: Action on raw – choose your trigger test_trigger in my example. Next -> Next-Safe

 

Now you returned to Views page and it’s time to run view – 3dots on right side and choose RUN

 

Now you see some record and button with trigger name

 

Press the button and check Project_tasks table.

 

So , automation is working and it’s time to be disappointed: blocks list is so por, I cannot work with serious math\dates\(whatever) ..

Yes that’s, there is no such block. But good news – you got a JS code entry example. Now it’s time to edit your trigger by “edit” button and choose run_js_code in Actions instead of blocks. Open the trigger – now it has code only and you may fix it as you wish (if you know js)

 

Have a good day

PS - you may convert blocks type to run_js_code, but you will loose your code on conversion form run_js_code to block.. be carefull:) 

 

Hello! first of all thanks for great product. I was not able to find sutiable examples.

Intro: I'm trying to create some incident system which is working with external systems. I need help for:

1 create new incident based on an existing incident with a few predifined field - I'd choose a particular raw, press "Reproduced" button and fill only few fields. 

2 I need to report incident to external system via post query with basic auth, data set should has value from related to particular (selected raw) and get some data back (ticked_id from the external system)

3 I'd have one text field and split typed text into two fields on raw creation\update "some text https_url" - I need store text and url in different fields, but for customer it a addtitional click, I'd like to help him. I believe js_run may help here, but cannot understand how I can link an text-box, js execution and "view" page

 

Any link\advice to similar solved appretiated.  - checked forum, doc . didn;'t find answrs

Can anyone show me a working formula that shows and hides a container based on a bolean value in the table?

I'm struggling to get it working on my side having tried...

out_ofuse==0
out_ofuse==false
out_ofuse===false
out_ofuse==null
!out_ofuse
!(out_ofuse)

As in title.

Is there any option to display item feed only if desired condition is true?

I see I can do kind of workaround by puting a container in "Show" and display this container only if condition is true but after linking it to "Feed" it still displays colums for hidden "Show items".

Or maybe there is another way to achieve something like public elements? The thing I want to achive is simple todo list but with owners and "isPublic" column/attribute. So if "isPublic" is true I want everyone to display this but if "isPublic" is false I want only owner can show/edit etc. this item.

Thanks for help in advance.

I have created a StackScript that makes it very easy to deploy on a Linode instance.

You can find the StackScript by searching for "s3b" or "saltcorn" or using the direct link: https://cloud.linode.com/stackscripts/932041 . The installation takes a couple of minutes, so be sure to give your Linode instance enough time to finish all the work (in my tests it took up to 5 minutes). You know when its done by checking http://<ip-address> , where you will see the SaltCorn setup wizard.

If you'd like to run your instance with TLS encryption (HTTPS), you can run the setup-reverse-proxy script (link).

Hi,

I'm building a simple cashbook (recording date, description, amount, current balance). For each transaction, I would need to sum all previous amounts to calculate the current balance.

How to do that ? I didn't find.

Best regards

AG

Is there a way to change the UI (say hide/unhide an element or change the label of a button) based on the value or change to the value of a field? Also, does the Javascript on the browser side have access to any state variables/field values?

Just discovered Saltcorn a week back. Am lovin it. 

Experimenting with trying to fire an update event on button click. What is the right format for the JSON payload? I only wish to change one field (called checked_out - bool type) in a row from within a "Show" view. Can I send a partial JSON and the rest will get filled automatically? Or do I need to supply the complete row including ID, if so, how do I populate the ID of the currently "Shown" row in JSON?

If I send {checked_out: true}, the event is triggered and logged but no change in the table. If I give checked_out:true, it complains of syntax error.

I have a data entry view with 2 tabs.   One tab has 10 fields and the other has 40 fields.   I was able to create the view and save it, but when I edit it, I can a delay of a minute or so and then this comes up in the window where I am running the server:

--------------------------------------------------------------------------------------------------------------------------------------------------------

(node:38352) UnhandledPromiseRejectionWarning: TypeError: res.status(...).sendWrap is not a function
    at module.exports (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\@saltcorn\server\errors.js:36:8)
(node:38352) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 6)
PayloadTooLargeError: request entity too large
    at readStream (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\raw-body\index.js:155:17)
    at getRawBody (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\raw-body\index.js:108:12)
    at read (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\body-parser\lib\read.js:77:3)
    at urlencodedParser (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\body-parser\lib\types\urlencoded.js:116:5)
    at Layer.handle [as handle_request] (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\layer.js:95:5)
    at trim_prefix (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\index.js:317:13)
    at C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\index.js:284:7
    at Function.process_params (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\index.js:335:12)
    at next (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\index.js:275:10)
    at jsonParser (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\body-parser\lib\types\json.js:119:7)
    at Layer.handle [as handle_request] (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\layer.js:95:5)
    at trim_prefix (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\index.js:317:13)
    at C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\index.js:284:7
    at Function.process_params (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\index.js:335:12)
    at next (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\express\lib\router\index.js:275:10)
    at internalNext (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\helmet\dist\index.js:72:24)
(node:38352) UnhandledPromiseRejectionWarning: TypeError: res.status(...).sendWrap is not a function
    at module.exports (C:\Users\mangue\AppData\Roaming\npm\node_modules\@saltcorn\cli\node_modules\@saltcorn\server\errors.js:36:8)
(node:38352) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 7)

Thanks for any help.

 

-- 

Gene