topic Re: Return a field from one column by other column name like somthing in App Development

Return a field from one column by other column name like somthing

HAMID_AKBARI — Sat, 07 Jun 2025 16:36:31 GMT

Hi Community

i have database of diffrent Equipments and their Technical Specifications.

Unfortunately the data Specification Entities are not equal by name eg

sometimes maker company Entered "manufacturer" and sometime "Manufactured By"

The DB structure sample is attached

Now the Problem:

I want to create a panel that user select an Equipment and the the spec value shown in text box.

Infact need a script that Return "SP_Value" that "SP_Description" Like "Manufact" for text box one and

Return "SP_Value" that "SP_Description" Like "Date" for textbox two and .....

Re: Return a field from one column by other column name like somthing

rubenmarin — Sun, 08 Jun 2025 09:05:21 GMT

Hi, the expression could be:

Manufacturer: =Only({<SP_DESCRIPTION={"*Manufact*"}>-<SP_DESCRIPTION={"*Date*"}>} SP_VALUE)

Date: =Only({<SP_DESCRIPTION={"*Date*"}>} SP_VALUE)

But I think it would be easier if you solve it in script, apply a mapping so it converts all differnt values to the same, also you can convert the date values to something that doesn't have the 'Manufact' word in it.

Re: Return a field from one column by other column name like somthing

HAMID_AKBARI — Sun, 08 Jun 2025 16:01:32 GMT

Thats it.Very nice.Thank you