I apologize if this has been asked before. I...

Jerry_Power
Participant III

I apologize if this has been asked before.

I looked and could not find anything quite like it, but know I have seen it asked.

I have a little store keeper app.

Disc golf players pay in a small fee to play in a small event referred to as a mini.

Winning players get a credit that they can trade in for merchandise.

The store keeper selects a record to show how much a player is to be debited.

However I only allow add.

So the new record starts as a new record.

What I would like to do is have the new record start with the playerโ€™s name and show the total winnings to date.

Is there anyway to change the view on an โ€˜addโ€™?

And if I do so, is there anyway to grab the selected record Player Name?

Thanks in advanced.

0 19 323
19 REPLIES 19

You could show the total winnings with the Show fieldโ€ฆ then view change would not be needed. Would that work for you?

Jerry_Power
Participant III

Yes and I am unsure how to populate the user name to match the selected record.

It is adding a new record when a record is selected, which is what I need.

I was trying to determine if the selected record player name could be caught and inserted into player name in the add.

You can use LINKTOFORM deep link for this purpose.

Jerry_Power
Participant III

How does linktoform vary from view?

Jerry_Power
Participant III

ahhh I see.

Thank you.

You can copy as many values as you need when you trigger that LINKTOFORM action from the row.

Youโ€™re welcome

Remove the [_THISROW] from the 1st one.

Jerry_Power
Participant III

I should quit typing and think first.

Figured out my mistake by looking at an example.

I took out {_THISROW]. and it works fine.

Thank you again for the help.

Youโ€™re welcome

Jerry_Power
Participant III

I use group to show the players and their totals, but when I select a record I want to pull that name across to the added record.

I would also like to show their totals, but I cannot figure how to use Show field in an added record view.

You probably know the playerโ€™s name when you choose it. Then you just need to calculate the winnings for that player. Basically some kind of sum formula likeโ€ฆ

SUM(SELECT(TableName[WINNINGS],[PLAYER]=[_THISROW].[PLAYER]))

Jerry_Power
Participant III

I am not sure i am making myself clear, but I want the new record to pull the player name across when I โ€˜addโ€™ by select a record.

I do show the sum by using a group by .

Do you mean you want to grap the playerโ€™s name from the list when adding a new record for that player?

Jerry_Power
Participant III

Yes.

Is there a way I can show you the app so you see what I am talking about?

Are you able to take a small gif?

Jerry_Power
Participant III
 

Soโ€ฆ you have an action behind that table and when you choose that record, it will open a new form view. Correct?

Jerry_Power
Participant III

If I use the following:

LINKTOFORM(โ€œDebit Pageโ€, โ€œPlayer Nameโ€, [_THISROW].[Player Name])

it does not fill in the player name.

If I use the following:

LINKTOFORM(โ€œDebit Pageโ€, โ€œPlayer Nameโ€, โ€œClint Hollyโ€)

It puts Clint Holly in for the name.

Am I missing something?

Top Labels in this Space