Is there a Maximum number of characters allowed in a URL calculated field?

Hello,

I'm creating a url that uses tokens to send a bunch of information to a separate website to run some calculations. In all I am pushing over 13 fields worth of data. At about the 6 field point Sugar is no longer writing the fields or the token values. I have increased the max size of the field to a crazy amount like 3000 characters, but I can't get the calculated field part to save any more values or tokens.

What do I need to do in order to get past this limitation?

0 Adam Frank over 5 years ago

I've created calculated fields with more than 6 fields - how many characters are in the field when it gets truncated? I know the out of the box URL field is 255 characters - and that is at the database level. Is that where you increased the size to 3000?
0 Katie DelValle over 5 years ago in reply to Adam Frank

correct. So what ended up happening is I had one account where one of my tokens was really long and the user was unable to save the record. That's when I realized that the 255 characters wasn't enough. I updated that to 500 at the time and was good to go.

Here is my calculated formula as it is right now: https://workshop.arvig.com/ROICalculator?roi_type=revenue&selected_drop_down=HPBX&date_of_service={estimation_form_date_c}&salesperson={created_by_name}&customer_name={account_name_c}&customer_address={customer_address_c}&z_location={z_location_c}&project

What i need is something closer to:

https://workshop.arvig.com/ROICalculator?roi_type=revenue&selected_drop_down=HPBX&date_of_service={estimation_form_date_c}&salesperson={created_by_name}&customer_name={account_name_c}&customer_address={customer_address_c}&z_location={z_location_c}&project_management_cost={hpbx_project_management_c}&type_of_service=Hosted-PBX&internet_commit_rate={hpbx_internet_commit_rate_c}&monthly_recurring_revenue={hpbx_monthly_recurring_rev_c}&monthly_recurring_expense={hpbx_monthly_recurring_exp_c}&electric_equipment_cost={hpbx_equip_elect_metalicense_c}&installation_cost={hpbx_installation_expense_c}

But every time I save this in my calculated field section it will cut off the remaining part of the formula where it's cut off in the top link.
0 Mauricio Sánchez Rodriguez over 5 years ago

Hi Katie,
Let me dare to suggest that if you are sending data from a site totally foreign to SugarCRM and in SugarCRM you are inserting the data, the best resource that you can use from SugarCRM itself are the APIs, you can consume SugarCRM's own or create your own personalized.

I suppose your version of SugarCRM is not the Community Edition, that version has some complex problems with the APIs.

On the other hand, I can suggest that you send your data with an AJAX function and with a POST method in this way your data will be sent serialized and you will not have problems with truncated data.

When using an AJAX with POST method, your SugarCRM API must also be of type POST.
You can start your search here:
https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_8.0/Integration/Web_Services/REST_API/

Regards.
0 Mauricio Sánchez Rodriguez over 5 years ago in reply to Katie DelValle

To Do that you can use an html field and from it build the href you can add fields but even so your url is so much data. If you want build an url you can stored in a description field, and you can get the field in a logic_hook after_save and so send her since over there.
Or you can build an API and get the data and send them since over there.
Kind Regards.
0 Adam Frank over 5 years ago in reply to Katie DelValle

Katie DelValle said:
That's when I realized that the 255 characters wasn't enough. I updated that to 500 at the time and was good to go.

The truncated URL you've pasted above is still cut at 255 characters - i.e. it has not been updated to 500 yet. Did you do that at the vardef level? Have you checked that the actual column in the database has been altered?