8 years ago
6
Topic

I'm investigating the features and functionality of seblod. 

I have seen numerous video tutorials on youtube and vimeo. 

Unfortunately I have not found documentation and basic tutorial to proceed to customize the fields, scripts, and more. 

For example how to manipulate form's fields within script or sql query.

Is there documentation? 

thank you.

Get a Book for SEBLOD
4229 Posts
Kadministrator
8 years ago
4
Level 1

Not sure what you need, but you can manipulate fields using javacript, they are no different from any other html. To manipulate things on server side you can use code pack  https://www.seblod.com/store/extensions/1854

Also there are plugins to manipulate  sql, e.g.

https://www.seblod.com/store/extensions/19157

https://www.seblod.com/store/extensions/922

https://www.seblod.com/store/extensions/19162

8 years ago
3
Level 2

Where can I find tutorials and examples on how to use Sql pack (use as field).

My question is:

I have a Content Type Form with

1)  field select dynamic: to select value from a table 'Products' ( id, name, price)

2) field text: quantity to sell

3) field Sql Query (contains total) = product price * quantity. But first I must  recover the price of the product (selected in field select dynamci), and then multiply it with the quantity: how can I do this?


thanks.


4229 Posts
Kadministrator
8 years ago
2
Level 3

You don't need any custom script for that, Seblod has built in computation

8 years ago
1
Level 4

I saw "computation rules" but it works with fields already in the form.

In my case I have in the form "Product id": through  id I have to recover the price and then multiply it by the quantity field.

I do not know how to recover the 'Price" in table Product through the ID  that I have in field 'product id' select dynamic.

thanks

4229 Posts
Kadministrator
8 years ago
0
Level 5

You need

https://www.seblod.com/store/extensions/2997

With this field you can have product in first select, then pick up price in the second, based on the selection in the first field. Then you can use calculation to multiply quantity and price from second field.

4229 Posts
Kadministrator
8 years ago
0
Level 1

And  answer to the actual topic of this thread, if anyone else will be searching for it:

https://www.seblod.com/resources/extensions/plug-ins/sql-pack

Get a Book for SEBLOD