how to compare values or look values Using zoho creator
Hi I am a Master Dealer from different CELL PHONE companys. I have this situation: In my position I can not follow my activations per Resellers. My Master Agents only give me at spreed sheet of Activations serial numbers. But I dont know which reseller activate x -serial #. I want a data base of my Clients Resellers where I can assign serial # inactivated. Then when I received my excel activation report. I want to upload the excel activation report to my zoho data base and run a report that
Creator Form
I need to know if I can set up a form in Creator that collects certain information from one individual, then have a second form generated that would contain the info from the first form and have additional fields to collect more info from another individual. The second individual can not have access to change the information collected in the first form but I need them to be able to add additional information on the second form so it would generate a complete "ticket". Is this possible and how do
Making a button change form content without editing.
Hello, I´m trying to maka a database in wich I store the status of a record. The status may be "Aproved", "Disaproved", "Retry". I need this status to be changed without entering the EDIT mode. So I´ve created a Function and asigned to a button, but I only get the status to change to nothing instead of the desired state. This is what I´m using: void Aprobar(int id) { rec = Posteos [ID == input.id]; rec.Estado = "Aprobado"; } Thanks! Gastón
GET request to view records not working
I'm using the free version of Zoho to try to get records but I keep getting the error : 'There is no such view in Zoho Creator' or 'an error has occured. It has been reported to Zoho support.' My GET looks a bit like this: https://creator.zoho.com/api/xml/UploadOfferForm/view/Sheet1_View?authtoken=********&scope=ZohoCreator/creatorapi&submit=View Records The view and application names are both correct as far as I can tell. (and I am re fetching the auth code at every requesty) Can I use this stuff
How to receive undelivered email notifications sent through SendMail Deluge script
If I send email using the SendMail function of Deluge script, is there a way to receive undelivered email notifications? Example: sendmail [ from:zoho.loginuserid to:bad_email_address@bad.com reply to:zoho.loginuserid subject:"Hello" message: "Hello" content type:HTML ] I want to receive the undelivered email notification at zoho.loginuserid.
HTML <input type="password" ....> equivalent possible?
Would any one know how to hide characters in the user input (say with an 'asterix' like in a password or a bank-account-number field) on any field? Many thanks. -Varun.
Formula problem "variable not declared"
I have a field that calculates feet of garden row based on number of plants and spacing of them. I can't seem to get the following formula to work: ( no_of_plants * plant_spacing / no_of_plants_wide ) / 12 I keep getting an error that the variable is not declared. Tried deleting field and re-adding then recreating the formula, no luck. Also tried rearranging the the fields in the formula. Keeps saying that the first field name in the formula isn't declared. Am I doing something wrong? How do
Cannot share application
I attempted to share my application by clicking Share and adding an email address. After I click Invite, the window remains open and the message on the bottom still says "This application has been shared to none" I tried to manually share the application by clicking the Manage Users link, adding the user and checking the application. There was no indication that the changes had been made. The person received an email invitation to share the app. But when she clicked the link and created a login,
Unable to delete application
I want to delete an application but it seems that I am unable to do so. I want to delete the "test app" application that I created on 10 September 2013. When I click the "X", I see a message "Please wait" but nothing happens. Application: https://creator.zoho.com/essistmgmt/test-app/ Can you please investigate why I cannot delete the application? It is available for support editing.
Username and password
So I have installed a zoho form on my Wordpress website using the plugin. The form requires a sign in using a zoho username and password. On a previous screen I collect user information in a Client form. Is there a way for me to collect a username and password from my clients and pass that to zoho so they can sign in on the next screen? Thanks.
double column form
Althought there is an option to have a double column form, that doesn´t seem to be working. After clicking on this option, a second column appears on the screen, but I cannot move any of the fields to it. What am I doing wrong ? Thanks
What is a record?
Hi Guys, What is a record for Zoho? Is it an individual entry into a field or is it one full set of data into one form? And if I update one or two data fields in a form, id that counted as a record too?
Prevent Creator using https
Hi My app has been working for fine for years at the following URL https://creator.zoho.com/rsoftley/ast/view-perma/FINAL/ but now I've discovered Firefox and IE are causing massive problems with secure pages that mix secure and insecure content. Whenever I go to http://creator.zoho.com/rsoftley/ast/view-perma/FINAL/ it redirects to the https version - is there any way to stop that from happening or another way to fix my problem? Thanks Robert
change order of forms displayed in section Forms
Is it possible to change the order that my created forms appear in the Forms section ? Every form I create goes to the bottom of the list. Thanks
can user add new choice to existing drop down list ?
Hi, Can user add new choice to existing drop down list ? This added choice will be permanent in the list ou not ? If so, how should I do this ? Thanks
Submit Button
I have a stateless form and I want to do an update not and add when you click the "Submit" button any info on how to edit that would be appreciated.
Color
Hi. Would it be possible to color code entires according to a field. For example, for my phone message db, if a call is new, it would be red, if follow up, green, and if archived, yellow. mariano
More about ampersands
There is quite a few old posts about using ampersands, but I fear there is still an issue with these. I have a 'Property_Name' field in my 'Properties' form which allows users to use the '&' sign in the text. However, when they do, the following does not work : message = "#View:Assets_Report?Property=" + property_details.Property_Name; openUrl(message, "Popup window", "height=800, width=600"); In all other instances, it works fine. If there is a technical restriction to the use of ampersands,
Auto fill sub form from main form
Dear all, Please help me with the duluge for this problem: 1. I have 1 form containing all Car information (such as car license plate number, etc) or Car Info Form 2. 1 have 1 form for Car maintenance form with subform of spareparts usage form. 3. In the Car maintenance form, i have a drop down lookup to Car License plate on Car Info Form 4. When i fill in the subform for sparepart use, i want the Car licence plate field on the subform to be filled with the chosen car from the main form. Please help
Simple update website form
here's the particulars of what I'd like. We need to build a form to update the elements/fields on this page this is the page. http://template.qbprocessing.com/about-us.html Avatar (image of face) Your Name Years in Business Business name Street Address City, State, Zip Free Initial Consultation Phone: Phone Number Fax: Fax Number Email: email address Web: BusinessPhone Number Then be able to update the bullet points under these "headers" Professional Credentials Certifications Industries Supported
change application link
Is it possible to change the application link, the part that comes after http//:creator.zoho.com/ ? Thanks.
Permalink to HTML view with embeded zoho views
Hi, Is it possible to open, trhough a permalink, an HTML view that contains other embeded zoho views? For the embeded views I am passing parameters in the URL in order to filter the records. I can open the HTML view but the embeded views don't seem to work. additional info about my application: My application is called: Sistema de Operaciones Yaxche The Form used to open the Permalink is: Registro (when clicking the "Enviar" button) The Permalink is meant to open the HTML view: Proyectos_Cliente
Problem sharing an application
Hello I've been developing an application but have run into a problem with sharing. I have shared all the forms and views a user would need to access and use the application but some of the shared forms do not display correctly when a user attempts to open them. The problem forms are meant to be opened when a user clicks a custom action in a view. The custom action builds a URL query string that opens a form and display a specific record. The URL displayed appears to be correct but instead of displaying
API/Deluge Limits Do you have hints and tips
So I am hitting limits (500 API calls and 5000 Deluge Statements) quite regularly, I just wondered if people had any suggestions. This is my position: I have a variable list of CRM Account ID's which has been built up in a previous step. My app needs to go and get Account Data and Related Case Data and Opportunity Data, when I have say 10 ID's it s not much of an issue. its just 30 API calls (10 for each module) and may be 300 statements to process for output etc. But with 200 I hit the API call
New app builder
Another bug. When using the script builder in the new app builder, for some reason using the list function 'tolong()' is not being recognized. I switch to the old builder and it works fine.
Duplicate App
I'm trying to duplicate one of my applications but only get the error message 12002. What to do?
Passing parameters to a function
I have a function that is called from two different Views. The function opens a stateless form. When it is closed I want to return to the calling view. Is there a way to tell where the the function is called from? I tried adding another parameter to the function but in the view the only option for parameters are fields in the view. Is there an option to type a string for the argument? Herb Wexler
Using dynamic authtoken or static authtoken
Hi, I have a website that integrates with Zohocreator using its API. There will be many situation where there will simultaneous use of the Zoho Creator Application through record additions or updates from the website. Is it sufficient to have a static authtoken or would it be better to have dynamic authtoken (an authtoken is generated everytime we want to add or update the record)? Hope to hear Regards
Pop-up Display
This seems like very basic question, but: I want to write a function which gets called as a Custom Action. In that function, I want to display a list of records in a pop-up window. I can't see any Deluge functions that allow this to happen. Is this possible? And if so, how? Thanks Alex
Account information related to contact
Hi there, I have two fields in my ZCreator form. ZCRM contact lookup. Link for account. When I select a contact from contact lookup field the corresponding ACCOUNT should be present as hyperlink (full details on link click). How can I achieve this in ZCreator? Thanks.
HTML page as email content
I need to send an html page (based on my app's data) as an email content. (the html page itself works great) I tried doing so as it says in this help page - https://www.zoho.com/creator/help/script/send-mail.html by copying all the html code from my zoho page, to the message content in the "deluge mode" (send mail task) It doesn't work. Anything I'm doing wrong here? Is there a limitation on the html code length when sending it as a mail? Is there any other way of sending an html page as an email
Default parameters for custom functions
I think it would be very useful for default parameter values for custom scripts functions. Can you please add this feature?
Multiselect
How can i use the value of a multiselect to display a subform? The subform is hiden and i want it to be shown if in the multiselect field i check one box
Why Has Zoho Been So Unreliable In Production
Over the last few months, we have experienced repeated serious production problems with Zoho - each of which Zoho admits was their fault. Why can't Zoho understand the importance of protecting their users who have applications in production. In mid-March, the link between Zoho and Paypal failed and Zoho was not being updated with Paypal transaction information. According to the problem resolution that I received from Zoho Support, the problem was traced to a new server that was put on-line at Zoho
I have a number of my records showing "0" in the record's ID
Hi, I have a number of records showing "0" in the record ID...why is this the case? Would it be possible to have a unique ID for those records? Records
NEW BUILDER ... terrible script debugger
So if you write buggy script, instead of telling you there is a bug, it says "script saved" but doesn't really save it. I lost about 20 minutes worth of work just now, because I assued script saved meant script was actually saved. But just as I was about to test it, I noticed my own error. l = Lesson[ID == input.thisLesson]; clear Student; for each s in l.Students{ if(s.status == null) { Student.add(s); } } Student is subform in Lesson it says "script saved on this"
Cannot duplicate application
Greetings, I am unable to duplicate my application. The name of the application is AdhocAds Sales Tracker. I have shared the application with support {at} zohocreator {dot} com any help you cna provide would be greatly appreciated .
Can you combined all your items together.
Its too confusing for the average business owner to go from CRM to campiagns to others. cant you just combined them and allow it easier use?
Field in CRM not updating
Hi, We are using a creator form to capture leads and send them to Zoho CRM. I have mapped several fields and it works just fine. Except for the one marked with red, that one does not update in CRM. { "First Name" : input.First_Name, "Last Name" : input.Last_Name, "Email" : input.Email_Id, "Leads Source" : "Blog", "Lead Owner" : "dk@2base.com", "Lead Status" : "Newsletter", "Country" : "Denmark", "Language" : "Scandinavian", "Description" : ("input.Want_to_receive_newsletter + \n\n") } The form is
Zoho creator slow for anyone today?
Loading pages forever ... on different computers, different locations. I'm so frustrated already looking for replacement to Zoho creator.
Next Page