execute a sequence of actions

[John_Henry_Jose]

I have two individual actions one for "Issue" and another one for "Return".

I need to have group action. when I execute "Return", immediately after executing "Return", the "Issue" action should work.

Issue Code LINKTOFORM("Tbl_Issue_Form", "SerialNo", [_THISROW].[SerialNo])

Return code LINKTOFILTEREDVIEW("Tbl_Return_Detail", ([SerialNo] = [_THISROW].[SerialNo]))

If I click "Return" action, the system should execute "Return" and "Issue", because the item's destination should not be blank.

Any idea how it should be.

Thanks.

John

@WillowMobileSys @Steve 

[1minManager]

Not sure exactly what you mean.  But if you use LINKTOFORM() or  LINKTOFILTEREDVIEW() in a "execute a sequence of actions" then the action will terminate at this step.  Any following actions wil lnot be completed.

[JuneCorpuz]

Why do you need LINKTOFILTEREDVIEW() and LINKTOFORM() in a sequence? Can you please explain what you are trying to achieve?

[John_Henry_Jose]

I have a Master Table for all Items to be managed with a key field "SerialNo". with below structure with few virtual columns.

SerialNo

LGGroup

Description

OEM

Length

Capacity

Size

TPInspDate

TPDueDate

CertificateNo

Certificate

Status

Condition

Comments

Photo

Modified By

Modified On

I have transaction table to record issuance and returns with below structure with few virtual columns. and two slices 1. Tbl_Issue and 2. Tbl_Return.

TranMasterID

IssueDate

Destination

Serialno

Condition

Doc No

Remarks

Issued By

Issued On

ReturnDate

RCondition

RDoc No

Damage Photo

RRemarks

Received By

Received On

I have form view to issue an item, which will fill from "TranMaterID" to "Issued on".

I have an action to "Return" with  LINKTOFILTEREDVIEW("Tbl_Return_Detail", ([SerialNo] = [_THISROW].[SerialNo]))

I want this action to execute "Return" which will update the existing row. and "Issue" action to create a new row in the TranMaster Table.

Is it possible? it is makes sense.. because the coordinator, once return the item, he may forget to issue the material to store immediately. I want system to take control to issue the material to store.

[allanfocker]

Do you want the return of this issue only?

I dont know the structure of your db but ill assume that the tables return and issue are related

LINKTOFILTEREDVIEW("Tbl_Return_Detail",
AND(
[issue id]=[_THISROW].[issue id],
[return id] = [_THISROW].[return id]
)

)

This is what I think you want an action that gets you a row that complies with 2 conditions 

 I hope this idea helps you

[Steve]

---

@John_Henry_Jose wrote:

I want this action to execute "Return" which will update the existing row. and "Issue" action to create a new row in the TranMaster Table.

---

Neither of these two requirements involve the use navigating to views within the app. The LINKTO...() functions are used to navigate within the app. The LINKTO...() functions are therefore inappropriate for your stated needs.

---

@John_Henry_Jose wrote:

"Return" which will update the existing row

---

For this, you'll need to use an action of type Data: execute an action on a set of rows to invoke a second action of type Data: set the values of some columns in this row to update the desired column values of the row in the Tbl_Issue_Form table. 

---

@John_Henry_Jose wrote:

"Issue" action to create a new row in the TranMaster Table

---

For this you'll probably want to use an action of type Data: add a new row to another table using values from this row.

[John_Henry_Jose]

---

@Steve wrote:

---

---

---

@John_Henry_Jose wrote:

"Issue" action to create a new row in the TranMaster Table

---

For this you'll probably want to use an action of type Data: add a new row to another table using values from this row.

---

By using Data: add a new row to another table using values from this row, how I will get the below values without form as I need get this information from user.

Accept as Solution

[Steve]

Your problem descriptions have been confusing and inconsistent. If you need user input, then, yes, use LINKTO...() with a navigation action.

[John_Henry_Jose]

Sorry. But anyhow what used before (LINKTOFORM and LINKTOFILTEREDVIEW) are correct and in this scenario I can't use grouped actions.

Thanks lot.

John