Auto-Field Updates
Hi everyone, I'm new to using Creator and am confused about how to accomplish something. I have created a call-tracking form that fetches contact records from Zoho CRM. I can't figure out how to auto-update the next field, which is the customer's account number; this is a field in CRM. Does anyone know how this can be done? I have checked different help articles and am still confused. Any insight would be greatly appreciated. Xavier
Fetch Data from 2 different form?
Hi people, I'm newbie to creator and deluge, I'm following forums and help center and creating a application for my business needs. I have problem with fetch datas. Let me explain the structure that I have create and ask questions I have 3 different forms and; First form called Courses, it has 3 different single line text fields to explain 3 features of course (1st one name, 2nd one group, 3rd one Semester) And second form called Students; this form has student information and course information,
Zoho creator: How to add a record from a vb.net forms application
Hello, I am struggling for one day and I hope someone can help me. I try to add a record from a windows forms application using vb.net. This is my code: Public Sub addRecord(ByVal ht As Hashtable) Dim apiUrl As String = "https://creator.zoho.com/api/<xxx>/xml/<appname>/form/<form name>/record/add/" Dim xmlStr As New System.Text.StringBuilder xmlStr.Append("<input type=""hidden"" name =""authtoken"" value=""abcdefghijk"">") xmlStr.Append("<input type=""hidden"" name
Function works only for one field !?
Hello All I created function to fill 2 fields with current infos in the report when button clicked to update instead of ask user to refill it , Function works well but with one field only , I don't know how to make it work for 2 fields when use " &" or other symbol error message appear , when use " +" no error but all string come in one field , Patient_Secludes void progress(int ID) { (this one working) a = DrNote[ID == input.ID].Patient_Secludes ; (No working even added after comma in
Looking for some one to build me a Data Base and CRM ASAP
Hi, I am looking for some one to build me a Data Base and CRM ASAP who can do it Skype gabigeva regards GG
Pass information from one form to another
The reason for my mail is to see if you can help me in a development that I am doing. The main problem is that I need to pass information from one form to another, through global variables or functions, depending on the case, I would like to know if there is a way to do this, and that my action is executed when you press a button or similar. Thanks!
'item' is a lookup field and child fields cannot be accessed
Hi, I have 2 forms First with product name and rate second quantity and amount i want to multiply rate from parent form field with quantity of child form field and display in amount field. Please help new to zoho creator.. I get "'item' is a lookup field and child fields cannot be accessed" error thanks anand
Cryptography Function (SHA-1)
I need a function that calculates an HMAC hash from a Date String as the value, a shared Secret Access Key (both the sender and receiver have this key), and SHA1 as the hash algorithm. Why? This is a simple way to verify the authenticity of information. For example, if you send an email to a client and included the hash as a "signature", the data can be validated by the client. There are many instances where this would find value. SHA1 is a standard cryptography method Many APIs require a hashed
Problem with Lookup Function
I created a form which does a lookup for PO number from another form, this works fine, however when I try to lookup a second field which contains the PO Name information from the same form using the first lookup results as a filter I get a type mismatch saying I can not use that because it is a BIGINT format, but it was created as a string. Why is is converting this and how do I get around it, or alternately how do I bring multiple fields across in a lookup function and display them in separate fields
SOS! specific entry can't be edited - user gets error
Hi Zoho When trying to edit entry in Loan_Valuations form (ID=2983417000014531035) - when trying to edit from the report, I get time out - when user try to edit using a link, she gets the following message: Loan - Vessel Valuation We failed to retrieve this form. An error occurred when we tried retrieving Loan - Vessel Valuation. This error has been reported to Zoho Creator support. created a duplicate of the entry, same problem please let me know how to fix Ravid
Creator Report with Zoho Invoice values
Hi, I would like to create a Report which include a value from Zoho Invoice. May I know what approach should I use? I read the manual of the custom function feature, but look like it is not I want. I would like to get an Invoice total amount and list it with every records on my Report, assume I already input an Invoice ID for each record. Thanks Mike
How do I control column display in a subform?
My subform was created as part of the main form - i.e., it does not appear in the Dashboard as a separate report. When displayed inside the main form, it's displaying every column in the underlying form, and I don't want that. How can I control the columns displayed in an embedded subform? I can't see a way.
Error when creating function - on fi
Hi Zoho, when creating a new function I got this weird error. why? Thanks Ravid
Customer Portal Customization
When using the customer portal, is it possible to directly alter the HTML for the template. For example, if on the sign up page I want to change the "Name" section to say "Company Name" instead, is that possible. Also, how would I directly alter the CSS of the template? Thanks in advance for your responses!
Relationship Between Forms and Subforms for Reports
I am trying to generate a report that simply shows me the sum quantity products sold. Form Name: Order: - Name - Address Subfom Name: Products: - Product - Quantity How do I generate a pivot chart report that gets the data from the subform? When I try to generate a report from the Order Data, I do not get the fields of the subform, and vica-versa. How do I run a report of this data with relationship? It seems the subform model is very broken because the relationship
Show Percentage as a image
Hi I am looking to put a percentage value in a record template. It would be nice to have this as a graphic. So rather than showing 10% i show bar with 10% filled in... So a graphical representation of the value. Is there any way to do this in Zoho? Tony
How to change the width of a spreadsheet report?
I have a report with display type as spreadsheet. As we know, we can change the width column in List-Grid display type. What about spreadsheets? There is no menu 'change column width'. Maybe with a 'hack' CSS way in a HTML report? UPDATE from Manual The options to Add, Modify and Delete records will be displayed only if the Edit permissions are provided for this report, by the application owner. A Spreadsheet report does not support Set Grouping, Custom Action, Record Summary and Set Column Widths.
API Call Error - There is no such form
Hello, I am trying to make an API call to my Zoho Creator application to get the field names of a form to display in a mobile app. However, I am getting the following response: <!-- $Id$ --> <div style="text-align: center;vertical-align: middle;font-size: 14px;margin-top:150px;">There is no such form in <a href='/'><strong>Zoho Creator</strong></a></div> Here is the code I have written: var url = "https://creator.zohopublic.com/api/json/gymfinder/playerregistratation1/fields/"; var XHRResponse
Translation doesn't work with the new theme
Hi, I have six users and i pay $50 additional for each user to have the "Translation" option. Unfortunately, it doesn't work on the reports tab and it shows the drop down values as it is. Are you going to fix it soon or i need to change to the old view. Because the old view is very old and reports' options are not nice and not easy. In addition, i can't duplicate my application at the home window. I am looking forward to hearing from you. Best, Rami
Webhook/DB query/DB cache timing issues.
So On Create webhooks are firing before the data is populated/available, so when I send a Sales Order to my creator app I can't use it immediately which is causing my creator side stuff to die. Strangely enough if I put the same query in a REST client and send it to the creator app it works fine, every time. Is there an internal caching of db entries that the webhook hits or maybe the timeout is too short and it won't wait for the update?
Quick "On User Input" Question
I have a field that I want to to an action when the value has changed. Is there any way to know what the previous value of a field was? Field Name: Carrier On User Input input.Send_Email_to_Carrier = "Yes"; How do I test against the previous value? Hypothetically... if (previous_field_value.Carrier != input.Carrier) {//actions} Any help would be great. Thanks!!!
File Uploads from Local Computer and Google Docs, but no Zoho Docs or Dropbox?
At this link: https://www.zoho.com/creator/help/fields/uploading-files-and-images.html it states "The File Upload field type is used to upload Files in Zoho Creator. Files can be uploaded from your local computer or from any of the supported cloud storage services like Zoho Docs , Google Drive, OneDrive, Dropbox and Box ." But the Browse Options at that page only show Local Drive and Google Docs. What am I missing?
Columns missing in Pivot Chart/Table
Available Fields for Selection (Missing): Actual Fields in Form:
Records sent to 2nd form
I have one form that creates records when filled out. Is there a way to have some info from that record automatically get sent to a second form and add an entry there? I want that second form to be populated with entries from the first form but also other manually entered and imported records.
Pivot Table not showing fields.
I have an employee form with some fields. Now I am going to create a Pivot Table report for that form. And In report creator its not showing all the fields that are available in form. I am stuck in this and don't know how to show all fields. http://prntscr.com/aeo99p http://prntscr.com/aeo9li I have also used "Column Properties", but nothing happen. I hope you have solution this. Thanks
Report Column Not Sorting
Hi I have a report based on Form A. I have also included a date field from Form B. The report is working fine, except I cannot sort asc or desc by the date column (the one coming from Form B). Is there a trick to getting the data sorted by date in this instance? Thanks.
Drop Down Menu Search Breaks on Dynamic Drop Down
Hello. I have a dynamic drop down menu set. On mobile, when I initiate a search within the drop down, no results show for my en try and I have to back out of the application in order to have the results refresh. Thanks, B
How do you show / hide fields based on a group
Hi Could you please help I have some control fields that are used by admin staff to control a users permissions. Such as setting the type of user in the portal, business user, general user, etc. I cannot let the portal user see this information or edit it. I do need the admin logged in users to be able to change it. As field permissions only all "Everyone" or "Admin" (I would have loved this to be a user group - but I cannot find it) I am using a method of show and hide. I can turn on access for
Android Creator app login
I am having trouble signing in on my mobile phone – I am new here and this is the first time I am trying this. I am set up on Creator on my desktop and built the first demo. I am trying to sign in with my phone# which is on file, and the correct password. I can sign ok to my computer but not to the phone. This phone number is on my profile – I am entering just the 11 digits phone# exactly as it shows in the profile, tried all combinations with and without the (+1) that is on front of it.
old. values of subforms fields
Hello, Does any one knows how to access the .old field values of subforms fields in the validate event ? Thank ! Pierre
Enable or disable subform fields based on another subform field
Hi there I have a form with subform setup. On the subform I have dropdown field - i want to enable or disable another field on the subform based on what value is chosen on the dropdown field - is this possible? I have seen in the forums from about 5 years ago you could only enable/disable subform fields from the on add/on edit of the main form, but am hoping that this has now changed. Thanks Aaron
Seeking developer
I am part of a team of roughly 20 people. We have three tasks that must be completed 7 days/365. I would like a task reminder that notifies the team when the task has not been completed as well as a team email that informs us that the task has been completed. For each of the three tasks, there are three people that are responsible for completing them. The three people for each task will often change on a daily basis. I need it so that if the first person (primary person for that day) misses
Does Show Field To Admin Only setting on forms apply to reports or views?
If a form field is configured to "Show Field To Admin Only" and that field is used in a report is it supposed to show to everyone? I have a URL field that will be populated through Deluge as records are created and updated. In this case the field should not be visible. For reports I do want the URL field to be visible. Thanks
Custom icon for Zoho Creator app when accessed from iOS
I have an application that I'd like users to be able to access on the iPhone (via the Creator app). That works find if they load the Zoho Creator app and then select the application, but what I really want is a simple way to install my app so that it has its own icon/shortcut. I'm sure it will have to access the Zoho Creator app behind the scenes, but I don't want the user to have to remember that "Zoho Creator" is how they get to my app. It's a confusing extra step. Is there a way to do this?
Setting the height of a multi select list
Is it possible to set the height of a multi-select, lookup field on a form? I tried the instructions here (https://www.zoho.com/creator/help/fields/setting-field-width-and-height.html) to no avail. The height setting is missing. Here's a screenshot of the form field in question: Here's a screenshot of the field properties. Note that I have tried changing "field size" to be other values, including custom. It just change the width. Any help is greatly appreciated.
Updating Value of Checkbox On Edit -> On Success
Hello, I have a list of checkboxes, like Notifications: First Email Second Email Third Email i want to update(check/tick) the 1st option "First Email" when "if" condition gets true. What i have done so far (On Edit -> On Success) if(input.Email == "xyz@email.com"){ Notifications.select('First Eamil'); } This doesn't work. I am getting the alert like this "'Notification' can be used only in on load actions". This works in "On Edit -> OnLoad". But i want to do it in "On Edit -> On Success". Kindly
"Approve / Decline" notification when data is edited? // field and form name as a variable?!
Hi Zoho, I need to create some verification system when certain users change data in a form. So when the user tried to edit data in a form, I will get a notification on the mail with an option to either approve or decline the change (decline = no change is made, approve = the field gets the suggested data). I thought about creating a "Change data form" that will be auto-filled and sent via email when an edit is suggested. in order for this to work properly, I need to have variables used for the
"Allow HTML tags" is missing
I want to experiment with adding conditional scripted cell colors on some views. I understand I need to check "allow HTML tags" in the app settings. However, this checkbox is MISSING in the app I am working on as well as one other app but it present in 5 other apps I have created. I cannot understand the reason why it would be missing, however, when I try and apply HTML tags to cell text, the HTML tag is shown in text, which is, of course, not what I want. Any ideas here? DJ
Error: The remote server returned an error: (400) Bad Request. -Zoho Creator XML RPC API
I am trying to use Zoho Creator XML RPC API. and I always get back an error which is above. I send to this url: https://creator.zoho.com/api/xml/write/woodcliff-rewards/Rewards With this postcontent: <form method="POST" action="https://creator.zoho.com/api/xml/write"> <input type="hidden" name ="authtoken" value="xxxxxxxxxxxxxxx"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <textarea name="XMLString" > <ZohoCreator> <applicationlist> <application name="woodcliff-rewards">
Alert won't pop up on "On Validate"
Hi Zoho, I have an alert that needs to pop up when a form is sent. This only to inform the user, I don't want to cancel the submit. The alert does not pop up. Why? Thanks!
Next Page