Update filed in current record with text using automation

Community Discussions
, ,
1

Sorry if this has been asked before. I am new to Honeycode.
I am trying to create a button that updates a text field on the current record, to a new text value.

  • Created a detail form (for table [Tool])
  • Added a button
  • Automation On Click (want to change the value of [Reserved] from No to Yes)
  • Update or Insert Rows to [Tool]
    After that I'm totally lost (tried just about very possibility). I assume I'm missing something very simple.
    Any guidance would be appreciated.
    Thanks
2

It sounds like you want to use the Overwrite step, not the Update or Insert Rows step.

Try that, and see if it works for you. The Update/Insert step is really powerful, but probably also the absolute most confusing part of automations. :slight_smile:

3

Thank you for the reply. I have tried that too without success. I think I must be missing something very basic.
Should "Run step if this condition is met" be populated with a certain syntax? Also "run step for those rows"? (I was using =FILTER(Tool, "Tool=THISROW()"). I have the button that triggers the automation on a detailed record so I thought it would default to that record.

Thanks again

4

Made some progress. I removed the Run step for those rows. So it is supposed to update the Context Row, however it always updates the first table row.

5

Answering my own question for anyone struggling with the same issue:

The Block in which the Button is placed that triggers the action needs to have a Data Source (Block Properties) set to =$[InputRow]

2 Likes
6

@Harr-2fc1 nice work on figuring this out and welcome to the community! Keep us posted as you progress and drop in the community anytime for questions, content or suggestions. :slightly_smiling_face:

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.