Buy Now
Sign in

Calling Form record into a Table Row

har7801 , October 03 at 05:34
Answered
H
har7801
Hi and Thanks in advance.
I am trying to something a little trickier than usual and have got stuck. My guess is on the syntax of the where clause in a read function. Any help would be great.
  1. Have a table calling in data and displaying - no probs
  2. Table has a row called Action, to display the data from two table fields in a certain way within that row. I have made a new read function, created a form view and this in tern calls a fields view with the CC in it with the data being called and displayed in the table as desired. - This is where is goes wrong.
The fields view call the data and displays it ok, but it is repeating the first entry only. Over and over. Screen Shot attached. I want it to display the data for the record it is within.
I have the where clause empty and the select type on first matching record. If I change either of these then I get no results at all. Again this leads me to the understanding its my where clause to have it look at an identifier for each row to tell it what to display. Am I at least on the right track?
If so I just don't know/understand the syntax I need to use. Help is appreciated.
H
har7801
Debug.JPG
CC.JPG
Front.JPG
Attachments
Debug.JPG
Debug.JPG
(48.25 KiB)
89 Downloads/Views
CC.JPG
CC.JPG
(56.27 KiB)
88 Downloads/Views
Front.JPG
Front.JPG
(29.19 KiB)
86 Downloads/Views
healyhatman
It would help if you post a screenshot of your read data actions, and probably your table too.
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
H
har7801
This is the table:
Table.JPG
This is the table read action:
Table_Read.JPG
This is the read action for the form/fields:
Form_Read.JPG
Attachments
Table.JPG
Table.JPG
(48.53 KiB)
79 Downloads/Views
Table_Read.JPG
Table_Read.JPG
(81.59 KiB)
78 Downloads/Views
Form_Read.JPG
Form_Read.JPG
(77.03 KiB)
79 Downloads/Views
healyhatman
What's in the {view:Operator_Records_Training_Form} ?
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
healyhatman
And that second read data action, how is it supposed to be related to the first one?
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
H
har7801
Ive made this way more complicated than it needs to be.
So, I want to display these three fields:
Fields.JPG
That are being called in this array, shown in the debug:
Array.JPG
Here:
Result.JPG
I know I can show one of the results at a time but I want to show 3 of those 4 (Not the hot_wear). I thought of doing a view and calling in a form and fields but cant make that work. Am I on the right track? Or something else?
Attachments
Fields.JPG
Fields.JPG
(12.19 KiB)
73 Downloads/Views
Array.JPG
Array.JPG
(70.17 KiB)
76 Downloads/Views
Result.JPG
Result.JPG
(45.82 KiB)
79 Downloads/Views
healyhatman
*sigh* show me the view please.
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
healyhatman
If you just want to DISPLAY the values then in your table view do the following:
Action:{var:Operator_Records_Table.row.Article.field1}<br>{var:Operator_Records_Table.row.Article.field2}<br>{var:Operator_Records_Table.row.Article.field3}
Web developer at SkySpider.com.au
I don't work for ChronoEngine but I do accept donations paypal.me/healyhatman
H
har7801
What can I say......I really over complicated the hell out of that one.
Thanks a tonne.