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?
Example of Triggers
dlanorsotra a month ago
Add URL type to tables
James a month ago
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.
Locale support in view?
koen01 2 months ago
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.
Dynamically fill in form fields / JS onchange events
theneilkirk 2 months ago
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
Saltcorn instance behind an air gap
Miku 2 months ago
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?
Forced filtering (aka database security)
kev 3 months ago
Firstly, this project is awesome.
I know this has been brought up previously but I want to add more to the topic. It would be very useful to have some more database security options. For example, if I made a notes app with multiple users, I wouldn't want Joe having access to Bob's notes. One way to do this would be forced filter views, where the filter is pre-configured and can't be changed by the user. This doesn't cover every case and it's not perfectly secure but it would keep things simple and intuitive.
Inserting a row into another table using contents from the trigger row.
ybotmallah 3 months ago
I have a table called visitors, my plan is that using the events I can then pick certain details from the entry in Visitors and copy them into Calendar. However I am not sure which action would be able to do this? I would hazard a guess at "Run JS Code", however I wouldn't have the slightest clue at what the code would need to be.
If anyone could point me in the right direction it would be much appreciated.
What is the best way to manage static resource files
Chlipouni 3 months ago
What is the best way to manage these files ?
If I use the file manager, is there a way to access the file by its name instead of its ID ?
Advanced filtering with multiple select
samandreu 4 months ago
First of all thanks for this great project.
I would need to implement a more advanced filtering and give the possibility to the user to select multiple values for one field and see all results in the list.
For example: in a table with the field COLOR, they should be able to select all elements with color red OR blue, in one view (list)
This cannot be done with the normal dropdown filter in the filter view (only one value can be selected). And I couldn't find an easy way to do it so far...
Would you have some ideas on how I could implement that?
Thanks in advance for your help.
How to: API request on partial string
Bruno 4 months ago
I created a table (companies, for example) with several fields (name, address1, address2, zipcode, city).
As a user, I may not know the exact syntax of my search. For example, if I search for a company called "Acme Industry Inc., I might want to just type in" Acme "and get the result.
Through Saltcorn I manage to do this and get my result.
In SQL, I will be able to do it with "Acme%" for example and get my result.
With the API embedded in Saltcorn, I can't do it (maybe I don't know how to do it well). It seems to be waiting for the full chain of characters.
Can any of you guide me?
Dynamic HTML content
Chlipouni 5 months ago
First of all, I want to thank you for making this amazing open source project.
I made a personal site with Oracle APEX, and I am trying to migrate it with Saltcorn and PostgreSQL.
I have a stored function in my PostgreSQL database that generates SVG code.
Is there a way to call this function from saltcorn ?
For now, I did the following steps to be able to show the result of SVG in a saltcorn web page :
Add a new text column in the associated table
Generate and store the SVG code in this new column
Activate the HTML field type plugin
Set the field view as "unsafeNotEscaped
I would like to avoid storing the SVG code in a database column.
Do you think that using a calculated field that calls a PostgreSQL stored function (with the row id as a parameter) is something doable via a new plugin ?
We able to suggest feature Ideas?
Nome 5 months ago
Hi, we able to suggest features for Saltcorn? If so where?
Wondering if possible to add geolication fields that allow users that access a form to get gps coordinate from their moble app?
IS SALTCORN STILL LIVING ?
phd 5 months ago
I was very happy discovering saltcorn, I though WOW ! This is absolutely what I need. Free, light, nocloud... What a good job !
I installed it, started working, and...
-> Creating data : no delete column, no changing type of column: when error, must delete and recreate the whole table.
So OK, I will prepare csv files and upload definition ...Import csv is mentioned but never documented, unable to guess the needed format...
In consequence, the data structure must be fully defined before beginning any development of an app. That is not my way.
-> testing some screens : I need to set a preset value, now : YES, found a topic about in on the forum !
But, unable to find correct syntax : now, =now, =now() ... nothing works !? Again, nothing more in documentation.
So: OK, I will ask the forum. But sorry, no answer after a week.
In these conditions, I cant build tools for my organization that rely on such a project.
Found an ambitious roadmap, but it seems this amazing project is almost dead.
I dont want to throw stones to anybody. I well understand that this is a free project, and I also can fully understand that people who achieved this great job are now away, or not available enough to support it. I would have been very happy to use saltcorn, sharing and helping on forum, even helping adding documentation... it would be very disappointing that this fine job became abandoned.
Is there someone here ?? with answers about that ? Tomn perhaps ?
Saltcorn installation on Mac OS
Eden 5 months ago
I would like to ask if it's possibile to install Saltcorn on Mac OS using the Ubuntu installation described on the Wiki.
Overwise, does a Mac OS installation exist ?
Thanks for your answer !
Uploading table definitions
phd 5 months ago
Not found in the wiki, could someone give an example of a csv file for creating a table (creating, not just populating) from upload csv ?
Great thanks !
problem with Kanban
JonathanDHolden 5 months ago
I'm having problems with the Kanban... not sure if it's because I've got too many columns, but I can't drag anything into the last few columns of the board
I'm looking to set up a view which has a filter to show only rows linked to a user
E.g. users and tickets table, user has a relationship to tickets
I want to show only the logged in user's tickets, and not any other users' tickets.
I can set a filter and embed a ticket table view
But I don't want the user to be able to change the filter, e.g. no dropdown or toggle
Is this posisble ?
Or create new
JonathanDHolden 5 months ago
I'm building a folder structure for my Docs, but when I want to create a new Folder, the popup opens, but I can't add anything to it... What do I need to do?
Link from an "index" to a particular page view
JonathanDHolden 5 months ago
I have created an index by creating a List view. I have just one element from the table that I want to show in the list. Each item in the list should link to the Show view for that item, but I can't see a way to make the link work.