Using Numeric up down with Select Record

I am extremely new so I appologize if this is an easy question. I want to have the user select which row the Headers begin in.

I put the number up/down tool in and it created the lightning bolt, but when I run the app and pick a number it doesn't change the value.

On the Select Record tool do I need to put a formula to tell it to grab the user input?

Apps

Preparation

Accepted answers

SeanAdams

Hey @z-one,

Sorry for the confusion - uploaded the files again - this time I've uploaded the package; and the individual macro too so that you can either use the package version or the underlying pieces.

The macro itself is very very simple - have a try, and if you have any issues I can post screenshots instead.

Hope this gets you to a solution

Sean

HeaderRowInput2-Just1Row.yxmc

TestMacro2.yxmd

TestMacro2.yxzp

All comments

SeanAdams

Hey @z-one - welcome to the community and congratulations on your first post!

This one requires you to use a few tools - I've provided notes; screenshot; and mocked up flow below:

- Take the input into the macro

- Use a formula to convert the up/down box into a field that you can use

- Filter out the rows that you don't need using a record ID and a filter

- Then take out the working fields (the header row ID; and the record ID) using a dynamic select. It's useful to use a dynamic select because that means that you don't need to know every field that this will be used for

- Then use a dynamic rename to rename the fields

Hope this helps - if it does, woudl you mind marking as solved - or if not, then let's iterate together to get you to a solution.

Happy weekend

Sean

TestData.yxzp

z-one

@SeanAdams wrote:
Hey @z-one - welcome to the community and congratulations on your first post!
This one requires you to use a few tools - I've provided notes; screenshot; and mocked up flow below:
- Take the input into the macro
- Use a formula to convert the up/down box into a field that you can use
- Filter out the rows that you don't need using a record ID and a filter
- Then take out the working fields (the header row ID; and the record ID) using a dynamic select. It's useful to use a dynamic select because that means that you don't need to know every field that this will be used for
- Then use a dynamic rename to rename the fields
Hope this helps - if it does, woudl you mind marking as solved - or if not, then let's iterate together to get you to a solution.
Happy weekend
Sean

Thank you for putting that together. So does the input tool not work with a record select tool or sample tool on its own? I thought that was the point of those tools (my thought is based on one week of playing around!).

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703