Fidelity Cards

[Khamadohn]

Hello, i have a table with [Data Ora] (the KEY), [ID] ,[Nome Cognome], [Saldo], [Importo], [Nuovo Saldo] and a NFC card with the ID written inside.
When i scan the NFC with the app, i get Nome Cognome(Name and Surname), and Saldo (how much money are there on the card) because the informations are stored in the table.
[Importo] is how much the customer pays and [Nuovo Saldo] is the updated [Saldo].
Now, when i scan again the NFC card i need the [Saldo] to show the informations from [Nuovo Saldo].

To make it easy, a customer's [Saldo] is 50€, he pays 5€ ([Importo]) so [Nuovo Saldo] is 45€, next time i scan his card, his [Saldo] should be 45€.

I've already read all the functions' articles but i can't make it work.

[Joseph_Seddik]

You can create a Behavior action to update the column "Saldo" with [Nuovo Saldo], and make this and set it as the Form Saved action for your form. 

In this way, each time your form is saved, the "Saldo" value will be updated and ready for the next scan. 

[Khamadohn]

How do i make the action change the [Saldo] from that specific customer?
I can't find the right expression

[Joseph_Seddik · Accepted solution]

Your action will be associated with a specific row in your table, which is the row being edited by the form, both columns exist in the same row, so you don't have to do anything else. 

Here are the settings of your action:

• For a record of this table: tableName
• Do this: Data: set the values of some values in this row
• Set these columns:
  
  • Saldo: [Nuovo Saldo]
     

[Khamadohn]

It does not work 😩 [Saldo] always stores the same number.
Is there any information i can give you to help you help me?

[Joseph_Seddik]

Can you please post screenshots of what you've done? Thank you!

[Khamadohn]

I've been very busy but i managed to make it. Thank you!