Forums

Hi

Just getting the hang of connectivity but am struggling to find the best way to handle fields that depend on quite complex logic that, in Chronoforms, I handled externally either as ‘require_once some file’ or ‘require_once some functions’ and then calling a function in there. This screen shot might best explain what I am after.

[attachment=0]NickOg.png[/attachment]

My question really is where should I put calls to load those fields? I could hard code them into ‘PHP Functions’ but as I say – the logic is quite complex and would not be fun to handle and debug there. I sort of assume that they should go into ‘PHP Functions’ but maybe into HTML and call <?php from there.


Any suggestions? I can’t find an explanation in the examples/tutorials.

Chronoforms really is an impressive package.

Hi NickOg,

I'm not familiar enough with CCv5 to give you a clear answer. I'd probably use a Custom Listing and build these in the Body box but it might be possible with either PHP Functions or HTML. I suggest that you experiment with a very simple list to see what works.

Bob

Thanks Bob. I had it in mind to use the PHP functions and make the function a function.
Something like

vuAllMembers.Action:return  function doSomething($aRow){echo 'Hello sailor';} doSomething($row);

but no good.

I will go play.

Thanks

Nick

I think that I am on the right track using 'View and Edit Actions' - Max's FAQ. But I have several questions

1. I made a new action and realize that isn't what I need. How do I delete that?
2. From my diagram, I reckon I need
a) one view action to print the badge
b) one edit action to book a course (via CF5)
c) action to renew a membership (via CF5)

so I have three entries in 'View Linkable'

vuAllMembers.badge
vuAllMembers.Book
vuAllMembers.renew

My problem is that I can't see how one makes the connection between each view and an action.

I have some code in a view action

<h3>This will be a badge</h3>
<table>
<tr>
<td>vuAllMembers.firstname</td><td>vuAllMembers.firstname</td>
</tr>
</table>

but the link doesn't work. I get an SQL message

1054 - Unknown column 'vuAllMembers. = ''' in 'where clause' 
SQL=SELECT `vuAllMembers`.`comprofilerid` AS 

`vuAllMembers.comprofilerid`, `vuAllMembers`.`memberNumber` AS 
`vuAllMembers.memberNumber`, `vuAllMembers`.`title` AS 

`vuAllMembers.title`, `vuAllMembers`.`lastname` AS `vuAllMembers.lastname`, `vuAllMembers`.`firstname` AS `vuAllMembers.firstname`, `vuAllMembers`.`memberName` AS `vuAllMembers.memberName`, `vuAllMembers`.`Paid` AS `vuAllMembers.Paid`, `vuAllMembers`.`Status` AS `vuAllMembers.Status`, `vuAllMembers`.`username` AS `vuAllMembers.username`, `vuAllMembers`.`email` AS `vuAllMembers.email`, `vuAllMembers`.`address` AS `vuAllMembers.address`, `vuAllMembers`.`state` AS `vuAllMembers.state`, `vuAllMembers`.`homeaddress` AS `vuAllMembers.homeaddress`, `vuAllMembers`.`phone` AS `vuAllMembers.phone`, `vuAllMembers`.`mobile` AS `vuAllMembers.mobile`, `vuAllMembers`.`PartnerPhone` AS `vuAllMembers.PartnerPhone`, `vuAllMembers`.`PartnerMobile` AS `vuAllMembers.PartnerMobile`, `vuAllMembers`.`datebirth` AS `vuAllMembers.datebirth`, `vuAllMembers`.`sex` AS `vuAllMembers.sex`, `vuAllMembers`.`MemberPartner` AS `vuAllMembers.MemberPartner` FROM `hvu3a_u3a_vuCC_allMembers` AS `vuAllMembers`

 WHERE `vuAllMembers`.` = ''

which seems to be the same in each case. It is the WHERE clause that is at fault. I made up that extra action thinking that was part of the problem. But no go!


I will see if I can reproduce Max's example but if anyone can clarify this for me I would be grateful!

Regards

Nick

I think that I have the answer to some of these

2. From my diagram, I reckon I need
a) one view action to print the badge
b) one edit action to book a course (via CF5)
c) action to renew a membership (via CF5)

Just FYI - add an action for each additional action. Thus, I needed a print, and delete action and defined and action for each

printMbrReceipt:load
editMbrReceipt:load
deleteMbrReceipt:load

and made a form for each of these.Some (eg edit) exist by default

Nick