Hi all
I’m trying to pass data from one table to another.
Table A has a price field which I want to be populated in price field in table B.
Both tables have a customer number to link.
Using behaviors how can I pass this data to the existing record in table B and update the price field?
Thanks for you help!
Try with this function:
Thanks for your help.
I have been playing with this for several days and cannot seem to get it to work as I want.
I have a cost field in my quote table “Sales Cost” which I want the value to update to my Customer table to field “Contract Value”. I have a behaviour button which is “Quote Accepted”, which updates the date accepted and status, but as part of this, I want it to then transfer the value from “Sales Cost” to “Contract Value” for the customer.
Is there any other suggestions that I would follow?
Thanks in advance.
Did you try to implement the actions with INPUT()? If so, what is the exact problem you’re now facing? If you could show what have you tried and the result it gave you vs the desired result, the Community could help you better.
Thanks Joseph for your response.
On the Quote table, in the view I have the value I have in my behaviour button as: input [UNIT ID].[Contract Value],[Total Cost]
I receive no errors and the routine will run and complete all the other parts of the columns that I have set, ie., “quote status” to “True”, however, the contract value field in my table “unit” still is blank after being run.
I’m not sure about your expression. Did you follow the reference doc? Woyld you please post screenshots of the actions?
(Total Services and Onboarding = input [UNIT ID].[Contract Value],[Total Cost])
This is what I have on my behavioural button. When it is clicked, I want in table [unit], field [Total Cost] to be populated with the value from the table [quote], field [Total Services and Onboarding]. The button is on the quote page.
You are using it wrong. Please read the following guide carefully:
I have read the documentation of the input function and using the example given in the document, I can get the function to work. However, what I need is no user interaction (ie, input box), what I want is it to transfer the value of the field to an alternative table and field.
Is the use of the input expression correct? Would you suggest an alternative expression?
Please read from point nº 2 in the guide. It specifically gives an example where the value is updated by actions not user’s input.
It is not about the expression, you have to create two separate actions following exactly the steps in the guide.
