Buy Now
Sign in

Calling Form record into a Table Row

har7801 , October 03 2018, 05:34
H
har7801 135
October 03 2018, 05:34 #380593
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 135
October 03 2018, 05:35 #380594
Debug.JPG
CC.JPG
Front.JPG
Attachments
Debug.JPG
Debug.JPG
(48.25 KiB)
254 Downloads/Views
CC.JPG
CC.JPG
(56.27 KiB)
243 Downloads/Views
Front.JPG
Front.JPG
(29.19 KiB)
247 Downloads/Views
healyhatman 7
October 03 2018, 12:46 #380596
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 DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
H
har7801 135
October 04 2018, 00:19 #380623
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)
233 Downloads/Views
Table_Read.JPG
Table_Read.JPG
(81.59 KiB)
237 Downloads/Views
Form_Read.JPG
Form_Read.JPG
(77.03 KiB)
240 Downloads/Views
healyhatman 7
October 04 2018, 03:03 #380624
What's in the {view:Operator_Records_Training_Form} ?
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
healyhatman 7
October 04 2018, 03:05 #380625
And that second read data action, how is it supposed to be related to the first one?
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
H
har7801 135
October 04 2018, 03:55 #380626
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)
232 Downloads/Views
Array.JPG
Array.JPG
(70.17 KiB)
231 Downloads/Views
Result.JPG
Result.JPG
(45.82 KiB)
240 Downloads/Views
healyhatman 7
October 04 2018, 05:18 #380627
*sigh* show me the view please.
Web developer at SkySpider.com.au - I DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
healyhatman 7
October 04 2018, 05:24 #380628
 1
 Answer
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 DO NOT work for ChronoEngine!
Donations: paypal.me/healyhatman
Professional Work: kamron@skyspider.com.au
Custom CF / CC Plugins and Extensions: skyspider.com.au/store
H
har7801 135
October 04 2018, 05:45 #380629
What can I say......I really over complicated the hell out of that one.
Thanks a tonne.