In Report conditional Formatting
Hie , I have a bunch of Report conditional formats. They each highlight the next task due when the previous task has a date entered. The color it highlights is based on Task Importance. Here is example what i'm upto:- “01: Courting” call made on Monday. (Already Done) “02: Email” is sent on Wednesday (2 days later) (Already Done) “03: Social Media” will then highlight on the following Monday when it’s due (3days later)wanna skip Saturday & Sunday every time(
Interesting map results
I've been playing around with a map variable, just to characterize how maps work. I want to return a map from a function so several pieces of information can be used by the calling code. Here is what I have tried: map com.testFunction() { testMap = map(); testMap.put("str", "String"); testMap.put("num", 123); testMap.put("bool", true); // info isText(testMap.get("str")); info isNumber(testMap.get("num")); info isText(testMap.get("bool")) ; info if(testMap.get("bool")
Report using a script to calculate Subform data
Hi Experts, I would have liked to be able to add a button to my form so that we can automatically add multiple entries to a subform but a search of the forum indicates it's not possible. Please tell me if I am wrong :-) (Add a start date & number of weeks to the main form, press button and then it then adds an entry for each week [on a Monday] to the subform) On the strong assumption that it's not possible I have a requirement to create a report showing bookings by week/month but that detail is not
Sharing Issue
I have shared an application with one of the user. The forms named Orders, Depot Despatch & Depot Arrival is being shared with the said user but instead of the said forms the user 'piyush257' is able to view Customers form instead of the above 3 forms. Please help. A screenshot of piyush257 is below
Inconsistent search results.
Has this been raised before? I have a database which defines a service, the service name is free hand entry by user. Another user at a later date searches for services based on availability by time and location. I search the database and provide a list of services by name loaded into a drop-down list. The user selects the service by name, I collect that and search the database to recover the record appropriate to the selection. This sometimes does not work. It does not work because of an inconsistency
Limitation of fields in free version?
Hi theres I'm an absolut beginner creating my first form. Can you tell me if there is a limitation of fields (drop down, radio button etc.) I can use in the free version? It always stocks with the word "adding"... Will this Change as soon as I have upgraded? Thanks for the short info and best regards, Pat
Record level permissions in Zoho Creator; how to set
I have a form which will be filled by the same person but depending on the value of a Field (e.g. USA / Europe) the list of users who have permission to view the report changes. i.e. User A should only be able to see fields having Field set to USA and User B should be able to see all fields. Can I set record level permissions of this nature in zoho creator? How do I do this?
Move data from Zoho US to Zoho EU
Hi, I need to host my data in EU. We are Zoho clients already and we signed up with Zoho.com, how do we over now to zoho.eu? Thanks
Add a related record using deluge?
Hi, I would like to add records using deluge so they appear in a subform. For example, if I have a company form with a subform relating to a contacts form, I would like to programmatically create contact records so they show up in the correct parent record's subform. I can create records with deluge OK, but can't work out how to create the relationship. I saw a similar post to this from 2013, but nothing since. Thanks, Andrew
Select a random record
I'm trying to set up a web page (view) where I can select a random record from a report and display that record only. I want the record selected to change randomly each time the page is loaded. Can anyone think of a way to accomplish this?
How to send invoice in mail with image from zoho creator.
This is my invoice in gmail. Al value is ok. When i send mail with image then automatic create a link. This is the link. When i remove the link then show my image. I want to know that why create the link. And how to solve this problem. Thanks
Creating a SMS Sender ID for zoho messaging.
We are looking at using sms to notifiy external users on the progress of their on-line application forms. I have created a test function which can send an sms to a designated phone. In real live I will take the phone number off a form and pass that to the SMS send function. However we would like a sender ID to appear instead of the default sender phone number with the sms message so the recipient knows it's from our company. Is this possible with the ZOHO Creator default sms facility? if so where
Pick List
I have created a form with City as a field. I have it as a dropdown with imported cities. If a city is not in the list, how can I add it without editing the app list? Can I script it such as the "+" plus sign?
Fetch Records from a form using a multiselect
Hi, Looking to see if anyone can help. I have Form1 that has a multiselect on it I have some records in Form 1 that have options added to the multiselect (say a mix of option1, option2, option3, option4 etc) I have Form2 that has a dropdown populated with option1, option2, option3, option4 etc When I select an option from the dropdown I would like to get into a collection the records that contain that dropdown selection. Currently I was trying to work with: <variable> = <form> [ <field> <opr> <expression>
Identify Workers Not Assigned Any Tasks
Hi - I have an application that assigns tasks to workers. Form 1 collects the employee name, and Form 2 assigns tasks with due dates to employees, using a lookup field from Form 1. I would like to create a report or page that identifies any employees who do not have any tasks assigned to them. Please let me know if you have a solution to do this. Thanks.
Auto Populate a lookup field based on a User input
HI I have a form "Despatch" with fields 1. Despatch_ID 2. A lookup field named WH_ID (Linked with a form named Warehouse) 3. A lookup field named Material_ID (Linked with a form named Material) and some other fields I have another form for taking arrivals of material in Warehouse. The form named "Arrival" with the fields 1. A lookup field named Despatch_ID 2. A lookup field named Warehouse 3. A lookup field named Material_ID and some other fields. When i enter Despatch_ID in the "Arrival" form, I
How to consume api data in zoho creator work flow
I have an rest API with user name and password I want to consume that data in zoho creator but i am not able to do so. any video would be preparable? please help me out.
VOLUNTEER PORTAL
I am currently using VOLUNTEER PORTAL under ZOHO CREATOR and I have added new categories for the volunteer registration sheet but I could not find all of the "volunteers' answers in the database. How will I find the full profile of the volunteer in the database? Thanks :)
dropdown selection for zoho page (simple html code write selection to zoho variable.)
Since scripting is not working properly in zoho pages We need simple code simple dropdown selection writes selection in a zoho variable. Zoho_Variable = "null" //Here dropdown lis code will come Select a value dowpdownselection1 dowpdownselection2 dowpdownselection3 Selection_var = "One of user selection" //if user select 1 and Zoho_Variable =Selection_var; I try to describe very basic way hope you will get what I mean. can you give us a proper working coding of this small
How can I remove unused custom Functions I've declared?
Hi all, I declare all my business logic in custom Functions, then I have 1 point to change if the logic needs to change. Anyway, I've built up a lot of these functions, and some I no longer need and they are cluttering up my lists... This being said, how the heck do you delete custom Functions you no longer need? Thanks kinly Check out my Android apps, they're free - http://goo.gl/ludism
How to Efficiently Enforce Unique Values but With a Filtered Context? Good Ex: Parent 1: AB, Parent 2: AC, Disallowed Ex: Parent 1: AA, Parent 2: CC
I'm looking for the most efficient route to script in a validation which requires all tag numbers for a Parent record to be unique, however, the tag numbers can be reused among different Parent records. Example of good logic: Parent 1: Tag #1 Tag #2 Tag #3 Parent 2: Tag #1 Tag #5 Tag #7 Example of disallowed logic: Parent 1: Tag #1 Tag #1 - Must be unique per Parent Tag #3 Parent 2: Tag #1 Tag #5 - Must be unique per Parent Tag #5 Now I am quite advanced with Deluge and I could simply grab all
Trying to set a rule that if a cell is blank, to pull in the number from another cell in the record - help! :)
Hi all, I am currently mapping out daily sales of different products on an hourly basis to start to get a feel of sales velocity. This data is recorded on an hourly basis per product, under ascending fields named stock_remaining_1, stock_remaining_2, stock_remaining_3 etc... I am looking for help with a formula or rule that will state the following: if stock_remaining_3 is blank, then add the number found in stock_remaining_2 Any ideas would be super helpful - I don't mind if this is a rule added
Issue on select a picklist in a subform
Hello, I have a form with a subform. In both of them y have a dropdown. I need to select an option by code. For example: In form I have the Dropdown whith values a,b,c. on add, on load I use the code Dropdown.select("a"); to select the value "a" . It works. In subform I have the Dropdown whith values d,e,f. On subform, on Add Row the code row.Dropdown.select("d"); to select to select the value "d". Id does not work. Zoho creator say: Error at line number : 1 'Dropdown' does not exist in this form
Variable Defination in page URL
Hello There I have a page created and I wanted to define a variable value in URL here my example report url in zoho creator https://app.zohocreator.com/saldo/appname/#Page:Report_Page_Q1?Date_Selected = Year_Q1; but his does not work since I have to declare Date_Selected in the page some how Like this Date_Selected =""; so this decleration re-write my URL parameter so paramater would eliminate. so I decided not to declate variable in coding but in that case I can not use the URL variable Any
Passing form ID to a lookup's "Add New Entry" form
I have a "Project" that has been created from a form On edit of that project, a lookup field becomes visible In the lookup field, I want to add a new entry In the form that loads in the popup, I want to pass the (source) Project ID to a hidden field With the Project ID, I can then populate other details on the new form On Add I can't seem to figure a way to get the ID of the form the lookup is adding the new entry from. Any suggestions?
Relations in API calls
Hi, How can you fill in values for relation fills when manipulating records from the API? The GET value you get from the API is the display value of the form, not an ID or anything. So, what to fill in there from the API? Will it just work if I put the related element ID? I'm using the XML-RPC API. marc
Find records with matching time/date and other criteria
I have a travel booking application. I wish to check all future bookings to see whether any journeys on the same day also are either starting or ending in the same place. I can use the post code field to establish where journeys are starting from and ending - UK post codes are split into two parts and I wish to use the first part only which specifies the general area. I want to identify all bookings where the journey times are within an hour of each other and where either the origin or the destination
Page Link URL paramater
Hello There in zoho createor we have created a page. Page uses different variables in it but we need to change one of variable value as url parameter. for example there is a user_var variable contains all data realted to this user. and all page values connected to this variable. We dont want to create different pages for eac user but different url address for each of them. for example if the original page adress is https://app.zohocreator.com/salesdoc/aplicationname#Zom_Page we need to create
maximum function in page
Email_List = max(1,2); /returns 2 Email_List = max(1,2,3); /returns and error message Error at line number : 1010 Number of arguments mismatches how can we find the max of more than 2 numbers? in zoho creator page creation
Getting URL of a current HTML page or Form through deluge?
Is it possible to get the URL of a current HTML page or Form through deluge? Sriram_sierez
Can't duplicate main application
Hello- I cannot seem to duplicate my application titled "Operations". Support editing privs are enabled for you.
Fractions vs decimals
I need to program a form where if a user enters a decimal number a fraction is displayed, and vice versa. How can this be programmed? There does not seem to be generic support for fractions. Thanks!
Zoho Cretor Getting error {"message":"Invalid Ticket Id","code":"4834"} when trying to insert records in Zoho CRM
Hi Gurus, I created a sample application to integrate Zoho Creator and Zoho CRM. I followed the instructions here: https://www.zoho.com/creator/help/script/creating-a-record-in-zoho-crm.html. Didn't work. I'm getting {"message":"Invalid Ticket Id","code":"4834"} when I submit the record and click "View Log Details" afterwards. Which Ticket? what is that and how to I fix this? thank you very much.
Upload file on Custom Action
Hi all, I am working on a report for which I created a custom action button to change a status of a record and send an email notification. Ideally I'd need one more step - a prompt to a user to upload a file. Is there any way to accomplish this via custom action? Thank you in advance!
Creator app permission
Hi my creator app is not working for my zoho one account, permission denied?
Parent-child (foreign key) relationship between forms - just can't figure it out in Creator
Hello Zoho support - would someone be able to look at my application to tell me what I'm doing wrong? I am modifying the Order Management app in Creator. I have a subform in Product called Add/Edit Items.. this is where I scan in individual serial numbers of the products. There is a lookup field in the subform, but for some reason it is just pulling all of the IDs of all the Products, not just the one in the parent form. I'd like to use this relationship and show the parent Product's part # in the
How to Add to Fetched Records?
I have a function that checks to see if an issue is overdue. If it finds any, it sends an email to a fetched set of people who indicated they want such emails. I would like to add the person to whom the issue was assigned to this list, even if s/he did not so designate. I tried fetchedUsers:ui.add(Users[Name == violation.Assigned_To]); but I get an error saying I can only try this in [ON-LOAD].
Access zoho people data!?!?
Is there any way for creator to access zoho people information??? It's a very common use case in any business to access the organization data, user's manager information, etc. Why is this not a thing yet? Very disappointed!!!
Iterating lookup values
I have the following code which iterates the results of a search. I then want to display the results. The field Species is a multi value lookup field... <%{ SpeciesCV = Studies [ID != 0];%> Species<%for each RowV in Studies [ID != 0] {%> <table > <tbody> <tr> <td><%=RowV.Title%></td> <td><%=Species[ID = RowV.Species].Species%></td> </tr> </tbody> </table> <%} }%> The problem is RowV.Species only returns the list of IDs. I found a suggestion to use <%=Species[ID = RowV.Species].Species%>
Fractions vs decimals
I need to have a user enter a fraction and display a decimal, and vice versa. How can this be programmed? Thanks!
Next Page