Problem with zohocreator.exe import
When using zohocreator.exe to upload csv files into a form, there appears to a file naming convention issue.. For example, the following command picks up all the PS* csv files in the same folder Eg : zohocreator.exe c:\myfolder\PS2.csv john mypassword -e order-management -a Order_form imports PS2.csv as well as PS1.csv There also seem to be some issues when Excel is open, but that might be related to the above. The above error is adding incorrect records to the form - please advise.
Auto update child form when parent form data is update?
Hello guys, I'm really in stuck with this issue. Here is the scenario. App: apparel costing system. Form 1: Material which have Fabric {cotton,silk,fleece..etc} Price {100,200,300,400..etc} **100usd/1kg for example Form 2: Product Costing which have Product Name Norm {0.3,0.4,0.5} **0.3 mean 0.3kg/product Fabric : lookup from Form1 Price: fetch record from Form1 with criteria form2.fabric == form1.fabric Fomula: form2.fabric * norm (product price) Everything quite good when create new product calculation.
Assign Pay Rate to Team members
Hi, I have a workAssingment app that i use to assign tasks to individuals or to Teams. my issue is that not all individuals are paid the same rate and not all teams are comprised of the same people. Also, pay rate per job varies. Thank you.
Can't generate private permalink
Hi support, I haven't use creator for a long time, and I can't generate the private permalink rite now. Suppose the url look like this https://creator.zoho.com/2217098/education/view-perma/aboutus/Q3NK0G00nsTDaxzrZbBCWCdSRprgxQ9aDuq7mRj1m7ObAt1kfymNU4ENKmOprQJEVhgTyXAgPTmW3V but now look like this https://creator.zoho.com/2217098/education/view-perma/aboutus/ZC_PUBLIC_REQUESTED/ how can i find the code? Thanks.
Can I access database information from my website?
Here is what I am trying to do, will this software allow me to do this? I will have a basic database of names and contact information that I would like a page on my website to pull from. For example if I push someone to www.mypage.com/janedoe that page will pull basic data fields from my database and fill them in. It would be different for each page. Will Creator allow me to interface with my website?
Conditional formula not working
Hi I am trying to use conditional formula in my form to calculate a value from 2 other fields in my form I am using if((Chargeable > Weight),Chargeable,Weight) to calculate Price. But it always returns the Weight value instead of the correct one. Chargeable is also a formula that is calculation by multiplying 3 other fields in the formula. Weight is just inputted. Please help. thanks Antonis
Tables in zoho creator forms
Hi, Is it possible to add a table to a zoho creator form? In my case, I need users to enter a balance sheet to a form. The data entered will then be calculated and presented in different formats. Thanks for any help!
Is user activity tracked and how do you report the info? And how to backup application data on daily basis?
If users edit and delete records, is this information tracked? How can it be reported? Do I need to code tracking specifics? Is there a way to automatically backup record data?
User parameters
Good day, I'm waiting with impatience when you will make system table (or Form), where developer can see all users with access to application, and developer can create fields in this form (like in other forms in zoho) to assocoate different parameters with users (and also lookups to existance forms). And very important is to have ability to use this extra user parameters in criteria fields, deluge scripts and so on. So, for example, if I have add "group" field to this Users parameters table, I can
View application under specified user/group permissions
Hello! I'm very missing feature to access applications under specified user/group permissions. It's very usefull to understand how application is looked like and can be used for some users. This mode can emulate only permissions, userlogin and userloginid can be real
Passing parameter to form field
Hi, Anyone know how to passing parameters from View to the Form and theirs field using script? I know this metod with URLs, but I want to use script for that. https://kbase.creator.zoho.com/forms/passing-parameters-via-url
Can't Use Lookup Fields in Reports?
I have a form with a bunch of lookup fields in it. I'd like to create a report on this but in the report builder non of the columns that are for the lookup fields show up. Do reports not allow use of these fields? Is there a work around for this? Many thanks! G
Where is publish option?
Hi, I checked tab "Developer Zone" but i can't find option "Contribute your apps to marketplace" (as per the help @ http://zohocreator.wiki.zoho.com/Publishing-applications-to-market-place.html) plz help me.. i need to transfer the application to my fellow team member who will be working no onwards. A quick reply will be highly appreciated.
how to itterate through items of a multiple select list on related form? help me understand for each with lists
I have a Child form, with fields Last_Name and first_Name Parent form has from called Children which is a multiple select list .. picklist to Child form In Data form, drop down field to select Parent, and a Notes form called listOfChildren to display list of Student names. listOfChildren = myParent.Children gives me a list of Child ID's like 12234233, 1231342 I need the children's names John Smith, Jane Smith (given that John is First_Name and Smith is Last_Name
zoho.loginuser to show full name instead of username
Hi, Can the command zoho.loginuser show full name instead of username. I have several field which i want to default to the user that can then be changed to other users (full name) that are in our system. We are using our system internally so the users will be set up by an admin therefore there wont be users accounts that doesn't match our list. Thank you in advance!
When ZC can support safari or iPad?
Hi When ZC can support safari or iPad? Thanks Stanleyguo
An If statement based on the difference between 2 fields.
How would i go about writing an if statement to says if (x is +/- 1 or more of y) { Do this action } else {}
Upload files to Writer.
We know that Creator is not integrated with Writer,Sheet,Show, so if I want to upload files to Writer via Creator Upload field and Writer API, how should I do then ?
How do I control the defualt pop up menus in a view?
The menu for delete, add, edit fields that comes up in standard list view, how can I hide it? Or just allow view?
Line numbers are wrong in HTML view error messages
Hi Zoho, I want to alert you to an issue with the error messages for HTML views. The line number reported in the stack trace is incorrect. It seems to reset every time I break up deluge script with an %> It makes it very difficult to debug code in HTML views.
broken link in creator help
http://www.zoho.com/creator/help/fields/add-notes-field.html link to " Display Custom Error Messages" goes nowhere
Sign-up for Free Page
When a new user is directed to "sign-up for free", the sign-up experience for the user should not also be used to advertise zoho email and the zoho newsletter. I just did a test run with a new app and this is the feedback I got: they found it confusing why they would be making a new email address and what this newsletter is all about. Otherwise the sign-up experience within the application context is good. Cheers, John Whitney
User Input with digits and letters?
Hello, i have this code: if (!(input.Galileo.toString().matches("^\d{3,4}$"))) { alert "Office ID Galileo should be between 3 and 4"; // cancel submit; } but it only work with numbers, how can i get him with letters and numbers? regards Carsten
Workflow is causing data duplication in Creator
I setup a workflow alert following https://lounge.creator.zoho.com/tips-and-tricks/fetching-leads-from-zoho-crm-into-zoho-creator-automatically set for created or edited record, the data is copied across to Zoho Creator. However if the record is edited again it will recreate the record in Zoho Creator. Is their a way of preventing the duplication and still having the Zoho creator record updated. I tried not allowing duplicate records for the name field which results in an email saying data can not
New Form Builder Suggestion
It seems to me the new form builder should have a delete button to delete to form rather than going back to the dashboard to find and delete the form. But, also leave the delete function on the dashboard. Also, if there's an error when attempting to delete a field, the pop-up should hyperlink to the section in question as a new page. Cheers, John Whitney
How can I display a BOOL checkbox field as 'YES/NO' rather than 'TRUE/FALSE'?
KNIG02 - Jacqueline - Knight - 1 - 0 02-02-10 0 false Toothpaste KNIG02 - Jacqueline - Knight - 1 - 0 02-09-10 0 1 false
Reports security
Can I set certain users (non-developers) to be able to create their own custom reports while other users can only view? How is is done?
Need help with a very long form
Hello We are creating a form to be able to capture all the educational history of a few children we take care of, but the form is getting to long and hard to complete. Is there a way for us to create different forms to update the same table and the forms should be launching one after the last one is complete. For example we have inside the form the following sections: General information, Parents information, Education, Psychology results, Etc. Can we separate all this forms and at the end be able
How to create a view filter for a field that is populated from zoho.currentdate.getYear()
I have an income-expense form with a field called "Year" that is populated by On Add -> On Load -> "input.Year = zoho.currentdate.getYear()" I created a view that will print and serve as a report. The view contains the Year field. I need to be able to filter this Income vs Expense view based on the record in the year field but not a STATIC year (ie Year == "2013"). The user will not be able to edit the view and so will not be able to create a new static filter each time the year changes. What
zoho calender events created in zoho creator
so using zoho.calendar.createEvent to create events, but what if I need application to be able to modify or delete events? is this updated? https://www.zoho.com/creator/help/script/create-an-event-in-zoho-calendar.html
I dont understand or fail to cURL to postUrl
Hi, I have this [PayPal] example of cURL: curl https://api.sandbox.paypal.com/v1/oauth2/token \ -H "Accept: application/json" \ -H "Accept-Language: en_US" \ -u "EOJ2S-Z6OoN_le_KS1d75wsZ6y0SFdVsY9183IvxFyZp:EClusMEUk8e9ihI7ZdVLF5cZ6y0SFdVsY9183IvxFyZp" \ -d "grant_type=client_credentials" I want to use postUrl and did the following: headersMap = map(); headersMap.put("Accept-Language", "en_US"); headersMap.put("Accept", "application/json"); detailsString = "grant_type=client_credentials"; responseMap
Script New Views ?
Can we script a way to create new views when we add record or contact. As I add new customers I would like to have their view and share set automatically . Form A has data in column x is customers name. I am currently making all customers zoho users but I only allow them to view and edit records that pertain to them . When I add new customer in Form B is there a way to automatically create their personal view and add them as a user or do I need to do that manually every time . I have 125 to add
Password or access code fields in forms
Are you allowed to use password fields in your forms using zoho creator now? I had an expert creating forms for me on zoho creator and he was turned down for trying to use password fields. My competitor also uses zoho and has password fields. I let Zoho support know about this one month ago and they said they would look into it. Now they are using access codes instead of a password field. Is that allowed? This same website also has a backend login on www.tootir.com and has a username and password
How do I change the checkbox BOOL field from 'TRUE/FALSE' to display 'YES/NO'?
KNIG02 - Jacqueline - Knight - 1 - 0 02-02-10 0 false Toothpaste KNIG02 - Jacqueline - Knight - 1 - 0 02-09-10 0 1 false
Dropdown and filter
I have the following problem: I have a database shared with different users that have the option of editing and adding contacts. I have many entries with dorpdown entries just because we need to filter the information. My problem is that the information in those dropdown field may vary according to the needs. For example, add a new name of a company that is new for us. The problem is that when the users want to add this new information and have to add it in a dropdown entry, they can not do it (it
Dropdown and Filter
I have the following problem: I have a database shared with different users that have the option of editing and adding contacts. I have many entries with dorpdown entries just because we need to filter the information. My problem is that the information in those dropdown field may vary according to the needs. For example, add a new name of a company that is new for us. The problem is that when the users want to add this new information and have to add it in a dropdown entry, they can not do it (it
'like' operator in query
Is it possible to use 'like' operator in a query? If not, is there any plan to add it, when? Thanks!
Import Data By Email
When importing data by email is there a way to import more than one record from the mail e.g. I want to import all orders for the previous day so my email looks like Customer:ABC Product:123 Qty:1 Customer:XYZ Product:456 Qty:2 The only record that gets imported is the last on
Add record to other app after record is updated through XML-RPC
Hi Guys, I have two Applications created with Creator. Application A (App_A) and Application B (App_B) I'm using PHP and XML-RPC to add records to Application A. Now I want 2 things to happen: 1. When record in App_A is added with XML-RPC I want another record to be created in App_B 2. When record is updated in App_A I want another record to be updated in App_B My question is how can I access other Apps using deluge? Is it possible at all? I cannot use different forms in the same app since this
The new application builder is missing the Payment option
Hi, I couldn't see this functionality http://www.zoho.com/creator/help/forms/accept-payments-through-forms.html#Creating_a_Payment_Form available when using the new builder. Where is it located please? Cheers,
Next Page