VARIABLE_VALUE

Glenn G

Member
Your Workflow URL
https://connect.pabbly.com/task/history?filter_status=applied&filter_by_workflow_id=IjU3NmMwNTZhMDYzMzA0MzY1MjZjNTUzNiI_3D_pc
Your Task History ID
IjU3NjAwNTZkMDYzNzA0MzQ1MjZmNTUzYzUxM2I1MTYxNTQzOSI_3D_pc
i was getting an error on my process: VARIABLE_VALUE

So i have tried to follow the videos of using:

Text Formatter by Pabbly​


How the heck do you make a convert to "US" when the data keeps pushing "United States"

What is the code for this????

Atempt#1 -
Your Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NmMwNTZhMDYzMzA0MzY1MjZjNTUzNiI_3D_pc
Your Task History ID: IjU3NjAwNTZkMDYzNzA0MzQ1MjZlNTUzMDUxM2I1MTY0NTQzMSI_3D_pc

Atempt#2 -
Your Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NmMwNTZhMDYzMzA0MzY1MjZjNTUzNiI_3D_pc
Your Task History ID: IjU3NjAwNTZkMDYzNzA0MzQ1MjZmNTUzNTUxMzA1MTYzNTQzMCI_3D_pc

Atempt#3 -
Your Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NmMwNTZhMDYzMzA0MzY1MjZjNTUzNiI_3D_pc
Your Task History ID: IjU3NjAwNTZkMDYzNzA0MzQ1MjZmNTUzYzUxMzU1MTZhNTQzNCI_3D_pc

current status still nothing but seem now i have no error i am lost and without error now.

only error is no data moving to Wave.com from Flowlu.com - CRM Account is Created

If i can not create this simple task what hope is there of me finishing the dozens of other I need to have built in the next few days???
 

Arshita

Moderator
Staff member
Hey @Glenn G

How the heck do you make a convert to "US" when the data keeps pushing "United States"
It seems that in your current workflow, the United States has been mapped twice in your "Text formatter: Replace text". This could potentially lead to an incorrect output of "USUS" instead of the intended "US".
To address this issue, I recommend you to map the Text field again in the "Text formatter: Replace text" step to ensure that the United States is only mapped once.
Once you have made the necessary changes, I suggest that you test the workflow again to confirm that the issue has been successfully resolved.


image (6).png


only error is no data moving to Wave.com from Flowlu.com - CRM Account is Created
Also as I can check, it appears that you are not currently receiving the "current legal name" from Flowlu which you have mapped in Wave.

To resolve this issue, I would highly recommend that you take steps to ensure that you are receiving the "current legal name" from Flowlu before attempting to execute the workflow again.
2023-03-18_11h38_20.png
 

Glenn G

Member
Hey @Glenn G


It seems that in your current workflow, the United States has been mapped twice in your "Text formatter: Replace text". This could potentially lead to an incorrect output of "USUS" instead of the intended "US".
To address this issue, I recommend you to map the Text field again in the "Text formatter: Replace text" step to ensure that the United States is only mapped once.
Once you have made the necessary changes, I suggest that you test the workflow again to confirm that the issue has been successfully resolved.


View attachment 23306


Also as I can check, it appears that you are not currently receiving the "current legal name" from Flowlu which you have mapped in Wave.

To resolve this issue, I would highly recommend that you take steps to ensure that you are receiving the "current legal name" from Flowlu before attempting to execute the workflow again.
View attachment 23305
What happens if i leave blank can that be done?? If i choose to leave a cell that is mapped on flowlu to Wave blank as shown here does this cause issues? Do i have to have a field filled with data even if not relevant to the customer -
 

Glenn G

Member
Hey @Glenn G


It seems that in your current workflow, the United States has been mapped twice in your "Text formatter: Replace text". This could potentially lead to an incorrect output of "USUS" instead of the intended "US".
To address this issue, I recommend you to map the Text field again in the "Text formatter: Replace text" step to ensure that the United States is only mapped once.
Once you have made the necessary changes, I suggest that you test the workflow again to confirm that the issue has been successfully resolved.


View attachment 23306


Also as I can check, it appears that you are not currently receiving the "current legal name" from Flowlu which you have mapped in Wave.

To resolve this issue, I would highly recommend that you take steps to ensure that you are receiving the "current legal name" from Flowlu before attempting to execute the workflow again.
View attachment 23305
Also seems that i am still getting issues with the process. Linked: https://forum.pabbly.com/threads/variable_value.12657/post-58772 (& or scroll up)
 

Glenn G

Member
Even the successful connections was an error and would not connect
meantime im burning time and task counts and no where am i closer to connection
 

Attachments

  • error-3.1.JPG
    error-3.1.JPG
    67.9 KB · Views: 3
  • error-3.2.JPG
    error-3.2.JPG
    68.5 KB · Views: 3

Arshita

Moderator
Staff member
Hey @Glenn G

I kindly request you to establish a new connection with Wave and ensure that all fields are mapped correctly.

Please take care to map all fields accurately and completely, without leaving any gaps or omissions such as province code or shipping details.
It is important that you thoroughly review and verify each field to ensure that all relevant data is captured and processed accurately.
 

Glenn G

Member
Hey @Glenn G

I kindly request you to establish a new connection with Wave and ensure that all fields are mapped correctly.

