Formating and align numbers in a subform
Is it possible to format and align a number on a form or subform ? Like 1.234.432,2340€ If possible , how it can be formatted according to the country setting s?
Logging order status change
Hello all, I am using creator to manage all my orders, so each record represents a order and I have an "order status" field. Order status: 1. started 2. stage 1 3. stage 2 4. completed I want to log the time every time the status changes as well as the changed-to status. Can some one provide some advises? Ultimately i would like to calculate the time spent in between each phases. thanks!!!!
Help regarding display signature from view to Page.
Hello I need some help. I have to get the signature from view to HTML page. I have published my signature report as well as HTML page. When I access the page then Signature is not display to the HTML page instead a broken link is shown. Please tell me how can I display an signature in HTML page in published page. Path to image is:<img src="https://creator.zohopublic.com.com/adminname/appname/Signature_Report/recordID/Signature/image-download/1438596706381_signature.png" width="300">
"Share" in Application Settings
Hi How is Share used with "Groups"? It appears that there can be Groups established that have no link to Users that have been assigned access to the application? - What is the purpose of Groups - How are they different from User Roles/Profiles? I use Roles to group users? Thanks for any clarification you can offer. Best regards Edith
help regarding search potential from crm to creator
Hello I need some help. I have created a custom link in potentials. On click it redirect me to Zoho creator. I am passing potential id with that. In zoho creator, I am fetching this value and save in to table. This is used for changing the stage value in crm. In Zoho creator, I have a button "Email for signature". On Click of this a email is send to the user with a link. When User open the link, it will show two button "Accept " and "Decline". On click of Accept, it search for the record in crm based
Percentage values in formulas. Literal number instead a %
I have a percentage field (%) on a form Scripting I copy the value of this field in a similar field (%) in a subform The subform formulas percentage field is interpreted as a literal number : for example , 15 instead of 0.15 (15 % ) Am I doing something wrong or you need to convert the numbers in the formulas , for example : 1/15 ?
Update all records (except one) in subform with for each
I have a main form called Quotations with a SubForm called Agents_Prices The Agents_Prices subform have a Decision Box field called Go When a user checks Go in one row of the subform we want to uncheck all the others true values of Go in all the rows in the subform (except the current row) After consulting the help and this forum I try with this code if (row.Go) { for each row in Agents_Prices { Go = false; } } row.Go = true; But don't work
Help How do I change the very top tab
How do I change the very top tab from Pampering 4 Paws Grooming Information and ......???? Please help :)
Like treeview graph
Hi there, I need to show three forms like treeview graph, joined in one report. I have three levels: grandfather -> Father -> Son Which type of report could I use? List report works fine but only for two levels. Anyone could help me? Best regards, Maurizio
How to redirect to another page from payment page after making payment
I have one form where i am making payment.I have a requirement where after making payment page should redirect to another page. How can i achieve this ? Please Reply.
Help regarging download pdf from html view
Hello I need some help. I have to send a pdf download link to customer so that he can open the link and see their quotes. I have found the link which convert HTML view to pdf "http://creatorexport.zoho.com/<app owner name>/<app link name>/pdf/<HTML view link name> ". But how can I download the published page as pdf because in email I have to send public url to customer.
Next button click is inserting new record on click
I have five forms.On each form I am accepting data and on next button click.For all four forms i have only one table.I am passing the DocumentID as query string and on next button click i am inserting that data in table and opening new form. While opening new form i am passing that DocumentID as query string .But when i click next my record in inserting as new record.Its not inserting in exsting row.I want that all data of four forms should insert into only one row. How can i do that?
Report-Pivot Chart and Customer Portal
Hi, I have a Report-Pivot Chart embedded in a Page (Page X). Using Customer Portal, each customer can log in and insert/view his own data. Each Customer should access to Page X and see the Report-Pivot Chart related to his own records. In the Report Settings If I set USE to "All records" I can see the graph but related to all records (all customers together); In the Report Settings If I set USE to "Only logged in user records " the graph goes in error (no records). Any hint? tks, Pippo
when activating my domain, it shows that there are multiple signups from this IP, but I have signed up only once,
Please solve this ASAP.
Development vs. Production Environment
Does Zoho creator support a Development Environment in which modificationscan be made and tested before being released into the production environment? For example, if I am modifying the behavior of a form that is live and deployed to my users and I cause and error or undesired impact with a script change it would be nice to have that not be immediately live. I know this is common with most platforms and wonder if I am just missing it.
Application/Theme Color Customization
I would really like to see the ability to customize the colors used in the application themes again. I'm not sure why this feature was removed, but I'd like to see it added back if possible.
Delug Script doesn´t run on bulk edit
Hi, I have developed a script to run after update a specific field, nevertheless, when I update the field in a bulk edit, the script doesn´t run. I am going to disable the bulk edit option, but I was expecting that the script run also in bulk edit. Kind regards, Mari.
Help Regarding fetching value from url to form which are embed into HTML Page.
Hello Team I need some help. I need to get value from url to Form which is embed in HTML Page. I have a form which is embed into HTML page. Please tell me how can I get value from Url to Form which are embed into HTML Page.
Is there a problem right not with CRM Update Record API from Creator?
Is there a problem right not with CRM API from Creator? This morning all of a sudden we cannot execute zoho.crm.updateRecord function. We are getting the following error: Error in executing Set Variable task. Unable to update template variable crm_quote_url. Error evaluating MAP expression We are getting this in our form Email_Quote. Please let me know if something has stopped working on zoho end or if our application just magically broke on its own. Thanks, Matt
Customer Portal Login
Hi, Is there a way to log in to the customer portal with cosign? I've read through https://www.zoho.com/creator/help/application/customer-portal.html and https://www.zoho.com/support/help/customer-portal.html and it doesn't mention anything about cosign. Is it at all possible to log in with cosign? Thanks!
Creating an approval based application, stuck
I want to create a simple application, which'll do following-: 1. Users will submit their expenses for reimbursement. 2. Manager will approve or reject or request more information 3. If expenses are rejected OR manager needs more information, then comments should be added 4. Submitter will be notified of each status update -- I created a user hidden dropdown field called status which has values of Pending (default), approved and reject. -- I created a comment box field and made it hidden in form
ACCOUNT DELETION
Every single time I try to access my subscription to change plans, I'm directed to my creator dashboard. I'm getting pissed off. How the hell can I downgrade my subscription if I can't even get to the right page.
Not Able to find 'size' function
Am I overlooking something obvious? or is this a bug? 'Total_Questions' is a Numeric Field. I get the same error when I try input.Questions.size() < 1 or input.Total_Questions == input.Questions.size()
Printing Certification Cards
I need to print onto pre-made CPR and First Aid cards. I have developed a roster using Creator, but I cannot figure out how to print only the needed information onto the cards and adjust it so that the Name, Dates and Instructor prints at the proper location. As it shows in the attachment, it will be a sheet of 5 individual cards. Can anyone help? Thanks.
Improper Statement
I have a very simple code on the decision box On User Input as: if(input.Decision_box == true); { openUrl("http://mydomain.com/newsite777","New window"); } I keep getting the improper statement error on line 2 which is the curly open bracket { Please advise
Auto populate a lookup in a subform from a lookup in the parent form
Hello, I have searched through the forums and have found similar threads but not quite the same scenario as mine. I have 3 forms, ACCOUNTS (includes all contact information including "Company_Name") ASSETS (Includes computer hardware information including a lookup from the Accounts form for "Company_Name") FILES (includes a file upload field and a lookup for "Company_Name.") The common field between all three forms is "Company_Name." ASSETS includes a subform field using the FILES form. My Goal:
Cant fetch record from lookup field
Hi, Followed the tutorial for fetching a record. https://www.zoho.com/creator/help/script/fetch-records.html Went with option 3 as this is exactly what I am trying to do. I have 2 forms Form 1 is called "Anst_llda" Form 2 is called "Uppdrag" I have a lookup at Form 2 pointing to Form 1. This lookup is called "Anst_lld" I want the Email field from Form 1 to be copied to a field in Form 2 called "UserID" Here is the code that I added on the lookup field. Even tried adding it to "On Edit" and "On Success"
PDF Engine not working today?
Hi, Suddenly I cannot export anything as pdf or attach anything as pdf from Zoho Creator. It used to work totally fine. Now a browser tab open with https://creatorexport.zoho.com/downloadExportData.do? as usual but hangs and nothing gets downloaded. I first noticed it when sendmail stopped working with pdf attachments today. I removed the attachment and it works fine. I then just tried simple export of reports as pdf and that fails too. Exporting as a spreadsheet works fine. Have tried different
UTF-8 support when sending mail to Zoho creator?
Hi, When sending Germanic characters (such as Ä and Ö) the emails bounce back as it cant recognise those characters... Doesnt Zoho support UTF8? I get an email back with the following. The Following error has occured while adding this record: Failure, Invalid column value "G�teborg" specified TicketNR : 234234234234 Uppdragsstatus : Company : 234234234 Avdelning : G�teborg
Improper Statement
I have a very simple code on the decision box On User Input as: if(input.Decision_box == true); { openUrl("http://mydomain.com/newsite777","New window"); } I keep getting the improper statement error on line 2 which is the curly open bracket { Please advise
Can't modify an application
All of a sudden when I try to modify any of my database applications, I get the immediate error message "500 Something went wrong - contact support" This happens on several, if not all of my databeses and I am unable to make any changes whatsoever. I can still add, remove, etc. data, just cannot change the format. 04/19/2015
Help regarding deleting records from subform
Hello I need some help. I have created a main form named "Shipping" and two sub forms "Shipping and Billing" and "product Info". I have created a relationship between these forms by assigning a ID at the form load in main form and assign the same id to sub form as well. When I add the record in product info sub form it works fine and on delete it is also work fine and on success it show a page with these information correctly. But when I edit the same record and add or delete product from there
Sorting lookup fields
I would like to present the options in a Lookup field in a particular order. I know I can set the field to be sorted alphabetically but none of the fields in the table relate to the sorting order. Ideally, I would like to add a field to the table in which I can set the sort order for lookup fields to that table. But I don't want to display this 'sorting' field. Anyone: Do you know how to achieve this with what we have now? ZC Support: If not possible now then please add this feature.
configure a Single Line Text
Hello I have to write text in Italic in Single Line textbox. Is it possible in zoho creator to write text in Italic?
How can i give permission to edit and delete to that user of customer portal
In zoho customer portal ,why user of that portal is not able to edit and delete anything ? I have customer portal and in that customer portal i have created users.and i am giving permissions to that user.I am giving permission of edit and delete to that user but still that user is not able to edit and delete anything in application. How can i give permission to edit and delete to that user?
How many columns i can add in database view ?
In zoho how many columns i can add in database view? I have 60 to 100 columns so is that possible to add this much columns in only one database view?
Users field update
Hi I have one form that has a filed Users.I have created one custom action that has a add record task for adding these Users field.When I ran these custom action it added only login user name.But i have other names that have also permission.But it add only login user name.Is their any solution for it to add different users?. Thanks. Siva
Create a report from data derived from another report.
Can a report be created using fields derived from another created report (ie not a form report, but a seperately created report? If so, what are the steps?
Zoho Creator Mobile Breaks images if more than one on Form
I was excited to see the Zoho Creator Mobile app get updated today. I was hoping this bug would get fixed but I quickly learned it did not. Process to replicate: 1) Create a form with two images on it. Call them image1, image2. 2) Fire up the mobile app. Take a picture and upload it in the app as image1. 3) Go to desktop and mobile app and image looks great. 4) No go to mobile app and take a picture as image2. On the mobile app it looks great. 5( Fire up desktop app and now image1 is corrupted.
Error occured while executing on load script
Multiple apps in my account are experiencing an issue. Some (not all) records give this error when editing a record There are no other issues in the logs and the code works for most other records. It's like the record got corrupt on zoho's side. Support chat verified the error yesterday. I have also submitted a support email. I'm documenting this in the forum for other's benefit. Cheers, John Whitney
Next Page