How to pad a string with leading zeros
I have created an auto increment reference number but I like to display it with leading/padding zeros. So it looks like: 0001 0002 ... 0256 0257 and so on. This is the equivalent to the following printf function: printf(" d", variable) How can I do the same in a deluge script?
How to craete PDF and upload to workdrive?
Hi, We need to create pdf and upload to workdrive. 1. we have success create pdf by caretor url. 2. we have sucess upload file to workdrive. But the url that craete pdf didn't upload to workdrive it need actual file url. Any trick to make it.
How to create a short customer ID
Just wondering how I would go about creating a shortened customer ID number.... I know Zoho creates a unique ID for each form entry, but I was hoping to create ones unique to my form, though only 5 digits or so and not the 18 automatically generated. Thanks!
Common Workflows
For most of my apps, one of the first workflows I add is to fetch customer names from my Zoho Books application to populate a picklist. Since I have way more than 200 customers, this usually involves multiple API calls and quite a few lines of script to filter out vendors and inactive customers Currently, I have this script saved as a text file on my desktop and I cut and paste whenever I need to reuse this for a new app. Is there a better way to do this?
PDF blank
Hi, I have a form named Memorando that use a html view to print a pdf with the records of the form. At the moment the pdf is produced correctly (with the name) but absolutely blank. The html save the script but when I reload the page isn't saved. Any suggestion? Thanks Mic
Fetching leads from Zoho CRM into Zoho Creator, automatically
I'd like to pull new leads from the CRM system, into Creator, on a daily basis. Is this possible? Yes, it is possible. Zoho Creator and Zoho CRM are integrated with each other, enabling you to synchronize data between them. This is done by fetching records from CRM into a Zoho Creator form. In order to achieve this, you'll have to configure a workflow alert in Zoho CRM. For instance, you can maintain the lead details in CRM on a separate form in Zoho Creator by fetching the details automatically
scan dymo barcodes
Our supplier uses the dymo labelWriter 450 to create their barcodes, however scanning them using zoho isn't working. Are the two compatible? Thanks
Passing info from stateless form into htmlview with no clicking
Hey, Assuming a stateless from with no buttons and a lookup field. I want to access or pass the value that was selected within the form into the htmlview holding this form. Any idea how this can be done? Many thanks.
Calculate KPI
Hello, i need to calculate a KPI in ZOHO creator: i have the first Field called 'Montant_Total' using the Panel i can get the Sum() of all 'Montant_Total' like: <text type='Form Data' value='thisapp.Cr_er_Task.Montant_TOTAL.sum' size='8' color='#2A70E7' bold='true' marginTop='2px' displayType='actual' decimalPlaces='2' decimalSeperator='.' numberScale='none'> </text> and i have also all the inout (Count) using the script bellow : <text type='Form Data' value='thisapp.Cr_er_Task.ID.count'
Subform lookups
Hi All, I'm trying to fetch records but my usual method isn't working as I'm dealing with a subform now. My main form has 2 fields, part number and name. I have a subform within the main form which has a lookup to both these fields. I would like the user to add a row to the subform and select a part number(s). I then need the subform name field to be auto populated with the corresponding name(s). The lookups in question are both multi-select. Can anyone show me the correct syntax for this operation?
How to switch to 12 hour format?
Hello. I'm trying to create a form within creator that allows my employees to clock-in/out but the date-time field in the forms only allows for 24 hour format? We need 12 hour format. How can I get this going? Also, I need two forms, one for clocking in upon coming to work, and another for clocking out at the end of the day. How can I get these two forms to work together on one report? Thanks
Retrieve and merge 2 fields
I have 2 forms: Members and Claims. The line below works to retrieve the status from Members, when the membership number is inputted into Claims input.Membership_Status = rec.member_membership_status; I also have First Name and Last Name fields in the Members form. Is there a similar line of code for me to retrieve and combine the First Name and Last Name fields to input into a single Name field in Claims
History of all records
Hy! I was wondering, if there is a possibility to store history of all records of my application (in the mean of changes - history of changes, for example: if I have a record 'person' and 'computer' and if computer have at start one user, but after some time it gets other user, both records would be seen - when computer had user1 and when computer had user2)... Thanks!
Inserting Subform Row via an Action on a Report
Currently, inserting a subform row using an action on a report isn't allowed (see the screenshot below of what I'm trying to accomplish: allowing users to insert a vote into the Votes subform of each record). Can anyone (Damien Cregan?) think of a way to insert subform rows using a button on a report that doesn't require the use of a stateless form? Perhaps by simulating a record edit + On User Input or On Update??
Error handling
On occasions, running scripts produces errors (e.g. incorrect email address format in sendmail). In contrast to the Execution error popup, is there any way of trapping such script execution errors and reporting them in a controlled way? Other languages support 'on error' type traps; is there an equivalent in Deluge?
How to calculate a "check digit" at the end of a reference number
Hi, please can you assist me with the the following: I want to create a formula that will calculate a "check digit" at the end of a reference number ie, similar to credit card numbers. The algorithm that I'm using is the Luhn Modulus 10 Check Digit and works like this: 1. I need 14-digit reference number (I will create this using the auto number field in Zoho Creator) 2. Reverse the 14-digit reference number ie. if original reference number was 246810 then the reversal will be 018642 3. Double each
Zoho Filedownloader error
When entering my credentials, it responds that my username or password is incorrect, please help
Hide Submit Button
Hi ! I have the necessity to Hide or Disable the Submit Button in my form ! there are any system to do this ? Thank You
Need direction to create a map report
Hello. I'm trying to allow volunteers to quickly create a map of deliveries by putting in the names of the recipients they've been assigned for the day. I've already created a form to input all of the potential recipients. I want a volunteer to be able to use a very basic form to put in his or her name and the date of deliveries and then select the people he or she has been assigned from the list of possible recipients. Next, I want Creator to look up the addresses of the recipients the volunteer
POST to Popular Web Services
There's lots of discussion of late about posting data to external applications. https://help.zoho.com/portal/en/community/topic/http-headers-when-using-zoho-creator I think it would be great if ZOHO, or community members, provided some cookbook examples for users (like me!) to follow for popular web services (Google, Twitter, Facebook, Foursquare, and such). One I'm really interested in is posting calendar data to Google Calendar. While the ZOHO iCal feed is handy, Google Cal does not sync the feeds
Unleash your Zoho Creator HTML Views using "ZCML"
What is ZCML? ZCML is HTML with a Zoho Creator twist. ZCML let's you write HTML on your website or web application very much the same way you do in a Zoho Creator HTML View. You get the benefits of the same embedded variable syntax without the need to use the ZC REST API. This is not iframing. ZCML is HTML native to the website or web application it's being rendered on. Please watch the video. Why use it? It's Fast Zoho Creator HTML Views can be very slow to render depending on the number of statements
Data visualisation
hey guys, I am struggling now for days with a most simple visualization task: I need for a digi health start up a simple chart for each patient: two clustered bars within three different categories. Values are calculated in a form and get nicely displayed in the standard report. Just visualization doesnot come around, even with help from the support team. if I could do this as a pivot chart than I could have this per patient and for each patient per GP, with controlled data access. As a matter for
Embeddable Search Function
Is there a way to embed the search function to a website so that only specific fields in the original form would be visible? Say for instance you have five fields in your form that you choose to all have appear in the view (or report) for that form: Given Name Middle Name Family Name Email Address Mobile or Telephone NumberNow, as far as I'm aware, if I were to embed the view on a website, then third parties who have access to the website will be able to see all the records (say 150 records) entered
summary view of information from several forms
I am new to ZC, and maybe still not thinking in ZohoStyle. However, one main power of RDBMS is that data does NOT need to be stored in several places. As I see it, if I want to have data from 2 forms in 1 view, I need to add a lookup field, this distorts a little the logic of dividing the data. However, I will ask a question, and hopefully, it's possible: Each of us has many tables/forms, some of the objects are more core objects (person, ID...), while other are data decsribing - name, address,
In zoho creator do we have search with barocde scanning for form detail page?
i want to create an app from which a person can read the barcode of prouct and get the details of that stored in form detail page
Can I login customers from a custom mobile app?
We're looking into the possibility of using Zoho Creator as the API for an iOS game that we have. In the iOS game the customers need to be able to login using their username/email and password. After a successful login, they should view records that they previously created in Zoho Creator, if there are records that have attachments, they should be downloaded and displayed in the game. Apparently Zoho Creator doesn't have an API for authenticating customers in third-party apps via HTTP requests. Is
How can I launch a bulk edit action by a custom action (how do I write the URL)
How can I launch a bulk edit action by a custom action (how do I write the URL). And how can I manage the information shown on the BULK EDIT window. Like I want to the give the choice to edit just one column. Thank you!
Hide/Disable Lookup Field Values
Hi, I have Form A - Employee Self Appraisal Form and Form B - Manager Appraisal Form. Form A - Employee Self Appraisal Form will have all the fields like Employee_ID, Employee_Name and Self Appraisal as text field entered by employee. Form B - Manager Appraisal Form will have Employee_ID field as lookup field which helps to auto-populate Employee Name and Self Appraisal field. Now Manager will look at the data fetched against each value from lookup field and adds his comments in comment field. Since
Add approval process from workflow inside forms or reports field
How to add/Enable approval process inside zoho asset tracker Work flow .As I can not able to see inside workflow.
How to download/view the file uploaded in other form into current form ?
Hi, I have two forms, Self Appraisal Form & Managers Appraisal Form. In Self Appraisal Form - User X will enter the required details and uploads a supporting document to it. In Managers Appraisal Form - User Y will check the details entered by User X and should download the supporting document uploaded. Pl help me with some code/script to make this possible. Regards, Prasad
Show text in popup window after successful submission
How can I implement a workflow to show a text information after successfully submitting a form?
Bulk Edit vs. Manual Correction
I am running a company and contact database. Due to the nature of my app, I need to have duplicate records. Whenever I want need to do a mass import, I need to make the parent object (in my case company and company name field) unique in order to attach those contacts to the duplicate companies that I am importing. For example: - Corporation Inc. - FIRST RECORD - _Corporation Inc. - DUPLICATE RECORD After my import, I need to remove "_" manually. In some cases there are 100s of records.
Custom button with drop down
I have a dashboard wherein i have created a Confirm button and what i want when i click on Confirm button, it gives me 4 option - Approve, Reject, Pending and on Hold.
Timezone synchronization
Hello, I have a problem. On the desk platform I set the "Rome" time zone. When I read the task the creator app does not have the same time zone as the zoho desk. I set the time zone correctly on both sides:
attachments
Hello, I have a problem. task I can't attach photos to mine. why? gives me this error: Error Error details: Error at on submit script. Note: We are working on giving more meaningful error messages on script failures. This is the string I created: zoho.desk.createRelatedRecord(20067793560,"attachments","tasks",input.taskid.toLong(),{"file:":input.Allegati},"ZohoDesk"); I also created this string that works: zoho.desk.createRelatedRecord(20067793560,"timeEntry","tasks",input.taskid.toLong(),recordValue,"ZohoDesk");
[Webinar] Schedule work orders directly from Zoho Creator
Hey everyone, Tomorrow at 12 PDT we're hosting a demo of our SmartScheduler, which was previously featured in a Zoho Practitioner webinar. Since then, we've made some enhancements to it to support both appointment and work order scheduling. Chief Solutions Architect James Converse will demonstrate it all, including: Scheduling from a CRM button or from a Work Order in Zoho Creator Scheduling individuals, crews, and equipment usage Easy drag-and-drop interface Google Maps & Calendar integrations
Workflow - changing Product Details section
I decided to post my solution to this problem. Many forum posts suggests that Product Details section is uneditable, there is lots of misinformation in these posts as well as example 2 in documentation which suggest solution that doesn't work(link https://www.zoho.com/creator/help/script/crm-v2-update-records.html). salesRec = zoho.crm.getRecordById("Sales_Orders",salesID); productsList = salesRec.getJSON("Product_Details").toJSONList(); for each product in productsList { //Here you have to
URL field, Link Name, Default Value
Hello, I think it would be great if the Link Name option of the URL field could have a default value field in field properties. It would make it easier and faster to define a simple unique word or expression as a link for each record containing a URL field without the need of entering the same word for each record we submit.. Anyway, while waiting for Zoho to add this feature to Creator, here is a working solution I found based on the following source : https://www.zoho.com/creator/help/fields/configuring-a-url-field.html
Explain conditional formatting in calendar reports in live mode
Hello, It would be useful, if you use color code in your calendar report, that the user could see the meanings of the individual colours. Maybe not a big deal, and other users would like it too. Kind regards
Formula to show the amount of months and days between 2 date fields
Hi Please would someone help me and provide me with a formula to show the number of months and days between 2 date fields. I can only work out how to show the number of total days, but was hoping it could read as: 4 - Months and 29 days Many Thanks Peter
Next Page