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

 

Hallo,

ich nutze eine Installation unter Windows 10.

Lieder wird mir hier kein löschen Button angezeigt.

 

Awseome product. Genius and much appraciated.

I am installing on a AWS lighsail VM but an getting ths error message on the download of the install file

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

Command used:  sudo wget -qO - https://deb.nodesource.com/setup_14.x | sudo bash -

Output:....

## Installing the NodeSource Node.js 14.x repo...

## Populating apt-get cache...

+ apt-get update
Get:1 http://security.ubuntu.com/ubuntu focal-security InRelease [114 kB]
Ign:2 https://deb.nodesource.com/node_14.x focal InRelease
Hit:3 http://archive.ubuntu.com/ubuntu focal InRelease
Err:4 https://deb.nodesource.com/node_14.x focal Release
  Certificate verification failed: The certificate is NOT trusted. The certificate chain uses expired certificate.  Could not handshake: Error in the certificate verification. [IP: 23.223.44.151 443]
Get:5 http://archive.ubuntu.com/ubuntu focal-updates InRelease [114 kB]
Get:6 http://security.ubuntu.com/ubuntu focal-security/main amd64 Packages [907 kB]
Get:7 http://security.ubuntu.com/ubuntu focal-security/main Translation-en [173 kB]
Get:8 http://security.ubuntu.com/ubuntu focal-security/main amd64 c-n-f Metadata [8824 B]
Get:9 http://security.ubuntu.com/ubuntu focal-security/restricted amd64 Packages [446 kB]
Get:10 http://security.ubuntu.com/ubuntu focal-security/restricted Translation-en [64.0 kB]
Get:11 http://security.ubuntu.com/ubuntu focal-security/universe amd64 Packages [641 kB]
Get:12 http://security.ubuntu.com/ubuntu focal-security/universe Translation-en [102 kB]
Get:13 http://security.ubuntu.com/ubuntu focal-security/universe amd64 c-n-f Metadata [12.5 kB]
Get:14 http://archive.ubuntu.com/ubuntu focal-backports InRelease [101 kB]
Get:15 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 Packages [1256 kB]
Get:16 http://archive.ubuntu.com/ubuntu focal-updates/main Translation-en [265 kB]
Get:17 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 c-n-f Metadata [14.4 kB]
Get:18 http://archive.ubuntu.com/ubuntu focal-updates/restricted amd64 Packages [485 kB]
Get:19 http://archive.ubuntu.com/ubuntu focal-updates/restricted Translation-en [69.4 kB]
Get:20 http://archive.ubuntu.com/ubuntu focal-updates/universe amd64 Packages [864 kB]
Get:21 http://archive.ubuntu.com/ubuntu focal-updates/universe Translation-en [184 kB]
Get:22 http://archive.ubuntu.com/ubuntu focal-updates/universe amd64 c-n-f Metadata [19.1 kB]
Reading package lists... Done
E: The repository 'https://deb.nodesource.com/node_14.x focal Release' no longer has a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
Error executing command, exiting

Hi,
looking at the GUI, it's not clear to me how to open the block editor of js editor. Once I create the action button and choose the 'block' type, how can I access the block configuration?
BR, Dariush.

Hi,

i try to build some forms with saltcorn. i have an address table with in more than 3000 rows. customer table has key to address table.
how can i select the correct address_id in create view of customer?

when i create the the i have only a select-field with 3000 ids. that will not work.
search_or_create gives an "popup" of the list, but how can i search and select the right one?

thanks

I tried to use a trigger that updates the date field whenever the row was edited, but I cannot make it work, I tried to use javascript  Date.now(), but none works.

Firstly - love this - running in digital ocean.  Great work !

Can you add a new field type `url` I am adding html fileds at the momnent and adding the required - <a href="https://www.w3schools.com/">Visit W3Schools.com!</a>  etc...

Would be great just to add the url https://www.w3schools.com in the filed and it is clickable on the table view.

 

Thanks

Hi, 

forgive me, i'm kind of new to saltcorn. 

Is it possible to have locale settings applly to views too? When i set language in a users settings to let me say Dutch (my native language) the data/time picker still uses AM/PM for intance. 

And the moment.js formatiing of date time still uses english monh and day names etc.

 

 

Hi

I'm trialing saltcorn, and, having played with a few other no-code builders, am impressed with how well it runs and works!

Is there any way that I could populate form fields based on other information entered? For example, a user enters a cost and then the sale price gets set up cost + defauly margin. The user is obvisouly free to change the sale price if they want to.

I suspect it's with a bit of (JS) code on an edit view. Ideally, I'd like to set a onchange event to the cost field which simply update the value of the sale price.

Is it possible to do this somehow?

Thanks in advance

Hi,

in our company we have a network  behind an air gap (no way to the internet, no proxy).

I tried your default docker image, and basicly it runs but the are many java script files, which would be loaded from the internet.

Is it possible to build a version, where are all needed files (maybe plgins too) in one build which could be usded without an internet connection?

 

Greeting

Miku