VARIABLE_VALUE

[Glenn G]

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]

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.

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.

 

[Glenn G]

Update:
Your Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NmMwNTZhMDYzMzA0MzY1MjZjNTUzNiI_3D_pc
Your Task History ID: IjU3NjAwNTZkMDYzNzA0Mzc1MjZiNTUzNTUxMzE1MTYxNTQzMiI_3D_pc

Still with error now its different.

 

[Glenn G]

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]

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]

And this is now the new error...

Task History ID - IjU3NjAwNTZkMDYzNzA0MzA1MjZlNTUzMzUxM2I1MTY3NTQzMyI_3D_pc

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Glenn G]

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

 

[Arshita]

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]

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]

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]

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:

State	Code
Alabama, US	AL
Alaska, US	AK
Arizona, US	AZ
Arkansas, US	AR
Armed Forces America	AA
Armed Forces Europe	AE
Armed Forces Pacific	AP
California, US	CA
Colorado, US	CO
Connecticut, US	CT
Delaware, US	DE
District of Columbia, US	DC
Florida, US	FL
Georgia, US	GA
Hawaii, US	HI
Idaho, US	ID
Illinois, US	IL
Indiana, US	IN
Iowa, US	IA
Kansas, US	KS
Kentucky, US	KY
Louisiana, US	LA
Maine, US	ME
Maryland, US	MD
Massachusetts, US	MA
Michigan, US	MI
Minnesota, US	MN
Mississippi, US	MS
Missouri, US	MO
Montana, US	MT
Nebraska, US	NE
Nevada, US	NV
New Hampshire, US	NH
New Jersey, US	NJ
New Mexico, US	NM
New York, US	NY
North Carolina, US	NC
North Dakota, US	ND
Ohio, US	OH
Oklahoma, US	OK
Oregon, US	OR
Pennsylvania, US	PA
Rhode Island, US	RI
South Carolina, US	SC
South Dakota, US	SD
Tennessee, US	TN
Texas, US	TX
Utah, US	UT
Vermont, US	VT
Virginia, US	VA
Washington, US	WA
West Virginia, US	WV
Wisconsin, US	WI
Wyoming, US	WY

Province	Code
Alberta, CA	AB
British Columbia, CA	BC
Manitoba, CA	MB
New Brunswick, CA	NB
Newfoundland and Labrador, CA	NL
Northwest Territories, CA	NT
Nova Scotia, CA	NS
Nunavut, CA	NU
Ontario, CA	ON
Prince Edward Island, CA	PE
Quebec, CA	QC
Saskatchewan, CA	SK
Yukon, CA	YT

 

[Arshita]

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]

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]

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]

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?

 

[Arshita]

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

In that case, you can check for the available application with us here for the accounting system- https://www.pabbly.com/connect/integrations/

Will this be done for all 50 states?

Yes, if you have 50 states and you intend to apply the same formatting that you have implemented for Florida and the United States, then you will need to select the text formatter for each individual state. This means that you will have to repeat the formatting process for all 50 states in order to ensure that the desired formatting is applied uniformly across all states.

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?

As I can check, the mapping has been done correctly and accurately. As a result, your workflow is now functioning smoothly and efficiently without any issues or errors.

 

[Glenn G]

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.

Is this required for each state, country and province i expect details will be feild filled from.

If i add a "Text formatter" in the action step and only do it for Florida > FL.
Will this only be for "Florida =FL"

Same with all other places?

 

[Arshita]

Hello @Glenn G

Will this only be for "Florida =FL"

Yes, you are correct. The action will only be applicable to Florida.

If you would like to extend the action to all other states, I kindly request you to copy and paste the names of all the countries and their respective country codes into the Google sheet. Then, add a "Lookup values" application in your action step. This will enable you to set the country code for all the countries and help streamline your workflow.

To assist you further, I am sharing a Google sheet link that contains the names of all the countries with their corresponding codes. Please take a look at the sheet and let me know if you are still experiencing any issues.

Country Code

Sheet1 State,Code Alabama, US,AL Alaska, US,AK Arizona, US,AZ Arkansas, US,AR Armed Forces America,AA Armed Forces Europe,AE Armed Forces Pacific,AP California, US,CA Colorado, US,CO Connecticut, US,CT Delaware, US,DE District of Columbia, US,DC Florida, US,FL Georgia, US,GA Hawaii, US,HI Idaho, US

docs.google.com

Screenshot for your reference for workaround:

 

[Glenn G]

What about the reference of:

"Previous Fields" and "Current Fields"
when running a workflow?

if a workflow finds nothing in Current Fields because "Previous Fields" were empty.

Or a reverse of that Current Field is Filled in but no Previous Fields are empty because its a first time entry.

After the first time entry and we enter in some data but cant enter all data.

Missing a shipping address but have a billing address what can we do to prevent a loss of data being sent over?

we need to write out the data we can archive but cant not enter data but we need to have a place to start what is the process thereafter?

 

[Arshita]

I need some time to review and address your concern with our team. I will make sure to get back to you as soon as possible with an update on the matter. Thank you for your understanding.