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.
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
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
but no good.
I will go play.
Thanks
Nick
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'
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
but the link doesn't work. I get an SQL message
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
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
Just FYI - add an action for each additional action. Thus, I needed a print, and delete action and defined and action for each
and made a form for each of these.Some (eg edit) exist by default
Nick
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
This topic is locked and no more replies can be posted.