Thread Details
  • State Not Answered
  • Replies 5 replies
  • Subscribers 369 subscribers
  • Views 1426 views
  • Users 0 members are here
Forum Actions

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

Katie DelValle

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? 

Parents
  • 0 Sugar Employee Badge

    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 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 Sugar Employee Badge 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?

Reply
  • 0 Sugar Employee Badge 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?

Children
No Data