Solved: Auto focus on desired row

reggieneo · 11-17-2020 06:49 PM

Hi All,
is there a way to set-focus the cursor to the desired field with settings or expression/ action?

say: when the row of a column is already filled then the cursor will go to the next desired field skipping others.
thanks

Marc_Dillon

My bad, missed the de-ref period

View solution in original post

Marc_Dillon

Not exactly. But there is the auto-advance option (shown in screenshot below) that will move the cursor to the next field once the previous is filled out. If you need to skip certain fields, then I believe if they are dynamically hidden by show_if expressions based on previously filled fields, then the cursor will jump to the next non-hidden field.

reggieneo

set on already thanks much for reply.

Steve

Nope.

reggieneo

thanks, Steve/Matt. would be nice to have it.

in relation to my aim on this, can I ask how can I count or know what is already selected even If I do not save the parent record yet?

child table has 3 items in the list of options to select. I want to pre-select the item in the sequence.
my expression won’t give me the exact sequence.

IFS(
[Latest Timestamp].[Product Name]=“Diesel”,“Premium”,
[Latest Timestamp].[Product Name]=“Premium”,“Unleaded”’,
[Latest Timestamp].[Product Name]=“Unleaded”,“Diesel”’)

Marc_Dillon

None of this makes much sense. Please elaborate…a lot.

reggieneo

Hi Marc,

I have a parent table and 3 child tables.
one of the child tables has to be filled with 3 products’ details i.e Diesel, Premium and Unleaded.
If Diesel Details is already filled in, I need to be able to see the Premium Next after I saved the Diesel Details.

Parent :

Child (Disptick & Sales)
In this view, I should be able to see the Product Name, “Diesel”.

After Diesel is saved, I need to click the add button to add the next Product Name which needs to be “Premium”

“Premium” should be automatically next.

.

I am currently using the IFS expression in my Product Name Column but I can’t track the data of each detail I have already inputted as they are not yet saved in the spreadsheet.

Hope I have elaborate enough. thanks so much.

Marc_Dillon

I don’t know if this is true or not, but lets try this in the Initial Value field for Product Name:

SWITCH( COUNT( [ref-column-to-parent][DipStick & Sales] ) ,
0 , “Diesel” ,
1 , “Premium” ,
2 , “Unleaded” ,
“Diesel” )

Marc_Dillon

My bad, missed the de-ref period

Steve

Or:

ANY(
  {“Diesel”, “Premium”, “Unleaded”}
  - [Dipstick & Sales][Product Name]
)

Marc_Dillon

Great idea @Steve. I think you’d have to do it like this though, unless I’m missing something?

ANY(
  {“Diesel”, “Premium”, “Unleaded”}
  - SELECT( Dipstick & Sales[Product Name] , [parentRef] = [_THISROW].[parentRef] )
)

Steve

Yep, good catch!

reggieneo

not sure if I this is the [ref-column to parent] that I need to use here .
I have taken the Parent Key ID but given me this error:

Tried this too:
SWITCH( COUNT( Order Details[Product Name] ) ,
0 , “Diesel” ,
1 , “Premium” ,
2 , “Unleaded” ,
“Diesel” )

but it constantly giving me the “Diesel”

Marc_Dillon

This should be the column in your child table that is a Ref type column pointing at the parent table.

reggieneo

awesome!
this has confused me for quite a while.

thanks