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

(Jerry Power) #1

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.

(Aleksi Alkio) #2

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

(Jerry Power) #3

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.

(Aleksi Alkio) #4

You can use LINKTOFORM deep link for this purpose.

(Jerry Power) #5

How does linktoform vary from view?

(Jerry Power) #6

ahhh I see.

Thank you.

(Aleksi Alkio) #7

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

(Aleksi Alkio) #8

You’re welcome :slight_smile:

(Aleksi Alkio) #9

Remove the [_THISROW] from the 1st one.

(Jerry Power) #10

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.

(Aleksi Alkio) #11

You’re welcome

(Jerry Power) #12

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.

(Aleksi Alkio) #13

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) #14

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 .

(Aleksi Alkio) #15

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

(Jerry Power) #16

Yes.

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

(Aleksi Alkio) #17

Are you able to take a small gif?

(Jerry Power) #18
(Aleksi Alkio) #19

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

(Jerry Power) #20

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?