LINK TO FORM : Open a specific view to create a drawing on a existing photo

[GV]

Hi everyone, 

I have created an action which opens a form with this formula

LINKTOFORM("PHOTO_drawing" , "TODO",[TODO].[UNIQUE ID - TACHES],"PROJET",[PROJET],"PHOTO",[PHOTO],"INCLURE","TRUE","TYPE","TACHE","ANNOTER","TRUE")

The idea is to create a drawing on specific photo (with an underlying ID).

The action is working but it's creating a new line in the table Photo and I don't understand why. I would like to have the following behaviour

1) The form opens

2) I create my drawing on the underlying photo

3) My underlying ID in the Photo Table is modified

 

 

 

[mateo]

Hi @GV,

---

@GV wrote:

LINKTOFORM("PHOTO_drawing" , "TODO",[TODO].[UNIQUE ID - TACHES],"PROJET",[PROJET],"PHOTO",[PHOTO],"INCLURE","TRUE","TYPE","TACHE","ANNOTER","TRUE")

---

This formula leads you to the already existing record in your database?

When you use LINKTOFORM() formula it opens a form using values you declare in the syntax. Maybe you wrongly declare the key of the row you wanna update? Maybe try LINKTOROW() instead?

[GV]

This formula leads you to the already existing record in your database? -> No it creates a new record.

My behaviour would be to update the existing record, so I guess I should use Linktorow ?

Thanks, 

[mateo]

I think so, try LINKTOROW() like I mentioned above. It should work.