Forums

How to change "Record 1"

Soundtek 13 Feb, 2011
Hi everybody🙂 I am italian and I don't speak english very well so sorry in advice for any grammatical error😶

I have just bought a license.
My first problem is how to change the "record" in name field when a user send a form. It is possible to change "Record 1" "Record 2 "Record 3" etc with some other name (for example username)?
GreyHead 13 Feb, 2011
Hi Soundtek,

I don't think you can put a field value in there. You can change the text in the DB Connection | DataView Fields box but I think you can only have it say User #n instead of record #n

Bob
Soundtek 15 Feb, 2011
:? :? really? Why it is impossible to change that field name? If I have 100/200 or plus users how can I manage all?
GreyHead 15 Feb, 2011
Hi Soundtek,

My apologies, it looks as though you can add {column_name} in the field and it will display the column value.

I didn't know that until I dug in the code to see how it worked. Normally, I'd build a ChronoConnectivity listing so that I can view and filter the records from the front end.

Bob
CrystalFrontier 29 Aug, 2011
Dear GreyHead,

I've stumbled upon your reply in search for an answer to this exact same question. I'm using Joomla 1.6 and I believe there is no ChronoConnectivity available. However, if I could tweak that "Record#1" entry to show one of the form name's field entries - that would do it for me.

Please tell me where I can find the respective file to make that change.

Best regards
CrFrontier
GreyHead 31 Aug, 2011
Hi CrFrontier,

I think it is line 33 of administrator/components/com_chronoforms/views/list_data.php

Bob
CrystalFrontier 31 Aug, 2011
Thanks a lot for getting back to me!

Now, this is what it says in line 33 in my case:

<td width="2%" class='title'><?php echo $row->$primary; ?></td>

Where would I need to make the change and which exactly?
Following is a broader exceprt from the file (ll. 19-41) ... maybe the change needs to be done anywhere else? At least the term "Record" shows up here and there...any ideas? Greatly appreciated!

CrystalFrontier

<thead>
<th width="1%" class='title'>#</th>
<?php if(!empty($primary)): ?>
<th width="2%" class='title' style="text-align: left;">ID</th>
<th width="1%" class='title' style="text-align: left;"><input type="checkbox" name="toggle" value="" onclick="checkAll(<?php echo count($table_data); ?>);" /></th>
<?php endif; ?>
<th width="95%" align="left" class='title' style="text-align: left;">Record</th>
</thead>
<?php if(!empty($table_data)): ?>
<?php $i = 0; ?>
<?php foreach($table_data as $row): ?>
<tr>
<td width="1%" class='title'><?php echo $i + 1;?></td>
<?php if(!empty($primary)): ?>
<td width="2%" class='title'><?php echo $row->$primary; ?></td>
<td width="1%" class='title'>
<input type="checkbox" id="cb<?php echo $i;?>" name="cb[]" value="<?php echo $row->$primary; ?>" onclick="isChecked(this.checked);" />
</td>
<?php endif; ?>
<td width="95%" align="left" class='title'><a href="#show_data" onclick="return listItemTask('cb<?php echo $i;?>','show_data')">Record #<?php echo $i + 1 + $pageNav->limitstart; ?></a></td>
</tr>
<?php $i++; ?>
<?php endforeach; ?>
GreyHead 31 Aug, 2011
Hi CrystalFrontier.

That is the line that is outputting the Record number (the value of the primary key).

I don't know what you wwould need to change and if you are in any doubt I recommend that you don't hack the core files.

Bob
CrystalFrontier 31 Aug, 2011
Alright, thanks again..

It's a shame, though. Is it just because I'm using 1.6? I mean, it seemed easy in 1.5 (which I'd never used) and I don't see the point in people registering for something and you can't trace their entries except for "Record#1,2,3,4,5" - How would I find the record I want? Of course I can edit everything through MYSQL, but what's the point of having users using the backend to look up data?

Thanks for your help, and maybe you have an alternate solution?

Do you know, perchance, if there will be ChronoConnectivity for 1.6 as well? That seems to me to be the easiest solution...

Greetings
CrystalFrontier
GreyHead 31 Aug, 2011
Hi CrystalFrontier,

it's because Max hasn't added that functionality into ChronoForms v4 (it may be in the new RC2.0 I haven't installed that yet).

Personally I rarely use it - if I want to search the data I use PHPMyAdmin or more likely build a Form and a Listing.

I don't know what plans there are for ChronoConnectivity - some of the functionality is available in the DB Multi-Record Loader action in ChronoForms v4.

Bob
skyshing 16 Sep, 2011
Hi Bob,

I have used Chronoform for many of my clients' website (I have bought many licenses). You don't expect client to go to phpmyadmin end to look at data view record there. You personally rarely use the features we talked about here, but others do. I agree with "CrystalFrontier", the "DataView Fields" parameter is exist under DB Connection in Chronoform for Joomla 1.5, so where is the equivalent for Joomla 1.6/1.7??? I have the same problem, when you have lots of record in data view, all you see is ID column and Record column like this Record #1, Record #2, Record #3, Record #4, Record #5 and so on. How do you know which record is for which by looking at Record #1, Record #2, Record #3 etc?

Let me remind you what Chronoform on Joomla 1.5 is in regard to "DataView Fields" parameter under DB Connection. see screenshot below:



Also in Joomla 1,5, I don't think you need ChronoConnectivity to display extra columns in data record view, I don't have it in mine and it display fine, see screenshot below::



So when is the "DataView Fields" parameters available for Joomla 1.6/1.7?
By the way, no hacking require in the Chronoform version on Joomla 1.5.
GreyHead 16 Sep, 2011
Hi skyshing,

ChronoForms isn't my product and I have no control over what is or isn't included in the new releases.

Have you tried the Data Viewer in CFv4 RC2.0?

Bob
skyshing 16 Sep, 2011
Hi Bob,

Whoever is responsible for the new releases of ChronoForm should look into this post/thread, can you pass it on?

In CFv4 RC2.0, everything seems to work fine except what I want with the data view just like the previous version

You said "Have you tried the Data Viewer in CFv4 RC2.0?", What is "Data Viewer"? Please explain a little bit more in steps, then I can try it, thanks

Skyshing
GreyHead 16 Sep, 2011
Hi Skyshing,

I can't be sure that Max will read this - by all means send him a message through the Contact Us link above.

If you open the Configuration tab of the DB Multi Record Loader action in CFv4 RC2.0 there is a 'Data Displayer' tab. It has a 'Display Fields' box that I think does what you want. I haven't used it so can't tell you much more.

Bob
skyshing 17 Sep, 2011
Hi Bob,
Thanks for the reply. I will look into it.
This topic is locked and no more replies can be posted.