Hi RaSchDMD

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

Bucklash

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 

Probably storage of your concat field is wrong, see

http://www.seblod.com/community/forums/fields-plug-ins/sd-concat-created-a-new-title-field

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

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.

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

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

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

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.

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

Hi raschdmd

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 :)