Random record selection from results after "Find R...

[CharlieMullin]

I have a pre-filled form that is launched from a button in a record in the Assets table. When the form is submitted, the automation is triggered. A new record is created in the Updates table. Then, there's a Find Record step where a condition is entered to find the record to be updated in the Assets table. Right now, I'm using the condition Today's Date.

That's fine for testing but what I really want to do is let the Find Record value be the record from the Assets table from which I launched the form in the first place using a button.

How do I refer to that Rec ID?

[TheTimeSavingCo]

Hm, if I were you I'd try:
1. Create a field in the "Updates" table called "Asset record ID"
2. In your prefill URL formula field in "Assets", prefill the new field from step 1 with the Asset record's "record_id()" value

This way the submitted "Updates" record will include the record ID of the record from the Assets table which you clicked the button on, and you can use that record ID for your search

I'm not entirely clear on the use case, but you could also just link them together directly too?

[jsep]

Adam's solution should work, and you can also hide the "Asset Record ID" field in the form since it is for your use only.

To pre-fill form fields, follow this guide: Prefilling a Form via Encoded URL

To hide the "Asset Record ID", use the visibility rule with two conditions, as shown in this screenshot.

If you need help implementing this solution, fell free to schedule a free call with me.

[CharlieMullin]

Hi Adam, I pretty much had the tables set up with the Rec ID available and I've now added that Rec ID field to the pre-filled form. But I'm still stymied about how to point to the Rec ID value in the Automation,

Shouldn't I be able to set a condition that refers to that Rec ID value? in the Conditions section above I can only add a string as opposed to a value in a field.

I'm sure I'm missing something fundamental. I do need the Find Record step, right?

[jsep]

@CharlieMullin  you have to dynamically filter the record using the form's "Asset Record ID".

Like this:

I hope this helps! If you need help implementing this solution, feel free to schedule a free call with me.

[CharlieMullin]

Totally forgot about selecting Dynamic to present the fields. Thanks for that.

Now I'm getting this error:

Not sure what that means. Asset Rec ID is a short text field, so should be OK. Here are the two relevant fields:

Asset Record ID was submitted via the pre-filled form. Original Asset Rec ID has a formula to fetch its value from a Rollup field that contains the Rec ID from the Assets table. You can see that those values match (the last three records.)

Thoughts?

[jsep]

Sorry I don't see the error in your reply.

Feel free to schedule a free call with me, and we'll make it work.

[TheTimeSavingCo]

re: Shouldn't I be able to set a condition that refers to that Rec ID value? in the Conditions section above I can only add a string as opposed to a value in a field.

I'm sure I'm missing something fundamental. I do need the Find Record step, right

Yeap, you need to set a condition to refer to that value and you do need the Find Record step.  In your "Assets", create a formula field called "Record ID" with the formula `record_id()` and use that in your Find Record step.  Specifically, the Find Record step will look for records in "Assets" with a "Record ID" value that matches the value of "Asset Rec ID"

--
As an aside, I'm kind of curious what the formula is for the field "Original Asset Rec ID".  Not related to the stuff I mentioned above mind you, I'm just wondering how you set that bit up

[CharlieMullin]

Hey Jsep, here's that missing screensot with the error:

See the Filters error msg at the bottom.

[CharlieMullin]

Here's the Original Asset Rec ID properties: