I'm trying to extract data from a table to put into a field outside the table in Kintone. I've read and noticed that the native plug-ins, etc. will not perform this so I was looking into coding as an option but to be honest, I'm a noob at best with JS coding. Any suggestions on where I could find some examples or knowledge on pulling data from a table to placing in a field outside the table?
My Table contains a container type, volume, comment. When the container type TOTE is selected, I need the volume associated with the TOTE row to be place in another field that is outside the table BUT in the same app.
At first, I thought using a simple if statement with a CONTAIN function in a calculation or text field (I tried both) will do the trick but it doesn't like it.
Any assistance would be greatly appreciated. Thank you.
Thank you.
There will only be one row with TOTE. Won't have to worry about multiple rows with the same type. I'm using tables because the plant that will be using this app may have to enter different types of containers for the same new product or product change. The Container type is a drop down that allows them to select. the type, example we have TOTE, DRUM, PAIL, BIB, etc.
For each type there will be a volume amount(gallons) that they will have to enter (number field) and a Comment if needed (text area) field
