Can't seem to get to next record in portal

[RodM]

Can some look at my code..

I have in view 2 records in my portal

Attach 2 images 1 looking at userlayout screen

other is the code to print or combine format of invoice to single field.. The green screen on very right.. is missing the 2nd or $40 item

Code on right resultant only showing the 20$ item from portal first line as seen at green right most screen.. missing the 2 record? ...I am learning by doing.. stepping through its not looping back . fyi, my portal records are not sorted.. (want them in order entered)

TIA Rod

[bcooney]

I'm really not following your script, sorry.

However, an invoice should be printed from the child table. Use Go to Related Records match on OrderID and design a print layout in your line items table.

[RodM]

Thanks for your reply..

My invoice screen is okay.. It not a print thing..

When i click post. the the code enclosed

I am only wanting to get the records in the portal and stuff them all in one field (the green filled field) ..as my image suggest.. but looking at the green screen I am missing the 2nd portal line..

I am trying to loop the portal records.. extracting the line items to the one field.

[bcooney]

"I am only wanting to get the records in the portal and stuff them all in one field"

WHY?

Have a look at the List ( ) function.

[RodM]

Because the complete application is derived around 1 message text filed system.. not inventory items All the paging, faxing and other items search etc is coded for that way.

It is my telephone answering service application - several years running. Very complex (www.mastar.com) ..I cut this new app.. not set for few inventory item.. for this application inventory items are a minimum anyways..

so I have found doing it, to pick from a pull down.. adding rec in a portal. such as this.. so not to redesign I am format back the items to a single field again... and thus not have to redesign the single message field ( answering service only take a single message or multiple of..) you asked.

Can I using this LIST function, to list to var.. each of 2 records as my shown in my portal to .. then parse the data to my likening?

I am adding items to my portal child file.. they are related to Account,, then my client and my MSGOrder file.. then use this portal add OrderItems where as I append orders.. Inventory is 4-20 items

What you see is 2 orders items attached to the

I have several calc field to add subtotals that works..

[RodM]

First time to use, the list function.. Now this command differencce just saves to separated by returns

Unlike the Set Var inside my loop.. that jumped out of the loop..

..the Portal next record increments.. 2 time for 2 records showing....seems to work BUT some how its only getting 1 first record twice..

( See green window single field on right again ) ...and my 2nd item ($11.00) in the portal is being missing?

THEN I added a 3rd record item to Portal...

My loop only increment 2 time, the 3rd record showing in portal did nothing extra.

[bcooney]

What if you created a text calc field in your child table:

FullLineItem = Desc & " | " & Cost & " | " & Amount

Then used List ( relationship:FullLineItem) for the green area?

[RodM]

I am running fm9pro

Is the relationship: for fm10?

(have moved to due to the app.. for the moment)

tried, got error entering:

List relationship: (Order Items::order_acc_inv;Order Items::order_acc_description ;Order Items::order_acc_cost;Order Items::order_acc_qty;Order Items::order_acc_subtotal )

What i am learning from this is... Portals are fine for displaying data , but limited to, not as manipulative, for as simple as my 3 stupid records I can't read the data to a variable ..

maybe NEXT, i need to get out of the portal and actually open a layout of the other file where my portal field are coming from..

thanks for your replies..

[bcooney]

What if you created a text calc [color:purple]field in your child table

[RodM]

Thanks... got it.. opened up my Order child set a find condition on orderID.. as you suggested b4.. found my 2 records. loop works and was able to build by single field DONE..

may i ask one other item pls.. I can format $00.00 find in a layout... when I get my $10 What function do I use to store it in correct format?

Rod

[bcooney]

I don't understand why you need a script at all! You build a calc field in the child table and a use List ( ) in the parent. No scripts are necessary.

In the child table, the concantenate calc field can contain "$" & Cost.

Demo attached

GrabPortalData.fp7.zip

Edited September 1, 2009 by Guest
added demo

[RodM]

Hopefully I can ask this here..

Parent layout I have Portal

Records in portal are related to 'OrderItems'

Desc, Cost, Qty fields

Field Desc, (text field) uses a Popup list to pick Decr from Child inventory Desc, Cost,

MY PROBLEM is selecting the Desc within popup

is not triggering my script in debug

[RodM]

I thank you.. I did it one way..it work but

I like your more elegant way.

I am cutting in yours

thanks for the example.

[RodM]

Thanks with your followup continuing to answer my quest again... lol,, i spent alot of time.. and learned while doing.

Got your like code working now within my code.. got another situation within OUR code... and its sometime harder trying to explain it to someone else..

In OUR portal -the Desc field I have a List from my Inventory File that pullDowns text name 'Apples, 'Oranges 'Peaches.

we had the price..

I like to populate the cost field automatically something I see done.

I posted a topic below... image attached

trying to use that trigger ZippScript..

To fire a script stuffing the cost field

Can't seem to get the script to fire.. in Debug mode

Any idea or is the another way..

Other topic posted here.. same quest above

09-02-09 07:37 PM - Post#339770 Topic Triggers

[bcooney]

You would want to define the Cost as a number field with the lookup entry option from the Inventory table when the Inventory ID in the portal row record matches the InventoryID in the Inventory table. I would not have a desc in the portal row, but rather use a value list of IDs that also show a second field, the desc.

You do not need any script triggers.

[RodM]

Ok.. you said to use the cost to create list.. When I click it.. I see inventory Cost + Decr (2nd field)..

Seem to think if I want to list or show Decr then cost.. I have my list on the desc, then 2nd filed be Cost?

Can't figure how i get the Dec + Cost fields to fit into the order code we worked on// I suppose i need another calc in Order

I am sorry... I must be missing something

[bcooney]

"Ok.. you said to use the cost to create list.. When I click it.. I see inventory Cost + Decr (2nd field).. "

No, I did NOT. Your row should have an Inventory ID.