Data entry

Copper Contributor

Hi,

I have a datasheet with measuring data named “Measures”

Each measure, among other, contains a “Parameters” field as you can see in the following screenshot.

bandicam 2022-03-15 18-08-50-532.jpg

The “Parameters” field is a string that comes from another sheet named “Params”:

bandicam 2022-03-15 18-02-37-737.jpg

What I need, is a form that will allow the user to enter data in the "Params" sheet for the selected measure on the Measures sheet and create a string from these data to fill in the Parameters field

Could you please give me some guidelines on how I can do this?

4 Replies

@george1685 

In K2:

=TEXTJOIN(", ";TRUE;IF(Params!$A$2:$A$1000=C2;Params!$B$2:$B$1000&" "&Params!$C$2:$C$1000&" "&Params!$D$2:$D$1000;""))

If the Params sheet has more than 1000 rows of data, adjust the ranges in the formula accordingly.

Then fill down.

Hi,
Thank you for the tip however this is not what I am looking for.
I need an efficient way to enter data into the 'Params" datasheet while viewing the "Measures" datasheet, there is a connection between the two tables using the "Measure" field (the yellow highlighted)
Maybe creating a data type within Power Query would do what you want?
I am not experienced using Power Query and there are many online courses on this topic.
I cannot decide if any of these fit to my needs.
Any link to specific resource for the above will be greatly appreciated.