About Krismar

Krismar · 05-15-2023

Still struggling to figure out how to do calculations in my inventory app.Short overview: I have a database table with all parts in my inventory, these are intended for assembly of different products.I have a table for each of the products where each...

Krismar · 05-08-2023

How to get the value from one table to another table with an action?I have a simple "form view" table where i can choose product and set the quantity for it.I want this quantity to be copied over to multiple rows in another table if the "product=prod...

Krismar · 05-03-2023

it seems like i'm not even progressing, but instead regressing.Can't get a simple action "on a set of rows" to work.First action is "Set the values of some columns in this row"which is "[Available parts] - [Required parts]"When i try to execute the a...

Krismar · 04-27-2023

i have two tables to calculate the cost of parts according to the assembly of the products."Products" table that holds all parts required to produce a product along with quantities (Stock quantity and required parts per product). "used parts" table f...

Krismar · 04-26-2023

I have encountered a problem with "Key" values. I understand that the KEY values must never change.Once a row is saved then it has to have a unique key value and stay that way.One of my tables has a column "Product ID" as key column but in the future...

Krismar · 05-08-2023

I do not want to add a new row.I need to change a value in an existing row with an action.

Krismar · 05-04-2023

Oh god, how am I struggling with so easy steps.Thank you a lot!The support page says nothing about the key column,"SELECT(from-dataset-column, select-row?, [distinct-only?])select-row? - A Yes/No expression, evaluated for each row of the data set, th...

Krismar · 05-03-2023

The point of the action is to subtract all used parts at once.

Krismar · 04-26-2023

As the appsheet help center says "We are sometimes asked if there is a way to make the key value editable. The short answer is No." then i will recreate the table.Some products have to be in the list but they do not have an ID yet, i will simply crea...

Krismar · 04-25-2023

Ok It makes sense now. It cannot refer to random column, it needs the KEY to identify the row. Sound so easy and embarrassing now. Also i had another mistake, I had to create a virtual column with dereference expression to pull the value from the ref...

My Stats

Krismar's Bio

Badges Krismar Earned

Recent Activity

Inventory management calculations

Copy values between tables via action

Action does not match the expected type

Inventory calculations

Changing key column

Re: Copy values between tables via action

Re: Action does not match the expected type

Re: Action does not match the expected type

Re: Changing key column

Re: Reference function