Forum


List Manager Support

List Manager support
Forums
Public write access is disabled. Please login

Lookup List 11.03.2021 16:07

Hi, I need to know if the following is possible:

I want to create two lists:
1. Staff Name List
2. IT Asset List

I want to capture (import) all staff members' name to the Staff Name List, and also capture all IT Assets (computers) with their serial numbers to the second list.

Then I need to assign an asset to a staff member with a lookup field. If the staff member resigns, the asset should be reassigned to somebody else.

Is there a way I can create a field in the Staff Name List that links with the IT Asset List's serial number? I used to do this a lot back in the day when I programmed in PAL (DOS version), so I guess it should be possible, but do not know if it is an available feature in the List Manager software.

Regards,

Francois

Edited by sandvelder - 11.03.2021 16:07

Re: Lookup List 12.03.2021 09:36

Hi,
this is not a built-in function of the extension, but you can create such a field using this configuration, here the steps:
- Go to your Asset List->Fields, and check the serial number field. Get the ID number of this field (the first, non-editable parameter you will find on top). Let's say is number 5.
- Go to your Staff List->Fields, and create a new field, type 'option list' and click 'SQL actions' button from Multivalues section.
- Insert this query at the free textarea:
select value,value from #__listmanager_values where idfield=5;

(using the proper field number from above)

Save the query and the field configuration. You should get an option list to choose that will show the serial number from the other list.

With this type of field, you would be able to configure the
Link to other table
as well, in case you want this field to link with the other table using this key field (for ex if you want to see the details of the IT Asset record assigned , this option will create a link at the cell that will show the secondary table 'assets' already filtered by this serial number). Please let us know if you need further details about this option.

Thanks, regards
Moonsoft Team

Edited by MSTeam - 12.03.2021 10:44
Moonsoft Team
www.moonsoft.es

Re: Lookup List 14.03.2021 11:43

Thank you, but I am still battling with this. I followed the above instructions and it created a text area where I only need a text string.

Re: Lookup List 15.03.2021 09:30

Hi,
please double check you have selected the right type for the field at your Staff Name List . It can't be a free text area if you want to link it to another table, it needs to be an 'option list', so you can configure the proper sql query and get the right values.

If following above steps you can't make it work, you can place a private ticket at the helpdesk sharing an access and we'll take a look at your configuration.

Thanks, regards
Moonsoft Team
Moonsoft Team
www.moonsoft.es
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Our clients' feedback