Assuming column is required, the following 98 results were found.
-
I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name, and ID. What I want is a HTML table now with the headers and data but without using a for loop. What...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Manage > Active numbers Note the number you want to use (they have friendly numbers but I use the full number in the first column) Sending a Text/SMS message // // using the account SID you obtained in the steps above v_Account_SID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
] } Error(s): {"errors":[{"message":"Field 'endCursor' doesn't exist on type...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Page of Copyright © My Company Ltd. All Rights Reserved. Additional Notes to Self: Some customers will want a column for VAT/Tax (Display amount and then percentage beneath in smaller) Line Item Totals have been added to the above code...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
My client has seen the Goals or Objectives report under "Organization Reports" but would like some additional fields/columns added to it. Turns out, it's a system report you can't change. Enter Zoho Analytics... well almost, Analytics will sync with...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
me synchronize every hour. Then I'll write the SQL queries to get the individual responses into a table with labels and columns that can help me group them (and identify which responses belong to which survey attempts). Then I'll write the SQL to sum up...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
It would let me delete (ie. uninstall) the other styles except for if you click on "Templates" in the left column, it wouldn't let me delete Prosilver because it said that the Affinity template inherits the Prosilver traits. When I deleted prosilver...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The below code with my modifications maintains the functionality for the user to change the sort order by clicking on the column titles. The page you want is /components/com_weblinks/models/category.php and you are going to edit the _buildQuery()...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the if ($sContent && $limit > 0){ and before the from part of the query $query->from('#__content AS a'); // Add "Relevance" column // + 1000 pts if in title x1 (eg. if word is twice then 2000pts) // + 60 pts if in introtext // + 40 pts if in fulltext...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
your database using phpMyAdmin, open the table with the suffix "_assets" and order the data (clicking on the heading of the column) by their parent_id. If you see more than one record with a value of 0, then change it to 1. If it's name is "root..." and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
give it the alias "about_new") Login to your database and browse to the #__menu table Search for any values in the `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is the table prefix)...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
-- [Optional: Clear jComments and reset table index with DELETE and ALTER] -- NOTE: One-line inserts only apply where the column count is the same. -- ********************************************************************* -- Comments DELETE FROM...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
SQL files: Import Categories: export SQL file and amend the insert(s) into the new table `#_categories` where `id` > 7 Add column in #_content just before note called `xreference` VARCHAR(50) allows NULL. Import Content (articles): export SQL file and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Datasheet View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the "Create View" page, there should...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
table with this data. Note that this only works if all the text files to be used as source data have the same number of columns and where the column widths match. How? I've adapted my real working product with an example. As my work was for a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
a Matrix rather than a Tablix: Insert a "Matrix" into the body of your report. Drag "ReportName" into the field that says "Columns". Right-click on the grey left margin and select "Insert Row" then "Outside Group - Below". Delete the row with the left...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
This issue is specific to my template because the entire report is displayed within a tablix (contains row groups, no column groups). The headers do not stay fixed at the top of the page anymore but then this isn't the show-stopper; being unable to see...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
click... How? To test any of the following, type the windows key and select "Run..." ( + R). Then type the value in the 2nd column "App to Run" then OK to run it: Settings Page App to Run Settings Homepage ms-settings: Accounts Access work or school...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB