webhook to edit record it that was just created

Before I get into Actions and Webhooks, may I ask why you don't just make this Unique Tracking number field be a formula field?

Forget about using webhooks or form rules for the moment and just describe how the unique tracking number is formatted.

This app was populated with a lot of old data from an Access Database that had it's own numbering system.  I use another field to determine if an old number exists or not. If an old number does not exist, than it uses the new auto generated number value with the Record ID. Below is a list of field names and what they do.

List of Field Names:
OId ARB # - this is a text field only populated if it was from the old database, blank otherwise
Auto ABR# - this is a formula field that concatenates Location and Record ID together
New True ABR# - this is a formula field that looks for a value in Old ABR #, otherwise returns Auto ABR#
ABR Number - this is just a text field that waits for the dynamic form rule to "stamp" the value in the New True ABR# upon save. This is my primary key.

You can use an Action to do this.  Action are what I like to think of as Webhooks for Dummies and I will take a dummies solution over complicated syntax any time I can.

But one trick is that on first look, it will not appear that an Action can edit the record that you are on.  I seems to only have functionality to add a record on another table or else edit "child" records.

But you can create a Report Link field type on the Record and connect the [Record ID#] on the left side with navigating to the same app, same table same [Record ID#] field on the record you are on.  That is allowed to be your Report link field for an Action.

Then set the Action to fire only when the [New True ABR#] changes and after the save the [New True ABR#] is not equal to the [ABR Number]

Give it a try.

Note also that the Action, like a webhook,  will fire a split second after the record has already started to re-display on the screen after a save.  So while initially it may seem that the action did not fire, in fact if you F5 refresh the screen in View mode, you will see that it did fire.

I'm trying to follow your suggestion but I'm coming up with a 400 error message so I'm trying to trouble shoot. I appreciate your explanation and you've solved my issue I found with the Action which you identified as the ability to add a new record or modify a related child record. I'm hoping to figure out my error and posting a success statement soon. Thanks!

I'm confused.  Are you using an Action or a webhook?  If an action, what is the explanation or the error 400 error code when you expand the box?

I built an Action and after saving a record I receive an e-mail with the following information -->

There's a problem with a webhook in the ABRs table.

Starting at 10:54 AM on 01-02-2018, webhook Quick Base Action #1 had the following problem:

400 Error: <?xml version="1.0" ?> <qdbapi> <action>API_EditRelatedRecords</action> <errcode>52</errcode> <errtext>Trying to import more than one column to the same field</errtext> <errdetail>You attempted to import more than one column of data into the same field:<BR/> &quot;ABR Number&quot;</errdetail> <num_recs_updated>0</num_recs_updated> <num_recs_unchanged>0</num_recs_unchanged> </qdbapi>

is your Action doing what the error message says you are doing?

Not sure, the data seems to be saved from the initial input on the form. The record isn't saving a second time so the [New True ABR#] isn't being pushed to the [ABR Number]. I'll dive into this tonight to figure it out.

After trying several different options, I'm able to get the QB Action to trigger and have it take the value in the [New True ABR#] and paste it into [Old ABR#] successfully. However, it's still not prompting the Dynamic Form Rule to modify the value in the [ABR Number] field. When I try to have it stamp the value in the [ABR Number] field, that is where it returns the error message I had posted previously. What's interesting is that the Action is firing after the Record ID is generated, so not sure why it's not triggering the Dynamic Form Rule.