What is the protocol for the {edit_record} function?

Hi-

First of all, the new connectivity version is great, but I am having a bit of trouble getting things to work correctly. I can bring all of the records up, but I am not sure how to edit or delete them through the front-end. I need to have an administrator be able to log into the front-end and edit the records as easily as possible. Right now, I am very basically showing the records (I followed the tutorial for the original connectivity) and I need to know what code to add to it to make it editable through the front-end. How can I do this? Here is the code in the body tag:

<hr>
<p>
<strong>{id}: {lastname}, {firstname}</strong><br>
{email}
<br>
{referenceforms}
<br>
{quiztaken} 
</p>
<hr>

Also, not to overload you with questions, but is there a way I can have headings (in a table) just once instead of for every record?

Thanks,

Dave
Ark Media Group

Also, i noticed that if you just put {edit_record} in the code, it shows up as a link but doesn't actually link to the record, in firefox and IE but nothing shows up in Safari, do you know a way around this?

Nevermind, ALL problems solved! This is a great component!

Great, would you mind putting your HTML code here for others ?🙂

regards
Max

Dave:

I didn't see a response to your question about having table headers show up only once. Here is my solution.

Put the table start and headers in the Header block on the General tab. For example:

<br>{new_record}<br><br><table border=1><tr><th>Edit</th><th align='center'>Day of the Week</th><th>Start Time</th><th>Teacher / Leader</th><th>Class name</th></tr>

Then put the structure for the table rows and your data placeholders in the Body block on the same tab. Continuing the example:

<tr><td>{edit_record}</td><td align='center'>{Weekday}</td><td><?php echo date("g:i a",strtotime($row->timeStart))?></td><td>{Teacher_Leader}</td><td>{Class_name}</td></tr>

Use the footer block to close the table.

This worked well for me. I hope it gives you a solution.

George

Could someone post an example of the HTML needed for the "Record Edit Template" under "Front End Permissions"? I can't seem to figure out the part about "...you should include a field with a name similar to the table primary key..." Any help would be greatly appreciated, thanks.

Alex.

Could someone post an example of the HTML needed for the "Record Edit Template" under "Front End Permissions"? I can't seem to figure out the part about "...you should include a field with a name similar to the table primary key..." Any help would be greatly appreciated, thanks.

Alex.

<input type="hidden" name="id" value="">

Got it working....thank you much!

Hi!

Sorry for I'm newbie for this component😶 .
I try to read everything about edit record on front-end but till now I still not understand yet😢 .
Can anyone help to post some example code or guide me something please....

I'm also fairly new at this, but I finally got this part working. This is a very simple code that allows me to change the status of a request to either "Approved" or "Declined".

<style type="text/css">
<!--
.style5 {color: #000000}
.style7 {color: #FF0000}
.style9 {color: #009900}
-->
</style>
<tr>
<div>
  <input type="hidden" name="cf_id" value="">
</div>
<tr>
</tr>
<div> </div>
<table height="20" border="0">
  <tr>
    <td width="150"><strong>Name</strong></td>
    <td width="150"><strong>Activity</strong></td>
    <td width="150"><strong>Date of activity</strong></td>
    <td width="150"><strong>Status</strong></td>
</tr>
</table>
    <table height="50" border="0">
  <tr>
    <td width="150" height="46"><span class="style5">{text_4}, {text_2}</span></td>
    <td width="150" height="46"><span class="style5">{select_12}</span></td>
    <td width="150" height="46"><span class="style5">{date_8}</span></td>
    <td width="150" height="46"><p class="style5">
      <label></label>
      <label>
      <select name="approval" size="1" class="style5" id="approval">
        <option value="Approved">Approve Request</option>
        <option value="Declined">Decline Request</option>
      </select>
      </label>
      <br>
    </p>      
      <span class="style5">
      <label></label>
      </span></td>
  </tr>
</table>
  

Hi!

@elsepu, remove the form tags from your code!

@noo_bai, do you have the body code of the connection ready ? tell me more what do you need to do!

Regards
Max

Hi! elsepu,
thank you for yr help. that one of I need :wink: .

Hi! Max,
I created the task request that allow registered to request work to me by fill data in form and I will 'accept' or 'reject' them.
Now I can edit in back-end but not in front-end. Could you please guide what necessary code that need in front Permission page.
(The current tutorials can help but not enough for new as me)
This is my body code.

  <table width="900" border="0" cellspacing="0">
  <tr>
    <td width="45">{cf_id} </td>
    <td width="90">{pkg} </td>
    <td width="95">{spkg} </td>
    <td width="75">{request_numb} </td>
    <td width="150">{request} </td>
    <td width="90">{type} </td>
    <td width="145">{stock} </td>
    <td width="90">{ref} </td>
    <td width="130">{date} </td>
  </tr>
</table>      
(Not complete yet)

Hi noo_bai,

in your body code add {edit_record} anywhere, and set the permissions for editing in the "front permissions" tab and add some code to be used for editing at the frontend template edit code, the same as the admin edit code theory!

Regards
Max

Hi! Max

Got it! Thank a lot 😀
Excellent component!

Damn, I feel like a newbie 😶 - but I guess I just am...

Following your explanations above, I build a small connection-form w. the <input type="hidden" name="cf_id" value=""> tag and a drop down menu.

But how to submit the modification? I tried to add a 'submit' button, but that didn't work out well.

Should I indeed add such a submit button?
Is there something else I should do - if so, what?
I didn't set the 'frontend permissino tab' since I have no clue where to find it - Where can I find the 'frontend permission tab', is it in Joomla? or in Chronoconnectivity...

Thanks for helping me out....

Gr. Fishhead

Hi Fishhead,

that tab is in Connectivity 1.2 only, what are you trying to do ?

Regards
Max

I just updated to version 1.2, and found the front-end tab.

Let's see whether I can make it work myself, if this doesn't work out, I will contact you again.

Basically what I want to do is to give people the possibility to edit their own records.

Gr. Remko

Still things don't work out, I simplified everything, and now I've got this - what am I overlooking...

General tab:

Body:
<input type="hidden" name="cf_id" value="">
{edit_record}<strong>Name: </strong>{naam}<br>

Delete Link Code: Delete
Edit Link Code: Edit
Remove Link Code: Remove

Front Permissions tab:

Record Edit Template:
<input type="hidden" name="cf_id" value="">
{edit_record}<strong>Name: </strong><input type="text" name="naam"><br>

Set all permissions to: Public users / Guests.

If I open the link, I just see the body code, without any options to edit, delete etc. and to 'submit' or confirm my modifications.

Anybody a suggestion what I am overlooking? (ps. I am using Firefox, so it isn't a IE7 issue) :?

Hi,

Set all permissions to: Public users / Guests.

set it to everybody, from a guest to super admin and retry.

Regards
Max

IT WORKS!!

I don't know why / how, but without changing anything (there is no 'all' option) it works!

I really would like to thank you and your colleague(?) for these very nice modules (both ChronoForms & ChronoConnection). This makes everything possible that we were considering for our website, without these modules (and our lack of IT-knowledge), we would have never achieved this! I've just got myselve a license for your software, you deserve it.

There is still a lot of work to do, and we will definately still be asking many questions to you (sorry for this 😶 ), but the I have trust that I can manage.

Sorry that I got a little sentimental, Guess it is time to go to take some sleep.

Gr. Remko

No problems, glad all is fine now!

Regards
Max