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
Beware of Editing the Form Definition!
The form definition is found under a form's workflow. There are two options to view and edit it: without action, and with action. With action shows all the submit code and on-user action code. Without action just shows the underlying form fields. I just discovered that if you edit a form definition's "without action" part and save, ALL the SUBMIT/DELETE code is deleted. There is no warning about this effect nor an option to revert to a saved version. Unfortunately, this has set me back a few hours
Custom Action Configuration
I have been configuring my Custom Actions so that they appear in the Show Action in Edit Drop-down Menu I decided to try the Custom Action so that they appear in the Show Action in Report Header (execute for each record) The menu of Custom Action now appears, but the action is not ... activated. Any ideas on what to look at to figure out why?
Summary View via iphone
Is it my imagination, or does the summary view not work with an iphone?
Grouping application names by folder
How about making it possible to group applications into folders when they are viewed in your sign-in windows in the iphone app as personal apps, shared apps, workspace apps. If you have created a lot of apps, you have to scroll to see the rest of the apps. The apps are arranged in the order in which you created them. That means that a new variation of a certain app will be placed far from the app it is directly related to, because the original app was created earlier. For those developers who create
Add comma to record summary in report
Hello. I have created a record summary invoice template in a report. I would like to add a comma in the currency field. Currently shows $1200.00 would like to show $1,200.00. Thanks
Problem with edit button in a Report
Dear All, I have an HTML Page and I embedded a form and a report inside of it. As you can see when I am trying to delete a record the 'window' with the Delete, Duplicate, Print options is working like this. So, it is not possible to click the Duplicate button because when I move the mouse the window is lost. I tried it in Chrome and IE but I had the same problem. Any ideas?
checkbox tally
How do I tally the number of checked boxes in a multi-checkbox field?
Make Sign Out show the user's email address, not the zoho user name.
Signing in using a zoho account username has been deprecated (although you can still do it). Most people sign in using an email now. People are confused about their username showing up in the sign out link. I get requests all the time to change it to their email address or change their username to something different. The request is to make the sign out link the user's email, not username. Cheers, John Whitney
Scanning QR codes or Bar Codes to input data into form
Can you load a form, then scan a QR code so it then inputs the data into a field? Please help, if this is possible it would be of massive benefit to our company.
Customizing published report and form to mobile friendly.
Hi. As stated above, is there any where to make published report and form (especially report with long field column) to be mobile friendly. This is because the publish thing is not for us to use and we are aware that most of our customers are using mobile phone to browse alot. Thanks
Allowing users to import data through the report view.
Is there a way to enable the import option to appear for a public report view so users can upload a CSV / Excel of data?
help on for each
Hello everyone, I need to detect the inserted records a day by a single name. So I have: Form1 : name Form2 : name lookup + another field so , for each rec in Form1 And here ... I should tell him to count me the number of records for a single day but I do not know how many are the days .... Ideas ?
No access in China again
The access in China to the Zoho.com suites has always been intermittent since several years ago. Recently it has been more frequent. Some days in China we can visit zoho.com OK. Some days the creator.zoho.com suite does not load at all. Maybe it's high time you guys put some image servers in China????
Creator API - Update a record value
Trying to use the API to update a record in a view with a POST : https://creator.zoho.com/api/xml/student-record/view/myob_invoice_line/?scope=creatorapi&authtoken=xxxxxx&criteria=(ID == "1612333000000917031")&newvalues=field name = Job_Code value=1234 What is wrong with this request syntax? This request returns a zoho creator webpage.
Warning! All your profiles are inactive.
Just upgraded from free to standard and now my users cannot access the app. It is shared and they are Admins. My project has come to a standstill. I see this error dialog "Warning! All your profiles are inactive." and the users see "You are not allowed to access this application. Please click here to login as a different user." when they try to login.
Filter Embedded reports in HTML page
I have a page that has 3 reports embedded in it. When i put something like #Page:Display_job?Job_Number=8 in the URL the 3 reports continue to show all records. How can i make the embedded reports show just the Job_Number records and not show all records? If I put /#Page:Display_job?Job_Number=8 in the URL for each of the individual reports it works fine but not when they are embedded in an HTML page. Thanks
Subform View in Mobile App
The list view for all subform items in the mobile app shows just the item ID (which is a long ID number). Is there a way to display another field instead of the ID?
Add new lines to a Note<field>
I have an app that is a parts order form. I'm using a stateless form to input information. As the user selects and adds a part to their order I would like to have the items ordered appear in a note field. The action of ordering a part happens when the user "clicks" on the [Form Action] Add [on click] I've tried the below code, but nothing appears in the note field. for each r in Temp_Parts_Order [Tech_ID == User.Employee_ID] { input.Pending_Order = input.Pending_Order + r.Description + " " +
Zoho Creator - HTML view used as a form with javascript
Hello, I'm wondering if it's possible to create a HTML page View that would be used as a form with javascript? I would write in that page: <script> function myFunction() { //send request to external website (or ZohoCRM) and receive response data //if ok then: alert("Your request was successfuly processed!"); } </script> <form ...> <input type="button" onclick="myFunction()" value="Submit" /> </form>
Time and date format
Is it possible to change the time & date format to 24 hours instead of am/pm ?
Time Lapsed since Last Record meeting criteria - script Question
I figured out the problem and found a solution: The sort by Added_Time desc; actually calls the record you are creating, so if you really want the last record before that you need to insert the criteria ID<input.ID (as shown in the corrected code below). test = input.Person; LastRecThisPerson = ThisForm [(Person = test && ID < input.ID && Added_Time == today)] sort by Added_Time desc; if (LastRecThisPerson.ID == null) { input.LapsedTimeInHours = 0.00; } if (LastRecThisPerson.ID > 100)
Next Page