Please take care to map all fields accurately and completely, without leaving any gaps or omissions such as province code or shipping details.
It is important that you thoroughly review and verify each field to ensure that all relevant data is captured and processed accurately.
Wave is handled by H&R Block Tax firm without any communication line or recourses limited help all related to tax and accounting.
I am waiting on an email back from them and doubtful they will even understand what i am doing.
 

Glenn G

Member
How do you change the text from a State "Florida" to "FL" for all the united states?

Text Formator Process of converting? if this is correct can someone do a How-To on this step by step thanks....
 

Glenn G

Member
How do you change the text from a State "Florida" to "FL" for all the united states?

Text Formator Process of converting? if this is correct can someone do a How-To on this step by step thanks....
ProvinceCode = "FL (not: FLORIDA)"

US State and Canada Province Codes​

Valid codes are as follows:

StateCode
Alabama, USAL
Alaska, USAK
Arizona, USAZ
Arkansas, USAR
Armed Forces AmericaAA
Armed Forces EuropeAE
Armed Forces PacificAP
California, USCA
Colorado, USCO
Connecticut, USCT
Delaware, USDE
District of Columbia, USDC
Florida, USFL
Georgia, USGA
Hawaii, USHI
Idaho, USID
Illinois, USIL
Indiana, USIN
Iowa, USIA
Kansas, USKS
Kentucky, USKY
Louisiana, USLA
Maine, USME
Maryland, USMD
Massachusetts, USMA
Michigan, USMI
Minnesota, USMN
Mississippi, USMS
Missouri, USMO
Montana, USMT
Nebraska, USNE
Nevada, USNV
New Hampshire, USNH
New Jersey, USNJ
New Mexico, USNM
New York, USNY
North Carolina, USNC
North Dakota, USND
Ohio, USOH
Oklahoma, USOK
Oregon, USOR
Pennsylvania, USPA
Rhode Island, USRI
South Carolina, USSC
South Dakota, USSD
Tennessee, USTN
Texas, USTX
Utah, USUT
Vermont, USVT
Virginia, USVA
Washington, USWA
West Virginia, USWV
Wisconsin, USWI
Wyoming, USWY


ProvinceCode
Alberta, CAAB
British Columbia, CABC
Manitoba, CAMB
New Brunswick, CANB
Newfoundland and Labrador, CANL
Northwest Territories, CANT
Nova Scotia, CANS
Nunavut, CANU
Ontario, CAON
Prince Edward Island, CAPE
Quebec, CAQC
Saskatchewan, CASK
Yukon, CAYT
 

Arshita

Moderator
Staff member
Hello @Glenn G

How do you change the text from a State "Florida" to "FL" for all the united states?
To achieve this, I suggest you to add a "Text formatter" in the action step of your workflow and select "Replace text" as the action event to replace specific text with another text.

Ensure that the text field is mapped correctly, and then proceed to enter the text to find in the "Find" field. In your case, the text to find is "Florida". Next, enter the replacement text in the "Replace" field, which in your case is "FL".

By following these steps, the text formatter will identify the specified text in the selected field and replace it with the desired text. This will ensure that your workflow processes the correct information and executes the intended actions accordingly.
 

Glenn G

Member
Hey @Glenn G

I kindly request you to establish a new connection with Wave and ensure that all fields are mapped correctly.

Please take care to map all fields accurately and completely, without leaving any gaps or omissions such as province code or shipping details.
It is important that you thoroughly review and verify each field to ensure that all relevant data is captured and processed accurately.
paid $229.00 to have a chat with a waveapps.com accounting expert to be probably told to use Zapeir - I am likely requesting a refund of that $229.00 as Waveapps.com Accounting appears to be a bad fit for our use....

Any other Accounting Systems that I can use when I get this expectation of news they cant help. thanks in advance

please all i ask is they have tech support so to help with integration. As i am sure even if i hired an agent id be dealing with this still.
 

Glenn G

Member
Hello @Glenn G


To achieve this, I suggest you to add a "Text formatter" in the action step of your workflow and select "Replace text" as the action event to replace specific text with another text.

Ensure that the text field is mapped correctly, and then proceed to enter the text to find in the "Find" field. In your case, the text to find is "Florida". Next, enter the replacement text in the "Replace" field, which in your case is "FL".

By following these steps, the text formatter will identify the specified text in the selected field and replace it with the desired text. This will ensure that your workflow processes the correct information and executes the intended actions accordingly.
Will this be done for all 50 states?
 

Glenn G

Member
Hello @Glenn G


To achieve this, I suggest you to add a "Text formatter" in the action step of your workflow and select "Replace text" as the action event to replace specific text with another text.

Ensure that the text field is mapped correctly, and then proceed to enter the text to find in the "Find" field. In your case, the text to find is "Florida". Next, enter the replacement text in the "Replace" field, which in your case is "FL".

By following these steps, the text formatter will identify the specified text in the selected field and replace it with the desired text. This will ensure that your workflow processes the correct information and executes the intended actions accordingly.
My current example where Florida is the primary State I have been using in current and past data pulling. So I don't understand what is wrong?
 

Attachments

  • Failed Florida to FL.JPG
    Failed Florida to FL.JPG
    60.9 KB · Views: 3
Top