Find Records with Insert Help
# 🤝helpc
careful-fireman-21068
03/03/2024, 3:17 PMI have a properties table I want to check string output value that check:
• if the user output matches 3 of 3 items from the row that connected to the client's phone number => change node to existing property else continue with the flow. I always get an error
careful-fireman-21068
03/03/2024, 3:24 PMf
fresh-fireman-491
03/03/2024, 3:29 PMWhich of the cards throws the error?
c
careful-fireman-21068
03/03/2024, 3:32 PMthe expression
careful-fireman-21068
03/03/2024, 3:33 PMthank your helping me again 🙂
f
fresh-fireman-491
03/03/2024, 3:40 PMYou are very welcome. Can you send me the code you have in your expression
c
careful-fireman-21068
03/03/2024, 3:42 PMsure
workflow.output.agentPhone.length === 3 && workflow.output.agentPhone.every(phone => typeof phone === 'string')
careful-fireman-21068
03/03/2024, 3:42 PMI think I need something like this:
const phoneNumber = workflow['PhoneNumber']
const street = workflow['Street']
const buildingNo = workflow['BuildingNo.']
const aptNo = workflow['AptNo.']
const requiredFields = [phoneNumber, street, buildingNo, aptNo]
const missingFields = requiredFields.filter((field) => !field)
if (missingFields.length > 0) {
return false
}
careful-fireman-21068
03/03/2024, 3:42 PMbut is not working
f
fresh-fireman-491
03/03/2024, 3:43 PMI take it that workflow.output is the variable set to have the output from your Find records card?
c
careful-fireman-21068
03/03/2024, 3:44 PMyes
careful-fireman-21068
03/03/2024, 3:47 PMI try to build simple tasks that check records before adding them, but it must check 3 of 3 columns from the table that relate to the specific row; if it is 2 of 3, the user can add records. If it is 3 of 3, he can't
careful-fireman-21068
03/03/2024, 3:49 PMExample: User Bob wants to add property to Alice's client, but Alice has this properly already (how does the bot know? he should check 3 of 3 parameters from Alice properties)
f
fresh-fireman-491
03/03/2024, 4:34 PMI can take a look at it if you send me your bot. Make sure to delete any sensitive information first
c
careful-fireman-21068
03/03/2024, 4:43 PMI have a lot of private information there; can we do it another way?
f
fresh-fireman-491
03/03/2024, 4:45 PMYea
fresh-fireman-491
03/03/2024, 4:45 PMCan you send me a screenshot of the information returned from the Find records card
c
careful-fireman-21068
03/03/2024, 4:49 PMcareful-fireman-21068
03/03/2024, 5:10 PMok I think the problem is from the insert Records
Error, An unexpected error occurred when trying to process your request. (Error ID: err_20240303170933x5F9ECA8D)]
f
fresh-fireman-491
03/03/2024, 7:31 PMCan you send me a screenshot of your insert record card
c
careful-fireman-21068
03/03/2024, 8:52 PMHey, I fixed the issue; I'm still not figuring out how to make an expression that finds multiple records matching.
careful-fireman-21068
03/03/2024, 8:53 PMcareful-fireman-21068
03/03/2024, 8:54 PMIt seems like Botpress can't be a sort of replacement for CRM platform :/ @fresh-fireman-491
f
fresh-fireman-491
03/03/2024, 9:10 PMI would disagree here. This is 100% doable, we just have to figure out how. Going back to school tomorrow so my time will be limited, but I would recommend you to create a new help post about this new problem. Make sure to include all of the information that could be helpful for someone else to try and fix this. This includes the steps on how to reproduce this, and what you are trying / have tried.
18 Views