Updating Column values from user input

[Oblivion_05]

Hi, I'm looking to take a numerical input from the user and then multiply that input with each value of a particular column. Any Idea on how to carry out this operation? I'm trying with action but it's not working
@Steve @Suvrutt_Gurjar @WillowMobileSys 

[Arni_Kli]

Hi,

in table:

1. Make column named "Input" (for example) of number or decimal type without formula.
2. Make column named "Value" of same type.
3. Make column (or virtual column) named "Result" of same type with formula:

[Input] * [Value]

 4. Make form with "Input" column and give this view to user.

No action is required for this. Did you ask about this?

[Oblivion_05]

That's actually helpful. But let me tell you the complete business context:
Suppose I have a budget column and vendor column in my table. Now say I want to reduce my overall budget to 80% of earlier. So I want the user to type 0.8 and change the entire budget column value to 0.8*budget. For this I felt action will be required. What are your thoughts on this?

[Arni_Kli]

@Oblivion_05 ,  you can make 3 columns:

1. base budget
2. proposed index of base budget for user input.
3. result

In [Result] column in formula field you can check [Base budget] column:

IF(
  ISBLANK([PROPOSED INDEX]), [BASE BUDGET],
  [BASE BUDGET] * [PROPOSED INDEX]
)

[Oblivion_05]

With this function won't I be getting an element wise Result. Like I want to take a single input 0.8 and multiply it with all the vendorwise budget values, say [Result] = 0.8*[Budget].
With your function I see that the user have to input [proposed index] for all the vendors like, [Result_1] = [proposed index_1]*[Budget_1], and so on....

[Arni_Kli · Accepted solution]

@Oblivion_05 , in this case you can use another simple table with this index column. Then make action and button with input() function and add to group an action of writing to another table (budget) to each or selected rows.

[Suvrutt_Gurjar]

Hi @Oblivion_05 ,

Please ask such questions in the " Q&A" section.

" Tips and Trick" section is meant for sharing workarounds or doing innovative ways of some app functionality. 

[Oblivion_05]

Sure @Suvrutt_Gurjar , I will post it over there as well with a link to this conversation

[Suvrutt_Gurjar]

Thank you @Oblivion_05.

You need not create another post. You can request the community managers to move the post to the "Q&A" section.