the first version of the record (sorted by ID ascending) and will attempt to delete the other records which match on product name. I would recommend commenting out the delete commands and leaving the info commands to preview what records it will delete....
items to invoiced items (i console logged out this line item and copied each of the fields hoping they had the same API name in both modules) o_NewLineItem.CUSTOM = o_ThisLineItem.CUSTOM; o_NewLineItem.Config = o_ThisLineItem.Config;...
to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the image name, size, user who uploaded, timestamp and the path. Remember that the paths are determined using the MD5 Hash of the filename:...
"Server-based Applications", then on the plus icon to add new client. Fill in the new form to Create New Client: Client Name: put something descriptive so it is easy to identify if the client has 3rd-parties adding clients. eg....
CRM modules called a "LinkingModule" (as opposed to standard modules and custom modules). Quick way to determine the API name of the linking module: Go to setup > Developer Space > functions. Create a standalone function called "Test". Type in line 1:...
response beforehand. 1. Set up the Creator form Log-in to your Zoho Creator app Click on Plus sign to add a new form > blank Name the form, I'm going to call mine Shopify Webhook Payloads Drag some fields onto the form, this is what I did: Event Type...
but I store all the keys in a Zoho Creator form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID (Single Line) Client ID (Single Line) Shop ID (Single Line) Client Secret (Single Line) Location ID...
put in a Zoho Creator page excluding the content (edited for Public display - Not the used final version): 0) { if(c_Quote.Name != null) { v_Firstname = c_Quote.Name.first_name; v_Lastname = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email...
I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear, DATEPART(year, ItemYear) AS YearRun, COUNT(ItemName) AS Counter FROM TableName...
students and staff by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month, SUM(IF(t2.VisitorType='Staff', 1, 0)) Staff, SUM(IF(t2.VisitorType='Student', 1, 0))...
the Application Clearance and Decision Entry (ACD) screen. Put the cursor in the field and press F1, this will give you the name of the field, its entity and dictionary. My example below will use the Decision/date and Response/date fields (rather than...
2.5, this is now a setting in the global configuration... The only problem is that your landing page becomes "HOME - SITENAME.COM" which is ridiculous and I'm sure Joomla will release a new version addressing this. In the meantime however: Go to "Global...
the Joomla! CMS, an error 1054 comes up if you use the above statement. Why? The MySQL statement SELECT COUNT(DISTINCT name) FROM table is valid but I get what you mean and it's sometimes difficult to explain why you want to use it. How? Method #1: Add...
Display/Access based on User level - Added Admin Section: Manage Projects (each include all versions per entry) --- Project Name --- Category Name (dropdown of categories) --- License (textarea / option require or not) --- Specify Joomla! Article (for...
Setup » Developer Space » Connections » Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function...
we made this functional. To prepare for this, I created the following Creator form: The fields: Calendar Day Select (link name: Calendar_Day_Select || type Radio) Form CSS (link name: Form_Css || type Add Notes) Selected Value for debugging (link name:...
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.