58 Posts
rasch-dmd
8 years ago
Topic

Hello Seblod Team,

I have the actual Joomla and Seblod. I made an concat field with one value, perhaps with $date.

But the field will not displayed. What I may do wrong?

Thanx in advance.

RaSchDMD

Get a Book for SEBLOD
1283 Posts
Bucklash
8 years ago
0
Level 1

Hi RaSchDMD


Will need more info as that is too vague.... what have you put and where etc


Bucklash

58 Posts
rasch-dmd
8 years ago
1
Level 1

Hi Bucklash,

thanx for your response. I made a new field called "Offer No." in the admin form of an Form & Content type. This is a concat field and has to catch another value of a field that calculate a continued number with an prefix "Offer No.". That should store the result in the "title" of the article.

But nothing happened. After that I set this concat field with an "easy to check" value in the field $date.

Same result. Nothing.

RaSchDMD 

4229 Posts
Kadministrator
8 years ago
0
Level 2
58 Posts
rasch-dmd
8 years ago
1
Level 1

Hi Klas,

first I want say that you and your team make a good job with seblod.

My field aims to standard->article->title.

I think that is okay.

But it not rendered in the admin form. See screenshots.

Regards

raschdmd

http://transfer.rasch-dmd.de/concat1.png

http://transfer.rasch-dmd.de/concat2.png

4229 Posts
Kadministrator
8 years ago
0
Level 2

Concat is never rendered on the form, it only saves changed value to the database. To actually see what it has produced you need to go to display content view and add Article title field to it.

58 Posts
rasch-dmd
8 years ago
1
Level 1

Hey Klas,

it only stores the timestamp: 2016-02-25-15-04-49 in the title of the article.

Do you have more ideas?

Thanx in advance.

rasch-dmd

4229 Posts
Kadministrator
8 years ago
0
Level 2

Check contct fields storage directly in database as described in above linked post.

58 Posts
rasch-dmd
8 years ago
1
Level 1

Hey Klas,

you are right. I made a new field and point it to standard -> article -> title. It goals.

But I got not another field that count the offers that exists. This field is a normal text field with a sql query, that count the offers (

SELECT COUNT(*) FROM #__content WHERE catid = 46) and give the value back as a number. I need this number to concat within the title. Now the article stores: (Offer #field_name# 109). 109 present the user.

Is there any other field to solve this problem or perhaps I may wrong with this concept.

I want to say THANK YOU for your help.

Regards

rasch-dmd

4229 Posts
Kadministrator
8 years ago
0
Level 2

AS you say "normal text field with sql query" I presume you are using SD databaser? It it a typography plugin which does nto alter actual fields value, you will need to replace it with SQL field

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

Then you can use its value in other fields like sd concat.

58 Posts
rasch-dmd
8 years ago
1
Level 1

Hi Klas,

sorry for my late repost. I have uses a normal text field with a live value "sql query". And I get the right number I need. But I can not tranfer it in the concat field. 

I have right now download the SQL-Pack. But nothing happens. I wrote the same sql query: SELECT COUNT(*) FROM #__content WHERE catid = 46

Do I need another query?

Thanx in advance.

raschdmd

1283 Posts
Bucklash
8 years ago
0
Level 2

Hi raschdmd

If I understand you correctly....
You have a form,
In this form you want to store a value,
This value is based on the concatenated value of two fields,
One of these fields is the Form Title,
The other field is a value based on a SQL query.
I have described my process below:
STEP 1:
Create three fields: 
Field 1: {Type: text, Title: Title, Storage: title}
Field 2: {Type: text, Title: The Query, Storage: None}
Field 3: {Type: text, Title: The Fake Title, Storage: None}
(Field 1 stores the concatenated values of Fields 2 and 3)
STEP 2:
Field 2 (The Query): Set live to SQL Query and add this code:
SELECT COUNT(*)
FROM #__content
WHERE catid = 2 
(Change catid to whatever value is required)
Add to Form (display in hidden position when site is live!!)
STEP 3:
Field 3 (The Fake Title): Display in Form, visible to the user. Title will be typed in here.
STEP 4:
Field 1 (Title): Select 5 from the column of numbers - "Conditional States + Computation".
Select "Edit" from the "Computation" column.
A Modal Window Appears.
Select "Concatenate" form the "Computation" Select List.
Add the desired fields.
Save and Close
Add to Form (display in hidden position when testing is complete!!)

 

 

Bucklash

  

PS I find it easier to use the BeforeStore Field to do things like Concatenate... more versatile :)

58 Posts
rasch-dmd
8 years ago
0
Level 1

Hey Klas and Bucklash,

all solutions work! I have to learn more about the sql pack, but that is an issue for another day.

My post can remark as resolve.

Thanx for all you help.

rasch-dmd

Get a Book for SEBLOD