Can I randomly sort a view?
Hi there! I have a view / report listing potential penpals which is embedded on a website. People are more likely to choose the people listed on top of the list, which I think is based on how recently the record was added or modified. We would like every penpal on the list an equal opportunity to be selected, so we would like the ability to randomize the way the records are listed. Can this be done? Thank you! ~Reed
Confirm nessage before executing a custom action
Hello, do you know if it is possible to add a classic confirm message before executing a custom action? Something like a javascritpt confirm "Are you sure?" (Yes or Not). Thanks
Zoho Creator - Zoho CRM Zapier link
I have a number of zoho creator forms. I have set up Zapier triggers to zap over the information to Zoho CRM. It works fine with a manual entry to the form. However, when I imported from a spreadsheet into one of the form databases, it failed to trigger the zap of data over to Zoho CRM. I have questioned Zapier and they can find no error on their end. They said "It appears that possibly the API does not support spreadsheet uploads". and suggested I contact Zoho support. I have not heard back from
Sort in For Each Statement
Hi All, I am using the Deluge "for each" statement in a script but I need to treat my records in a certain order. Do you know if I can use a "sort" statement within my "for each" ? It does not seem to exist. Any workaround ? Many thanks ! Guillaume
File Upload Tool
The Zoho FileUpload tool which allows for the bulk upload of files into a File Upload or Image field is not allowing me to login to any of my applications. Is anyone else who uses this tool seeing the same problem? Is there something wrong on my end or is the application broken?
Unable to Connect to Messaging Server
I am constantly getting this message in Zoho Creator. I have not set up any SMTP messaging server or mapped any custom domains.
Help with permission of field
I want certain fields to only be accessible to certain users in my company. When I click on the "Show field to" under permission in the field properties, it only shows 'Everyone' and 'Admin Only' Hew can I add individual users to this list please. Thanks
text field limit length
I have a form that gets filled out by a posttoUrl. Basic information , Name Address etc.. Recent changes in the data has my text field for zipcodes getting the zipcode +4 . I need to validate the text field is only 5 characters and eliminate anything after that
Using 1 field to pull multiple fields from another form
Hi, I am very new to this program and I'm hitting a few roadblocks. I'm trying to look up a name on one form, but I need to pull a few items that is in the record into my existing form. For example, in the first form, I am using a look up to find the doctors name that is is the second form. Along with pulling the doctors name from the second form, I want to pull his credentials and city and state into the fields and prepopulate those fields in the first form. Help! Thanks! Trish
Import File Exvel
Anybody know what is the limit of records that can be import from Excel file? I need to import a document with 19000 rows in Excel and I'm not sure if Zoho allow this.
disabling a mandatory field
Hi, I have a form in which I am using the hide and show features to customize the form fields according to the selection made in a lookup field. This functionality is working fine, thanks to advice from the very helpful forum community. I have three fields in the form that are mandatory: -Vineyard -Grower -Lot Depending on the selection made in the lookup field that customizes the form fields through the hide/show feature, either: -Vineyard -Grower or -Lot is displayed in the form. For example,
Deleted data
Is there currently anyway to retrieve any data once deleted? Can I become a paying customer and then have this service?!!!!
help with script please
I have created a customer database When I wrote I put number field for tel.No. it misses out the leading 0 So I have created new tel no field using single line All works fine apart from me having hundreds of entry's in old telephone field that I want to move to new telephone field. I wrote a function to do this but I cant get it to save Can anyone help please. Function reads as follows....... void telnos() { for each rec in Jobs [((ID is not null))] { input.Mobile = input.Mobileold; } }
Default setting for Rich Text field
is there a way to have a default value for a Rich Text field? For example, I want a table in the field. I tried loading the table into a notes field, and then having the RichText field = the value of the notes field, but that didn't work
Deluge Script Disappearing in HTML Views
Hi, First time I have used HTML views was yesterday and I was finding them very powerful and had screens working perfectly, however this morning I have looked and lots of the deluge code is now missing! Seems to be the <%=rs.X%> in the cells of tables. I am using Chrome on a Mac. Has anyone had this problem? Thanks Gordon
Validate that file name of upload is not a duplicate file name? SOLVED
(FormName[File_upload == input.File_upload].count() > 0) doesn't seem to work. Neither did (FormName[File_upload.contains(input.File_upload) == true].count() > 0) Any suggestions? (And as usual any help will be greatly appreciated!) SOLVED IT: The problem with the above attempts was that ZC adds a unique string of digits prefix to the front of each File_upload field string to differentiate that file from files uploaded to other records which might have the same file name. The solution
Need to combine 2 fields together
Hi, I am trying to merge a date (Start_Date) and a time (Start_Time) field into 1 field (Start_Date_Time). I need there to be a soft return between the Date and Time in the combined field. So, first, what kind of field do I use? I am using a multi-line field so I can create the soft return in the field. Any help would be appreciated. Thanks! Trish
Creator embeded form look up fields are transparent?
I want to use a zoho creator form on my webpage but i need a way to modify it's appearance. You can see my form on my webpage below. It is in the orange footer at bottom of page named (Boat Selection). http://precisionsails.mybigcommerce.com/ I cant seem to figure out why the drop down fields are transparent. I want them to have a white background, not transparent, how can i change this? These are lookup fields in my form. Also is there something i can do to have the menu that drops down appear up
Is this kind of workflow possible with Zoho Creator
I’m currently evaluating Zoho Creator and am just wondering if you could point me in the right direction. I have a process I’m trying to move out of lotus notes. In a nutshell: User fills in a form with a few details: Product name Product supplier Price This form is then sent to a department for approval. If they approve it, they add a code (free type) to the form. The form is then sent on to yet another department, who do something else with it. At this stage, we need to save a copy of the completed
hide command not hiding fields
Hi, I have a form named stage with the following field and data: -Stage -Grapes -Fermenting -Juice -MustI have another form named Analysis that contains fields that I would like to hide in function of the stage chosen. For example, if the user chooses "Grapes", I would like to hide all fields except Brix and pH. To test my syntax, I have only been trying to hide the "Lot" field. I have used the following to try to accomplish this: if(input.Stage.toString() == "Grapes") { hide Lot; disable Lot;
Editing the email contents in automated email notifications
I'm trying to setup a form to notify different email addresses based on the zip code entered in the form. The email notification needs to have the form data in the email body. I try to update the email notification with the HTML code below but it doesn't save. Name: <%=Name%><div><br></div>Email: <%=Email%><div><br></div>Zip Code: <%=Zip_Code%><div><br></div>Phone: <%=Phone%><div><br></div>Contact Method: <%=Preferred_Method_of_Contact%><div><br></div>Service Needed:<%=Service_Needed%>
Empty Records?
Everytime I go into the zoho software creator, I generate a blank record. How can this be avoided? Thanks, Mike
Problem with Bulk Edit
In some of my reports, certain users are allowed to edit or bulk edit data. The single edit part works well by bringing up a window of my original form not displaying hidden fields (action completed using the hide/show feature). However, when the user selects bulk edit, ALL fields are listed for the user to edit. I also notice that the Edit Only Visible Fields option is no longer available on the reports in new application. Is this the reason all fields are being shown on bulk edit?
Set Filter Error
Hi, I have a form called block that contains: vineyard & block fields. I also have another form called analysis which contains vineyard and block look up fields. I am trying to filter the block lookup field data based on the vineyard selected in this form. I initially got a type mismatch error when I tried to do this: I then tried using .toString() function which eliminated the error but does not show any data in the block field when I run the app. If I use an actual name in the filter-i.e. "Rotta
Form cut off time? Select next business day.
How would you change a submit date field (input.Submitted_Date = zoho.currentdate;) to select the next business day if it is after 5:00pm central?
Does Creator API record update method work?
Urgently need to verify if updating a form via the API works. Trying to follow the documentation, I am wanting in this case to update the Payment_Status field in the Invoicing_Record form for a single record https://creator.zoho.com/api/<owner>/json/<application name>/form/Invoicing_Record/record/update/?scope=creatorapi&authtoken=<xxxxxx>&criteria=(ID = "1612333000000810121")&Payment_Status=Paid in full This request POSTS ok (200 response) but returns output of the Zoho Creator home page or something.
Alphanumeric Code
I want to create a code field for my application, and it should look like P100 P101 P102 and so on... i have no idea how to do this in deluge scripting...i am just a beginner....can anyone help me in this regard?? Thanks in advance!!!
Creating if then statements in Creator
I'm working on a Daily Report in creator and want to create full automation. For example I have a drop down on work types (In office or in field). If an employee is working in the field I want the "in office" fields to zero out for hours worked. I have been able to create rules that if an employee selects "in office" as the work type then the "in field" fields are removed. However, I want the "in field" inputs to automatically go to zero if the "in office" field is chosen. Thanks in advance.
SMS TWILIO
Hi, I am trying to send an SMS to patients to tell them when their medications will be delivered. I want the message to read: "Your medication is scheduled for delivery on input.Date_For_Scheduled_Delivery. Then I want the message to read as follows. To cancel or reschedule text back. 1= CANCEL 2 = RESCHEDULE TO NEXT DAY AFTER SCHEDULED DELIVERY 3 = RESCHEDULE TO TWO DAYS AFTER SCHEDULED DELIVERY I want all these 3 options to be on different lines. Here is my code below. I don't know what I am doing
"You are not allowed to access this application."
I created an Application with user A. I've shared it with user B. User B can see the application when she logs in but when she clicks on the app it say: "You have logged in as <userBemailaddress>. You are not allowed to access this application." The user is active on the zoho creator settings page. All the forms are shared with the user. I've tried to remove the user and all of her permissions and re-add but still no luck. What is weird that it was working yesterday.
From MM-DD-YYYY to MM-DD
I have a field that is a standard date-field (no type), for birthdates. I want to have a 2nd field that shows only Month and Date (eg, Dec 22); what field type should this be?
ZOHO CRM to Zoho Creator Criteria Issues
I am able to push data from Creator to Zoho CRM and create new records and edit records that have been added to Creator. I can also push data from Zoho CRM to Creator using webhooks to create a new record when a lead is added to the CRM. However, I can't get edits in the Zoho CRM to update records in Creator. I think the issue is in the webhook that calls the function. I don't know how to add the required criteria to the webhook.
Shared user edit permission
How do I give my shared users edit permissions. All the posts are a few years old and shoe the old system Thanks
Getting Data from two fields into a multi-line field
Hi, I am trying to combine 2 fields into 1 field automatically when the two fields are updated. Basically I have a "Start_Time" field and a "Start_Date" field that I need to combine into a "Start_Time_Date" field that will have both displayed in the one field. How can I pull the information automatically into the multi-line field with a soft return between the two fields. Any help would be appreciated. Thanks! Trish
Working with a table inside of a note field
I'm developing a inventory system for service tech's. As a tech places a manual order each part is displayed in a note field as they click on "add". With different part names it becomes messy very quickly. I've inserted a table inside of the note field. How do I place the ordered data inside of the table in a note field?
Huge problems using webhooks on Accounts
I created a Workflow rule to execute on CREATE using a webhook and followed the instructions https://www.zoho.com/creator/help/api/rest-api/rest-api-add-records.html and had new account details copied over to my Zoho Creator app. I then disabled the CREATE workflow rule and created a new rule to execute on CREATE or EDIT and setup the webhook in the same way. This resulted in a new account being entered in the Zoho Creator app whenever a CRM record is changed. Initially I thought that EDIT would
Deleted information
Can I recover deleted information from the database? I deleted 4,000 titles by accident.
default field entry
how can I have a default field entry for a new record be the same as the previous record? Thanks in advance
Extra charters appear in note field
I'm using a note field to display a list of parts ordered. When the from loads for the first time and no parts are in the Form to display it is good. Once a part is added to the Temp_Order Form I get this. _________________ Parts Currently Ordered _________________ null12v 12amp hr Battery 100088470 1 /> "null" appears at the beginning of the line and a close tag "/>" appears at the end. I've cleared the input.Pending_Order_Note = ""; before anything is written to it and removed the ending tag "<br>/>"
Numeric field format
Hello, how can I format numeric field to look like 123.123,56 (dot as thousand separator and comma as decimal separator)? Also, I would like that numeric filed value has right alignment. Thanks in advance
Next Page