LookUp Dynamic Filter
Good day for you, I have a Subform with 2 Lookups, I set a filter for the second Lookup based on the first lookup selection, I script that when the user add a row the first lookup take a value for the parent form, the problem is that in this scenario the second lookup filter doesn't work. This filter only works if the user select manually the value in the first lookup. Is there a way to set filters for this second lookup thru deluge? Best Regards,
passing parameter to HTML View in Search Field
Hi, I have a HTML View and I am using a OpenUrl task to reload the parent window after on Success action of another Popup window . What I am having trouble I would like to retain the search keyword in the search field which is applied before reloading the page. See below screenshot for your convenience ... Screenshot 01 : Here you can see there are Two search result before on Success action of another form. Screenshot 02 : After adding new entry of another form the above search result will contain
Problem with adding Number field
Hi, I cant add to the form i created (by Zoho creator) "number fields". The message i got is "adding..." and nothing really happen, its stuck without doing anything. Can you please check the issue ? Thanks, Cory R
action for printing
Hi, I am working on a simple app that manages warehouse. The user should input some data about a pallet and getting a printed label with these data on it. Printing will be done on a common local laser printer. I suppose I shoul use record summary to generate the label. I would like the printing process starts automatically after data insertion, any idea about this? Thank you
Verifying Lead ownership in Zoho Creator
Hi All, We are considering using Zoho Creator to update the Lead Module of Zoho CRM. At present, our secure users log into Wordpress using a username and password. I would like secure users to update cases they are working on - from within Wordpress - but need a means of verifying they are the user ascribed to an individual Lead record. The secure user will login into Wordpress and then enter: Unique case of Lead record number originally generated by the CRM. Surname of the client stored in the Lead
conditional pick list
Hi, I am using creator and in my application I want to offer three drop downs to select vehicles. So the first drop down may contain "Ford" as an option. I need the second one to contain a list of Ford models (such as Focus or Mondeo) The third one needs to have the door for the model picked before. Any help would be great here please. Thanks Dave
Problems Duplicating applications
Hi I have seen a few threads regarding this, but no solution. I am trying to duplicate applications in my Zoho Creator account. Zoho Creator indicates that an application is being duplicated, and when the process ends, no copy of the applicaion is found. Please assist. Tal
Manual restore of data to app
Is there an easy method to reload your app with the CSV files that are created in the backup process? It appears I have to re-map all the fields in all the files and wonder why the exported csv columns don't simply match the new db structure. Am I missing something? Thx!
forcing a UI refresh (Form and Field events) from a function triggered in a view
We've got Zapier integration nicely adding new records into our app. However, when the records are added, the UI functions are not evaluated, and as such some of the values we compute during a normal On Add event are not completed. We could always duplicate the calculations into a Function. Instead, is there a method to trigger the UI events against a collection of records using a Function triggered from a view? Thanks in advance
Email data - Authorization failed
Having issues emailing data into my form. The form is published, still get the error. Tried it using the admin zoho email, and other emails, none are working. How do I fix this?
Pdf that is emailed is different from Exported Pdf
Hi Experts - I need some help. If I manually export a view as a pdf by using the gear wheel button on the top right, the pdf looks really nice and it reflects the same formatting as the view. If I set up a daily email with the same view as pdf attached, the pdf looks horrible. The column widths are all different and it is very hard to read. Does anybody know how to set up an automatic email that send the same pdf that I exported manually? I struggle to understand why there are two different formats
No split function in string methods?
Hello, i would like to have a confirm that there is no split function in string methods in Deluge. I have written a custom function that use getUrl function to get data from an external service, the response can be very long (each value on a different row) and it would be really useful to have the capability to split the response string in an arryay for each single row.
Lookup fields that can lookup each other.
I have two lookup fields on FORM1 pulling information from FORM2. I would like it if these fields could lookup each other. Example1: If a customer service representative knows the customer number and selects the number from the Customer_Number field on FORM1 then On User Input would pre populate with the information from FORM2 into the Customer_Name field on FORM1. Example2: If a customer service representative knows the customer name and selects the name from the Customer_Name field on FORM1 then
Emailing a record from within Zoho CRM
Hello, So I have created my app in Zoho Creator and connected it to Zoho CRM. I was wondering if there is the ability to email a record to a contact from within Zoho CRM. Thanks!
DB Structure / Multiple Lookups Question
Hey there, I'm trying to build an order management system and I'm a little new at this. Here's what I'm trying to figure out: Each item we can order comes in multiple sizes Each size for a given item has its own pricing Pricing is based on the quantity in an order, with different combinations of item + size having different quantity breaks As an example, say we could order Flour in a 20lb bag or a 50lb bag. The 20lb bags are $10 each if you order 1, $9 each if you order 3, $8 each if you order
String
I need to accept a string of 8 characters and in the On User Input field action I want to add code to simply put a dash between the 4th and 5th characters. In other words, if the string is entered or imported as ABCDEFGH then I want to convert the string in field to ABCD-EFGH. Here's the code I added to the On User Input field action for a field named Course. s1 = input.Course.subString(0,3); s2 = input.Course.subString(4,7); input.Course = s1 + "-" + s2; This code does not work at all. The code
zoho creater / zoho projects
is it possible to integrate a zoho creator form into zoho projects? thanks best regards eike
Does Zoho Creator integrate to Zoho Projects?
I'm new to Projects and Creator and in looking at Creator product page I do not see a reference to Projects integration. We would like to create a page for users to enter a project that can then be picked up by an administrator or manager and made into a project.
reports calendar does not work
Good morning , reports with a calendar view does not load the data but the records are loaded if I open the report in perma view ; in this case , as I edit a record, the reports can be recharged without making me see the records again . How can I do ? David
Zoho Date Discrepancy
Hi, On a lookup field referring to the Added-Time of a record, I noticed that when I set the filter to only show records from Today (Zoho creator: Added Time) it will show up correctly on my computer but on my mobile app on Android it will filter dates from yesterday instead. Both are logged in using the same zoho account and the system times are both correct and same. Any ideas as to what is going on? Thanks.
Access Denied!!all My data has disappeared
i am unable to login into my account. It says access denied. I had stored 1000s of records in my application. It is all gone. When i contacted the support team through email. They they are working on it. It has been over a week and they are still working on it. I had shared the application with colleague. He is also unable to access the application. This is a very serious matter for my organization. This has been a big disappointment.
Checking for unwanted characters in text input
I'm surprised I can't find an answer to this one. It MUST be possible! I have a text input field called IDname1 I want people to create a username in this field. However, for various reasons I need to make sure that certain characters aren't used in this username, including # and & and @. I've tried all sorts of variations of if statements using .contains and .getOccurenceCount but I just can't get anything to work. Can anybody help??
Zoho CRM Lookup field not working in Chrome, works in Firefox
Steps to reproduce: Add a Zoho CRM field to a form in Creator (for Account or Contact) Access the Creator App in Chrome Attempt to lookup an Account or Contact using a Zoho CRM Lookup field Pop-up window of Accounts or Contacts appears Click on Account Name or Contact Name to select Expected result: Account Name or Contact Name populates Lookup field Actual result: Nothing happens and Pop-up window does not dismiss This does not work in Chrome on my Chromebook, Chromebox and Windows 8 Chrome. Current
printing from iOs or Android
Hi, any idea about printing directly from iOS or Android App?
Not receive the invitation email.
Using Creator I created an application called Questionario.
I added 233 users authorized to use the application : many users have regularly received an email invitation , while the last few 40/50 did not receive the invitation email .
I tried to select a few names among the unconfirmed user and select reinvite , but the email still does not arrive.
This is my Plan Details
Current Plan : Professional Express
Total Users : Unlimited
Active Users : 233
What could be the problem ?
Android app - Force Close
I've installed the native android app on two Motorola phones (Droid X - 2.3.4 and Droid X2 - 2.3.5). Both apps force close on startup. I get the login screen, after entering my gapps name and password, the app crashes. I've reinstalled several times with the same result. Any help appreciated. Thanks, Joe
how to rename user's username?
hi how to rename user's username? for example, rename "zoho_m1121" -> "user_m1"
How to expand / collapse fields in forms
I am creating a form where if I click on check box, certain fields on the form get visible. I have seen on certain apps on marketplace. Not sure how can this be done? Any help would be appreciated
Inserted record formulas not calculated initially after insert.
Hello, We have several functions that insert records into a form. The form that the record is inserted into has many formulas fields in it. After inserting a record none of these formulas initially have calculated as expected. When viewing the record in an html view the formula fields are null. When I edit the record and change one of the values that the formula in calculating based on, the formula recalculates to display the proper value. How can i get these formula fields to calculate properly
Purpose of PreSubmit?
Just wondering: What is the purpose of the PreSubmit code added to the form definition for some forms? Thanks! :-)
Potential Bug for On Submit Task
I'm creating a time card system. Case 1: When users submit time for projects already reported I want the form action to update time rather than create a new record Case 2: If a project is not reported yet, the form will create a new record reporting project + time. While I can do this with a stateless form, I need features of a normal form (validation, "Add" button on record view) The the structure of my on submit code is as follows check = time_entry_form[((month == input.month && project == input.project)
calendar view not displaying properly
Hello people I have made a view with a display type of calendar and the first column is not displaying all the text that is supposed to display and there is room enough to display the complete Name. If I change the view to list type the column is displayed proper. Here is the formula I use to display the first column: (((((Begin.getHour())) + ":") + (Begin.getMinutes())) + " ") + Name The result in list view = 19:0 Manon Brouwer = 19:0 Jan van den Braak the result in calendar view = 19:0 Manon =
Get the prevoius row data in subform
Hi How to get only previous row data in subform Thanks Satya NHM
CANCEL: Custom Action with OpenURL of form not working when triggered from Spreadsheet View - the form never displays
This simple custom function works fine when triggered via Custom Action from a List view, via the Edit menu: void TSCG.new_lead_from_inquiry(Inquiry this_inquiry) { openUrl("#Form:Lead" + "?Inquiry_ID=" + this_inquiry.ID, "Popup window", "height=550,width=900"); } (It simply opens our form to create a new Lead record, and passes a parameter.) However, for a similar view of the same object, defied as Spreadsheet view, and a record is selected -- although the Custom Action choice does show in the
Report builder screen never comes up when trying to create a pivot type report
I am trying to create a pivot table report with Creator. I select New - Report - put in the report name, type is pivot, based on ..., where to store it and click on the create button. All I get is three flashing dots. I let it run for over an hour and still only had the three flashing dots. The report builder screen never came up. I tried it again on a very small table (18 rows) and got the same result. I've tried it logged into Zoho with the owner's sign on and with a developer's sign on. Same
Publish form limit?
I am receiving an alert that I've reached my publish limit and need to upgrade my account. There is no mention of a publish limit in any of the subscription details. Where can I see this info?
Security Issue with Customer Portal
Sign out shows the user name in customer portal Please remove that feature for the same reason you removed it from normal zoho creator Cheers, John Whitney
Customer Portal Bug
Selecting "cancel" opens the wrong iframe Then you get Cheers, John Whitney
Attach non input file to email triggered by change in workfow status
Is it possible to attach a generic pdf document to a zoho email that is sent once a field in a form is updated - workflow status The attachment is not uploaded as part of the form e.g. I have shipping instructions that I want to attach to an email once the workflow status is changed in the record by an admin user I know how to attach and uploaded doc to an email (input,filename) but not one that has not been uploaded Preferable to send the document but also happy to send link to download document
View or hide selected records
I'm new to Zoho and databases in general. I get how to create forms, reports etc, edit records and so on. This question is going to seem pretty basic I'm sure, but what must I do to simply view or hide a record within a report? I'd hoped that there would be a checkbox available that alows the record to view or not. Any help with this greatly appreciated.
Next Page