Multiply a field with a database entry

Hello,
I’m currently trying to multiply a field with a value from the database and display the result in an input field. Unfortunately I can’t get it to work. can you help me or is there a tutorial somewhere?

quantity*value from database = result in an input field

Hello,

Do you want to display this result as the initial content of a input field?

yes.
i try to make a offer form.
i have a database, offers, offerpositions, products and setup.
i grab with a searchfield my product form db:products then i have the product informations in my offer form in my case i have two fields with purchase price and selling price.
now i want to multieply the purchase price with my value from the db:setup to calculate my selling price.

Step 1
First make sure both fields ‘purchase price’ and value from ‘db:setup’ are of number format (do let know if its text)

Step 2
Change content format of input to Integer

Step 3
Add dynamic data in the initial content of input. Next select * from more
image

Step 4
Add next value from db:setup
image

Hope this solves your issue!

1 Like