... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well:
Note that any IDs used in the snippets ...
... var json_Row = new Array();
var json_Arg = new Object();
// get some values beforehand which allows us to compare to the rows already present in the subform
// first column to add ...
What?
A quick article to display a value in a column in a widget in Zoho Analytics.
Why?
Because I keep forgetting how to do it.
How?
I've done this for a query that amalgamated all the ...
... the parent form to hide the columns I don't need the user to see (I'll populate these by code):
hide Attachments.Parent_Record;
hide Attachments.Document_Name;
hide Attachments.Downloaded;
Here ...
... and then enter in the FTP details as per your configuration, then click on "Next":
Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the ...
...
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 ...
... 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
Build ...
... to parse the data in the appropriate columns was not working as expected.
How?
The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact:
v_FormattedData ...
... added a column called "Group Name" in the CRM Quote module as per the following screenshot:
How?
Again at the time of this article, this is only modifiable when using REST API v2.1. We are going ...
... 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 I have:
,
What I want:
First ...
What?
So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page).
Why?
This ...
... type the value in the 2nd column "App to Run" then OK to run it:
.jl_table_style
.jl_table_style thead th
.jl_table_style tbody th
.jl_table_style tbody th span
.jl_table_style tbody td
.jl_table_style ...
... simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files.
;
; ...
... what the link should be:
Ensure a report exists with your form and that one of the fields/columns viewable is the file upload or attachment field
In Zoho Creator, in the "Edit" mode, go to "Settings" ...
... extract value.
Hide the first column in the list view (contains "Profile 1", "Profile 2", ...)
Sort the second column (contains "Joes Personal Profile", "Joes Work Profile", etc)
Create subroutine for ...
... each column:
1. Specify that the data is delimited
2. Specify the data is delimited by commas
3. Specify which columns should be imported as text (the long numbers and phone numbers) ...
What?
This is an article documenting how to access ZohoCRM with API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet ...
... Unfortunately, the MS Excel software adds tab characters to delimit the columns...
How?
UPDATE `mytable` SET `myColumn` = TRIM(CHAR(9) FROM TRIM(`myColumn`));
Source: Stack Overflow - How to ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.