i need to have an action, open a form to add ...

[Steven_Jeffery]

i need to have an action, open a form to add a service record for a specific piece of equipment.

How do I do this, and what is the expression to do so?

[Aleksi_Alkio]

You can do that with the LINKTOFORM deep link action.

[Steven_Jeffery]

that never works for me. how do I write that?

[Steven_Jeffery]

LINKTOFORM(“Customer Service Call Add”,“customer view site equipment”,[SITEeq_id])

This is still just opening the form, with a unique PMtask_id.

But not prefilled to put that task association with the company.

[Aleksi_Alkio]

You can construct the LINKTOFORM expression with pairs. Like there was in my sample. Instead of using [Equipment], you can use expression as well if you need to read the value from another table. You can add as many pairs as you need. You could fill all columns if needed.

[Steven_Jeffery]

I can get it to open a the form, but not with the current row or information.

meaning it simply opens the form, but without the current piece of equipment it is attached to.

[Steven_Jeffery]

I need to _thisrow function in somehow right?

I will get the expression that opens the form, but is missing the row info and you can tell me what is wrong.

[Aleksi_Alkio]

What expression have you tried?

[Steven_Jeffery]

LINKTOVIEW(“Customer Service Call Add”)

ok, this opens the form, but it is a generic form.

it does not have the specific equipment data populated.

If I hit the (Add New) it opens the form, but with it tied to the equipment.

I then put in the rest of the information associated

with the tasks for the specific site piece of equipment.

[Steven_Jeffery]

LINKTOROW([PMtask_id],“Customer Service Call Add”)

This works to open form, but it is opening the form that is already filled out.

Basically to edit it.

[Aleksi_Alkio]

LINKTOFORM(“Customer Service Call Add”,“Equipment”,[Equipment]) will open the form with prefilled value from the record you opened it. If you need to open any specific Equipment, you would need to write it like… LINKTOFORM(“Customer Service Call Add”,“Equipment”,“EquipmentName”)

[Steven_Jeffery]

This is the key to my Site equipment table [SITEeq_id], this is the key to the individual tasks that are added when we do a service to the equipment [pmtask_id]. what do I put where in the formula you suggest?

[Steven_Jeffery]

Site Equipment’ is the name of the table and PM Task is the name of the table for the tasks.