Jump to content
  • 0

Triggered action on insert: Get 'GUID' type of inserted record to update other table.


Gilmay

Question

Hi,

Is there any way to get the value of a GUID (table field) of an inserted record in the main table and insert this to a child table?   I want to do this in a triggered action on 'insert data' event on the main table.

Issue: The field in the child table remains empty after the action has been triggered. (other fields are inserted just fine)

I suppose this is because the record hasn't been written to the main table yet when the triggered action is run, so the GUID does not exist yet.

Is there any way I can work around this?  

Thank you.

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hello @Gilmay,

If you want to insert data into a child table based on inserting data in the parent table, selection from #inserted should work.

On my side, the ID value generated automatically when the new record is inserted is passed by the Trigger successfully. 

Could you share a screenshot of your Triggered Action? 

 

Q37BzLW.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...