Database insert: set value to two posted fields added together

Wappler General Need Help
1

I have a form which has two input fields. In my server action I’m using the Database Insert and I want one of the fields to be the two posted form fields added together, eg.

{{$_POST.field1}}+{{$_POST.field2}}

It seems to be storing the value in $_POST.field1 and ignoring the rest.

How should I be doing this?

2

{{$_POST.field1 + $_POST.field2}}

2 Likes
3

Thanks @s.alpaslan. I’d already tried that and it didn’t make any difference.

Just to be clear, field1 and field2 contain numbers and I want to add them together and store the total.

4

Can you share screen shot with us ? Maybe you have different issue

5

No problem. I can see that it should work as it’s showing as an operation (see screenshot).

39
Screenshot 2019-01-13 at 20.12.39.png1080×1356 67.9 KB

I’m on the very latest version in case that’s relevant.

6

All Global input variables are strings initially. So if you want to do math - you have to convert them to numeric first

image
image.png1133×678 51.8 KB

so in your case it will result in something like {{$_POST.field1.toNumber() + $_POST.field2.toNumber()}}

1 Like
7

Also if you expect them to be numeric, always define them with validation:

image
image.png362×651 15.2 KB

So a nice validation error is reported if somehow a different type of field is passed - and not some weird database error when you try to store them.

8

Yesssss!!! Perfect. That was the step I was missing. Converting to number fixes it.

Huge thanks to both of you.

1 Like