Assuming example is required, the following 175 results were found.
-
is a quick article I use to list step by step on how to set up a custom domain for a Zoho Creator customer portal. In this example, we are going to use a subdomain of a company which has the domain joellipman.com. Why? This took me a bit of going...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
first and then add the subform afterwards (insert into [...]) but it can be done all in one go. How? Here's a use case example which you will need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Item to Shopify API if you want information on setting up an integration from Zoho Creator to Shopify API. Why? In this example, we want a webhook that whenever an order is made in Shopify, it tells our Zoho Creator app. Note that at the time of this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
// // your shopify details v_ClientID = ""; v_ClientSecret = ""; v_ShopID = "example.myshopify.com"; v_ShopifyURL = "https://" + v_ClientID + ":" + v_ClientSecret + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // loop through 2500 records...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the file. First Create a CRM connection I'm going to create a Zoho OAuth connection with open scopes just to get a working example; I can then reduce the scopes permissions afterwards when locking it down for security: Login to ZohoCRM > Setup >...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
key trick I used was to actually use a single-line text to store the customer's requested time. Let's use the appointment example mentioned above for a customer in UTC+1 @ 4pm their time. The server is on Eastern time UTC-5 and the agent is in Los...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
I felt the documentation was a little sparse on how to connect a JS widget to the data held in Zoho Creator. Having this example for future use might save me some time. The following is the early version of a JS widget used for a customer and before I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
are EMAIL, POPUP, EMAILANDPOPUP. TRIGGER=DATE-TIME (DateTime ISO8601): Defines when you want to trigger the reminder. Example: 2020-05-01T12:28:00+05:30. TRIGGER=TIME (hh:mm): 24-hour time format at which the system must trigger the reminder. Example:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
I'm calling it thumbnailer.php Deploy the Script Place thumbnailer.php into a web-accessible directory on your server (for example, public_html/api/thumbnailer.php). It will be called as a JSON API over GET and does not render a webpage. Create Storage...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
developer installing my component will do so on a website which uses different login details for their Joomla database. The example below demonstrates how to get these details and extract data from the database. How? Based on a script I found on...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
return $output; } 5. Get Minutes Remaining on cached token So usually an access token will last for 60 minutes, in this example, we are going to store the token value so it is reused until it is about to expire. Firstly, we need to check how many...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
MediaWiki v1.14.0 PHP v5.1.6 MySQL v5.0.45 Camtasia Studio v5.0 For Demonstration Purposes We want to add a video called "EXAMPLE.SWF" to an article Let's begin Create your video in Camtasia Studio and produce the SWF files Finish doing your video Go to...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
This is a quick article on how I got time conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two dates one...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range. How? My example is that I have an excel sheet where the first 10 rows are descriptions to the column, and then I have 38 columns ("A" to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM table1, table2 WHERE table1.studentID = capd_table2.studentID AND (...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
TABLE table_name MODIFY COLUMN misplaced_column BIT(1) NOT NULL DEFAULT b'0' AFTER other_column; -- OR A MORE COMPLETE EXAMPLE -- ALTER TABLE table_name MODIFY COLUMN misplaced_column VARCHAR(13) NOT NULL DEFAULT 'DefaultString' COMMENT 'A Comment'...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER BY StartDate ASC,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
] IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [stored_procedure_name ]; Example CREATE OR REPLACE PROCEDURE sp_get_studentdetails_from_ad ( c_test out sys_refcursor, p_STUDENT_ADNAME in varchar2 ) IS BEGIN...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
an FLV file and you don't want any fancy management system, you just want your FLV to play on your webpage. The following example is a demonstration of how to do this without installing anything on your webserver. I like to use flowplayer for this...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: *
-
Issue Basically you have a HTML form with an input field type of 'FILE' (ie. ) and want a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB