Reoccurring Frequencies in Workflow
Yes i'm newer to ZOHO, but i'm trying to set up a reoccurring email alert that would be sent to a customer the day before we come out to do the work. Is there a way to set it to reoccur like ever 3rd Saturday of a month instead of a fixed date? My customers don't get serviced based on a specific date but a specific re-occurrence of work.
Reporting - how to pull records which have two or multi select items selected
I am creating a report and want to show only records where two or more items have been selected from a multi select list. How do I do this? Thanks
SubForm Custom Sorting
Hey everyone, wouldn't usually post but I feel your pain on this one. I managed to make it work in a roundabout way. Will try to explain as best I can! The issue is the subforms are sorted by their created time so I've managed to get my subform to sort in the following way.... To give you some context, my subform is being used for sorting a hierarchical task list. I needed to be able to order the tasks but also allow extra tasks to be put in between as and when they were needed. You'll need; - The
Google Address Autocomplete on a form
How could I use the Google Address Autocomplete API for a standard Form? I guess I can trigger a function by writing an On User Input script for a plain text field. But I'm not sure how to execute Java from a script. This would be a cool feature if I can make it work.
Conditional formula in a formula field
I had the following very simple formula in a formula field: 12 / input.Interval_months (where input.Interval_months is a decimal) This works absolutely fine. However, I want to make this a conditional formula, so I amended it to the following: if(Charging_Method == "NO FORMAL AGREEMENT", 0, 12 / input.Interval_months) Very strangely, this formula now only works if the result is a whole number. If 'Interval_months' is 6, the formula correctly shows the value '2'. However, if the 'Interval_months'
Compare two date fields to return a result of True
I have two date fields in a module, date field 1 shows when something is due. Date field 2 shows when it was submitted. I would like to compare these two fields and return a result of Yes or no in a thrid field depending on if the due date is met. I have tried an if statement; If(${Projects.Final Submission}<${Projects.Date job finalled},'yes','No') Not and expert.
[Tips] Use something else then SUM in Page's chart
Here's a cool trick I learn last week that changed my life, hope it can put a smile on some of your faces as well. Currently, in Pages, when adding a Chart, you can input aggregated or actual values as Y axis. When choosing aggregated values, you can only select SUM of fields. // How to Well, if you go play in the Application IDE a bit, it actually supports other mathematic logic. So far, I've only tested MIN, but I expect this to work with MAX and probably AVR as well, up to you to try it out. The
Importing flat file with 160 columns into Zoho Creator
I have a flat file with 160 columns and about 200,000 rows.... what is the best way to upload this file to Zoho Creator? It has a 70-columns limit for mass uploads... is there a way to get around this? Thanks.
How to do calculations with value from Formula field? Getting NULL from formula field
I am trying to figure out costs of field which is the price per sqft times the amount of SQFT. I have a length and a width field, create a formula field and then have a cost field which runs a workflow to multiply sqft and price per sqft but I get a null result from the formula field. If I do a workflow that calculates the SQFT, then my form does not work offline.
Download image from the command line
Hello. I wanted to ask you how to download images uploaded to a Zoho Creator form (using an Image field), from command line tools, like wget or curl. The idea is to download them from a script, without manual intervention. I have read that there is a File downloader tool, but it cannot be used from the command line. Thanks in advance. -- Best regards
yourtime.tostring() format 12hr 24hr share
https://help.zoho.com/portal/en/community is too poor resource for us, but it's the only ! Some function are enable in creator, but many people don't know where to find them. Example, same with me ,try multiple methods to transform 12hr or 24hr, in fact, zoho creator have this function. Suppose now is 2016-04-29 15:30:12 : info zoho.currenttime.tostring("hhmmss") // show 033012 info zoho.currenttime.tostring("HHmmss") // show 153012 If it can help somebody, I should be very
Update field B to be 365 days after field A
I know this is supposed to be really easy, but I can't figure it out. I have field A that will be populated with a date. I want/need field B to automatically populate with 365 after the date in field A. I know there is the .addDay() function, but I don't understand how I'm supposed to format my custom function to get it to return 365 days after the date entered in field A. Please help. I know this is supposedly really easy, but I'm having a hard time, so a detailed explanation would be really appreciated.
Convert RTF to string removeing html code
I have a form with a RTF named Comment. The user could enter a lots of text making the view cumbersome. I added a string field called Short_Comment. This field that contains the first 200 characters of the Comment. This makes the View more manageable. However I get html code in the string field. Is there a function that will strip out all of the html code? Herb Wexler
PDF File Failing - Record Template
I'm having issues when downloading a Record Template because it has a lot of images coming from a subform. File fails when I resize the image field of the subform editing the HTML on the record template. Do you know a solution to resize images without making the download file to fail? Thanks, Antonio Contreras
How to limit image size from image field in a record summary?
Hello, I am trying to build a Record Summary template to show a summary of a form which includes several types of fields, including a couple images taken from the mobile app. The size of the image in the summaty varies depending on the phone the picture is taken from. Is there a way to standardize or limit the size of the images in the record summary? Ideally, to have it limited by default in the summary, to be able to generate the report directly? Right now I get huge images in the record summary,
Is there a list of keyboard short cuts?
I have looked for the list of keyboard short cuts that is alluded to in other forum threads but cannot find it. Is such a list available?
ToUpperCase Flow
Hy With Zoho Creator, I need a flow to automaticly convert string to upper case. Concretly, when I just finish to complete the field, I need to update the field automaticly in upper case. If someone has the solution and the code... Great thank you !!!
notContains in Deluge
Hello, I need some help with Deluge scripting using notContains function. My form has a checkbox_field with 3 options and a record_status field. I am trying to test for all 3 options being checked before allowing the status field to be updated using On edit>On validate workflow. The design is for script to: if (all 3 Checkbox_field options are NOT checked) { alert "You cannot update record Status until all three checkboxes are marked."; cancel submit; } I have tried a few different script versions
How do I create a link to a pop-up edit window in an HTML view?
I was able to create a link to edit a record, but when done editing, the user has to hit the back button. How to I request that the edit form appear in a pop-up window? EDIT: I'm using a link of the form: https://creator.zoho.com/mathgrad/math-grad/New_Applicant/record-edit/Applicants_Pretty_View/699642000000011710/ I think I can do this with openurl, but is there a way with html?
1 to 1 help
Hi, I've started using Zoho creator and i have followed and understood the basic walk through. I have basic coding skills in VB previously. I'm looking to use this platform to create many apps for work so i would like to progress my knowledge quickly. I was wondering if there was anyone on the forums etc. who has a decent knowledge of using Zoho creator who could help me build particular apps to speed up my knowledge uptake time. Happy to pay $20-$30 per hour or discuss rates. I'm not sure if this
Logic help with Variable not defined please
Can you please tell me why this code comes back with variable not defined. Thanks if (count(Agents[Name == input.Name]) > 0) { rec = Agents [Name == input.Name]; input.Name = rec.Name; openurl("#Form:Agents?Lookup_Agents=" + input.Name, "same window"); } Error at line number : 1 Variable 'Name' is not defined
Serial data in processing window
hi all Lets say i vant to show the value that i can see via my terminal program sent from arduino, and show that in a box in the processing window... In other words, how do i transport serial data in to the processing vindow?? Regards from Denmark.
Passing info from stateless form into htmlview
Hi, I need to replicate the sample below (from an older post). How can I get the script to replicate? Thank you Please refer the sample application: https://creator.zoho.com/sampleapps/employees/#View:Complete_Employee_details. This html page has the same feature. Max Technical Consultant | Zoho Cares
using zoho.loginuser to restrict views
I have an application for employee data and am trying to restrict the view so that the logged in user can only view his/her record. I think I've done it fairly simply by doing the following: Create a field in the employee record called Username and populate this manually with the assigned username Set the Criteria for the view to Username == zoho.loginuser (I seem to only be able to set this properly by editing the script itself, otherwise Zoho adds " " around zoho.loginuser) The view then only displays
Is it possible to print a Map Report as seen on screen using either the print or export to PDF button?
Hi, I have a client who wants to print a map report on C5 as seen on screen. I haven´t been able to find a way to do this, any ideas? Thanks in advance
Create new order without having stock
I'm trying to create a sale in zoho creator whithout having any stock so that it tells me to make more of the item and how many i need, how do i do this?
Fetch Zoho CRM Contact using Deluge
I thought I would pass this along to anyone trying to do what I'm doing. It wasn't working until I contacted support. They had to make some kind of "optimization" on the back end, so your results may vary. Goal Prepopulate a form containing user profile information that is auto-filled from the corresponding Zoho CRM record based on the email address. Also leverage the Zoho CRM field so the profile can be linked directly back to the CRM contact. Method Use searchRecordsByPDC() to locate the CRM contact
Create Proposal button
Hi guys, as a complete Zoho novice but not in code and understanding many other software packages I need guidance on where to start, what step comes first: Example: 4 sales guys who specialise in different areas. (sales guy 1) enters a new lead makes contact and converts to Account & Customer. (sales guy 1) cannot write this particular Proposal, it's not in his field of area. But wants to send it to he three other colleagues who can. I want to create a button in Zoho that will do this. Basically
How to force text to be upper case in a field?
Hey guys, I'm really starting to enjoy Creator and putting my database/forms together. However, I have another question: How can I force all text to be upper case? This field will have a mixture of text and numeric characters. Oh... and how to not allow special characters? Thanks, Joe
All Caps (Uppercase) Actions on User Input LOOP
Hello All, I am wanting to have all the text in a user input field converted to Uppercase. The following does the trick, but then I get a endless revolving arrow icon next to the field. This tells me that it is in a loop replacing the same All Caps data. How do I get the loop to stop. I hit the ESC. button and the revolving icon does stop. Is there a way to have it stop immediately and remove the revolving icon? Here is my current code for the Actions on User Input script. course_all_caps=input.Course_number_section.toUpperCase();
Showing return type message as alert
I have created a custom action for selected records in the report. I am calling a custom function which is returning string message. Now how I can show the returned string as an alert message to the user. I am not finding any solution, Please help. Thanks
Report-Pivot-Chart - View underlying data
HI, when the "View underlying data" is flagged a view related to the specific graph element is opened. This is a very cool function. Is there a way to select what columns let to show and what column hide? tks, Pippo
Fetch Records Help
I have been through several of the pages that describe how to fetch records from 1 form and use in another, but I still am having a problem. Here's the set-up: Form 1 collects the name of projects in Project_Name field Form 2 collects a list of tasks and due dates for various projects. Form 2 uses a look-up field to provide a drop-down of the Project_Name field from form 1 - in form 2, this field is labeled Project - below is the code, which is still returning a numeric value for Project_Name in
Send email with record summary as PDF attachment
I want to create a sendmail function that includes a record summary attached as PDF. My current code is: sendmail [ from: zoho.loginuserid to: input.Email subject: "Email" message: "Email" Attachment: template:OSClientes(Record Summary name) as PDF ] } Thanks in advance
Replacement for JavaScript in HTML Pages
Dear Zoho Experts and Support team, In the implementation of HTML View, many time there is a need raised to use JavaScript, but as Zoho Doesn't support it So I want a replacement for this need, I am used many tricks, like advance CSS3 Animation but i think Zoho also gives a limitation to use CSS3 animation, and the second limitation to use CSS3 type animation is to it is increase the lines of coding, a typical simple CSS3 Animated Image slider will take almost 700-1000 lines, So It will be take
Populating URL with record ID
Hi Guys, I am seeking your assistance, I Have two forms “FORM_A” and “FORM_B”, and need to create a function on the report of “FORM_A” to open “FORM_B” and populate one of its fields with the selected (clicked) record ID from the report of “FORM_A” So far, I have been able to create a function to call a URL to open a form “FORM_B” and populate “FIELD_1” with a fixed value (code below); what I’m actually after is to have “FIELD_1” on “FORM_B” populated with the selected record ID from “FORM_A” report
Problem trying to duplicate an existing app in C5
Hi, I´m trying to duplicate an app I currently have in my account. For some reason after the process is completed the copy does not appear. Is there any limitation for making duplicates? Thanks
Install APP from zoho.com to zoho.eu
Hello, we have account at zoho.eu. With an account created in the EU, can not be login to the marketplace. We created a zoho.COM account and installed app and exported app to .ds We tried an inport .ds file on our EU account. After import the file, the page redirects to the marketplace and returns to the home page of Creator and nothing happens. APP: https://creator.zoho.com/platform/public/showAppInfo?canvasurl=mzxpuwhdg&refererUrl=search%3FappName%3DBasic%2BInventory%2BManagement%26category%3D-1%26limit%3D10%26count%3D1&refererText=Back%20to%20Search%20Results
inconsistency with built in function subString() function
I am trying to generate a part of string which requires subString function. For example If I want to extract between 3rd and 5th index for the word Tamilnadu, I have to do the following x = "Tamilnadu" x.substring(2, 5). a)Since it is based on zero index it should actually be x.substring(2,4) b)in the case of indexing starting with 1 it should be x.substring(3,5) Isn't it a bit confusing?
Graphs on Record Summary/Template
Hi all, Is it possible to insert graphs on a Record/Summary Template? I need to create a record summary to display some medical results on the first page, and a graph with potential risks according to the results on the second page. I'm using Creator 5.
Next Page