SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
1,805 questions
Yes, The form connects to a SharePoint list. The field types are a asset tag multiselect field that links to a lookup data source on SharePoint. Imported values are ID and Asset Tag,
The second field is an infopath calculated field that has the calculation above. The setup is a multi-select field where the asset tags are select and based on the asset tags selected the serial numbers will populate based on the asset tags selected. I'm able to get one serial number when one asset tag is selected. But I want to bring up several serial numbers based on the asset tag selected.
@Rob2021 ,
Form your description, I customize the list form, however,how do you use the lookup data source from SharePoint in Multiple-Selection list box?
Per my test I use the single line of text field type from list:
In addition,what's the relationship between asset tag and serial number? Please feel free to reply.
The asset tags is a separate list, called the asset list. It contains all the camera assets. On the main list where the infopath is created, there is a data connection for the camera assets. There is two data connection. One is for the asset tags and the other is for the asset items.
@Rob2021 ,
How do you get one serial number when one asset tag is selected?
If you provide as many information or steps as possible，I could test it for you.
The setup is as such. One main list, Then a second list with a look up column for the asset items that include, Asset tag, Serial number, model number and such. Then on infopath, create a form on the main list. Then add the lookup column as a multi-selection type to only show the asset tag, Make sure to have two data sources for the lookup. One for the Asset Tags and one for the Items. So Data source with ID and Tag and the other named. Asset Items that will import serial numbers and models and such. I'm able to display one serial number at time, Based on the asset tag selected, But I need to be able to have to display more than one serial number if I choose more than one asset tag.
The calculation is entered on a calculated field.
@Rob2021 ,
Thank you for your information.
Per my test I have the same result with you, currently there is no such way to meet your requirement:
I manage to display the serial number with this formula substring-after(eval(eval(Serial_x0020_x0023[ID = concat(Camera_x0020_Assets, ";")], 'concat(., ";")'), ".."), ";") but I was not able to define the true or false statement on the filter. In other words if Tag number is true display the serial number associated with that Asset tag number.
Sign in to comment
Activity