How can I insert fields that are based on complex external PHP code?

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