manitpulate tabel

[ruben-dw]

Hello
I'm trying to transfer data from one table to another

how i do this is as follows

i use this

Patch (lending beamer; Defaults (lending beamer); {product: product_beamer}; {'nmbs code': nmbcode_beamer}; {brand: brand_beamer}; {size: size_beamer})

this is to transfer the data from beamer to loaned beamer
the remove works
:
Remove (beamer;
First (Filter (beamer; DataCardKey_nmbcode_beamer = DataCardValue_nmbcode_beamer)))

when i patch i get this error
: The patch function has some invalid arguments

screen shot below for clarification

this is my code on the button that activates it

this is the table beamer

this is the table loan projector
here the data from beamer should come with the pacth function

this is the document where the tables are located

[WarrenBelz]

@ruben-dw ,

I am lost in what you are asking.

If you tried my code, what error did it give? You cannot patch one list referring to the defaults of another as you have done.

Can we get back to basics please - you are trying to patch the contents of collection uitleenbeamer to your list beamer as new records?

I will be offline shortly due to timezone.

[ruben-dw]

@WarrenBelz 

i can't patch
because the patch function doesn't see the variable: product_beamer
if I change this with a string the patch function works

i set my variables

like this :
Set (product_beamer; ThisItem.'product ') ;; Set (nmbcode_beamer; ThisItem.'nmbs code') ;; Set (brand_beamer; ThisItem.brand) ;; Set (size_beamer; ThisItem.size)

then I'll pass it on to the patch like this:
Patch (beamer; Defaults (loan beamer); {product: "string"}; {'nmbs code': "string"}; {brand: "string"}; {size: "string"})

if I change the variables by strings this function works

[ruben-dw]

@WarrenBelz 

how can I pass variables to the patch without problems?

[WarrenBelz]

@ruben-dw ,

The process is not the problem - variables will pass exactly as you have them. If you put a label on the screen with the Text product_beamer, is there a value in it? If not the problem is not the Patch, but the setting of the Variable.

So back to the setting of the Variable

Set (product_beamer; ThisItem.'product ')

where to you run this from? If from within a form or gallery, it should pick up the value.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.