How to use auto generated ID in Main Form to subform.
Hi I have created two forms Shipping and Product Info. Product info is the sub form in Shipping Form. when I submit the form then two reports are generated which contains the Forms details and a auto ID is generated. I want to know can I used that auto generated ID into sub form to create the relation between main form and sub form ?
Auto Populate Forms Error
I have built several forms which successfully auto populate the fields based on information in other forms. I have used the instructions from Zoho. However, I am finding that often, probably every other time I try to use this script, I am given the error: Error modifying the page null. My past fixes have been to redevelop the form, but I am getting tired of duplicating my efforts and wasting my time. When I build a new form, I paste the exact same script and it works. Any ideas on how to avoid
How to Copy a Form?
Greetings Zoholites, I have to create 39 individual forms for a survey. Is there a way to create a base form and copy it and then edit for each individual? Grateful for your assistance, Lisa
postUrl broken since last hour
Hi There, All of my functions that use the postUrl function are returning errors at the moment. This has been happening for the last hour. Regards, Ben
How to display a jpeg image stored in a file upload field in record summary print template
I am trying to customize a record summary template for printing a database record. One of the fields is a file upload field that always contains a jpeg image. I am using the file upload field because it can handle images greater than 5MB. I need a way to display the contents of the file upload field on my printed report, but have been unable to figure out how. I have been trying to use HTML in conjunction with deluge scripting, but have been unsuccessful.
Importing from Excel - field matching
Hi I have a Zoho form. I have records that have been typed in Excel which I wish to import into the form. I need this at automated as can be. The form has 30+fields. When I try an import from Excel the field headers have been typed exactly however Zoho doesn't recognise the field matching headers and I have to match the Excel fields to the Zoho fields manually every time. I tried exporting the form from Zoho to Excel then copying my data into the Excel spreadsheet then importing back into Zoho
Multilangual App
How can I build a multilangual application with Zoho?. Means not Zoho to be multilangual, my application to support different languages. The LABELS of the menus and messages to be linked to my database with different languages.
Zoho Creator App - Not working for users
Hi All, The iPhone app for Creator seems to work for myself (admin) but not for any of my shared users. They are able to access through a desktop just fine but the smartphone app just says "no shared apps" when they login. Does anyone have any insight?
How to create a formula that decreases the Due Date - zoho.currentdate by 1
Dear All, I would like to create a form with a date field (name Due_Date) and a formula. My scenario: When I give a date to the date field (for example 22/7/2015) then I would like in the formula field to calculate the date (22/7) - zoho.currentdate and to return me the number of days. In the report, each day the zoho.currentdate will decrease the number of days by 1. In that case I wrote the following inside the formula: days360(Due_Date,zoho.currentdate) The problem is that in the report it does
Dynamic filter
Hello. I have 3 forms: Company Data>>Property Data>>Roof Section Data Property Data is related to Company Data via company name lookup the Roof Section Data is related to Property Data via property name lookup. I created a view based on Roof Section Data and have it filtered by company via the "Criteria" function. I'd like to create a drop down similar to the auto-filter in the below view and restrict the list to the properties belonging to the company name. Is it possible to do something like this?
Issue creating app
Screen displays are all over the place when accessing app to edit and such. Screens are all jumbled up. Cannot access field values to change, screen stays on Form tab. Refreshing screen just jumbles everything on my screen worse. Emailed app comes in as SPAM and shows this on email. Firefox 39.0
What is the best practice for editing fields of a form from a list on an html page?
I have an html page. In this html page I have a table with iterated records from a form. I need the ability to click a button on one of the rows, which will then allow the user to edit only a few of the fields from the form. The primary field that will be edited is a dropdown. What is the best way to do this? It seems there are multiple routes to go: From the page, create a stateless form that pops-up or iframe with the fields to edit. Have buttons that use url variables that correspond with the
Alert Box on HTML Page (Creator Page)
I would love the ability to quickly debug my code in a html page by using the alert(); function. But it can only be used on a form in the onload section. The only workaround is to email to myself. BUT, its more than the debug function though. I would like the ability to alert my users as to change they made. Like, you just updated your subscription preferences. How have others been able to do this adequately? Is there a workaround?
User Field with zoho.loginuser
I have a main form with User field that is populated with zoho.loginuser upon add. As an admin, when I change the user field to another user, I want my subform to reflect the same loginuser. The subform has a field called User_name and it is a string field (not a user field). In the On Update of the User field in the Main Form, I wrote a deluge script to populate the User_Name field (string) of the subform so they are in synch. It does not appear that the functionality is present for User fields?
Custom Action Sendmail and set field value
I have my sendmail function setup and working so that when the user selects multiple records they are emailed. However, i would also like these selected records to be marked as "emailed" so that another user does not come along and email them again. How do I accomplish this? Here is my sendmail function if it's relevent: void sendemail2(Add_a_Container records) { msg_content = "<table border=\"0\" style=\"\" width=\"90%\" cellpadding=\"5\">\n <tbody>\n <tr>\n <th align=\"left\"
Form created to filter records in report
Hi, I have created a search form which is supposed to filter the records in an existing report. On this search form, I have the option to search by three different criteria (you can only search by one given criteria). For example you can choose to search by Name. I am not sure what I am doing wrong here; I would like to use the public link of my published report. This is what I have: if ((input.Search_by == "Name") && ((input.Name != "") && (input.Name != null))) { openUrl("https://creator.zohopublic.com/zoho_jchan5/copy-of-requests-for-purchasing/view-perma/New_Request_Report/Xy2yfT1JP48sAa9ZbTmP6Yh8qtPAXvYBVvOgrxnkABdnrjU2f3Tat66zKN8V7XUz3xUTugdx2OnMMsBMP2k0fr4GxBSQqN9nJ5fv?Requested_By="
If... does not contain in sendmail
Hi, This is probably going to be the most simple thing, but I just can't seem to figure it out. I have a sendmail function, in which I want it to be triggered if a certain field DOES NOT CONTAIN a certain name. I am not quite sure how to go about putting this down in code. So right now, I have: ((input.Location == "Toronto") && (input.Department_text == "Head Office")) and I'd like to add the criteria that input.Employee does not contain "Celeste" Thanks in advance! Joy
Open url in iframe
This should be pretty simple. I have an html page where I'm trying to use openUrl to open another HTML page from another app and so far it doesn't open in Iframe. Any help would be appreciated. openUrl("https://creator.zoho.com/pcrs2013/pcrs-studies/#View:Variable_Collector", "iframe", "thisFrame");%> <iframe name='thisFrame' height='700' width='700'>Loading View...</div><%}%>
Top to Bottom Deluge Help, Real Newbie Creating First App
Hello, So I'm designing an app for my business coaching company and planning on buying the paid version for all of my coaches. My plan is to offer an "Accomplishment Report" to my clients that populates the "Coach Report" for my coaches. So far I've gotten a handle on creating the fields for both forms, creating simple lookup fields, creating/implementing rules and tasks (i.e. populating certain fields when a drop down choice is made), and managing the "Report" that every click of the "Submit"
fonts
Where/how do I change the fonts on my reports in Creator ? They are too large in the reports
Outputting images in Creator
Hi, I am having a problem with how images are being outputted in Creator and also when the app is linked to my Zoho CRM. It is a product database and the products are linked to the client account in CRM. When the image is outputted in the report in creator it is huge (dimensionally) so the report is impossible to use efficiently. What I was hoping is that a thumbnail would be outputted and when clicked would be bigger. I tried changing the dimensions on this screen https://www.dropbox.com/s/9fon0mh6thl15k1/Screenshot%202015-07-09%2013.51.43.png?dl=0
Limitation for updating records
Hi I have 19000 records.I want to bulk update these 19000 records through custom actions.Is their any limit for updating these bulk records. Thanks.
Link in email notification to edit one record
Hi, I am unable to figure this one out. When a user fills in a form and submits it, i would like a link to be available in the email for them to edit that record that they just submitted. I have used this as the link, but it does not work! Please help! I have published the form and used the public URL that is provided in Zoho. https://creator.zohopublic.com/<public URL>/record-edit/<ViewName>/Request_Number=input.Request_Number Thanks in advance!!! Joy
Adding data via email
I have a main form called New Request and a stateless form called Update Request Status. Employees will enter requests via the form on our website. The details are then emailed to the employee for confirmation. Is it possible to have the employee add data to their existing request (i.e. record) via email? Or is it only used for adding NEW records? Thank you in advance!
quickbooks create error evaluating MAP Expression Probem
I have tried to follow the instructions for setting up zoho creator api with quick books. Instructions are found here: https://www.zoho.com/creator/help/script/quickbooks-add-record.html It seems even when i copy the example i am getting the following error message. Seems that there is something wrong with my map variable but i cant see what. If i put the map variable in an alert box it seems to look fine to me. This is located in my Purchase_Request_Form on the Order_Number on User input field.
Filter by conditional formatting
Hi With conditional formatting we have the ability to format table cells in particular ways. It would be good to be able to filter records by the way they are formatted. For example if I have two rules which both color a particular column in a record red, an option to filter that column to show records which are red or not red would be good. Thanks Craig
Record Summary Print Error
I have a Record Summary that prints out as an A4 label that is used in a warehouse to identify stock. Each time the stock Qty is changed, a new label is generated. This has worked perfectly for 18 months but today the view looks perfect but when I try to print the text is compressed and overlapping. It is happening on different record configurations. I haven't changed anything at all and the problem replicates on other PCs and printers. I use Google Chrome. Can anyone help? Update: I've temporarily
Zoho Creator Marketplace not responding?
I am not able to choose a category, or Popular or Most Recent options in the Zoho Creator Marketplace - nothing happens - it simply stays on the Main Page (Featured Applications), and Search doesn't appear to work either. I've tried IE, Chrome and Firefox.
Market Place not responding
https://creator.zoho.com/marketplace All the options to navigate within the Marketplace are not working. I have seen other people commenting on the forum about the same issue. Francisco Riojas Creator Scripts Smart Software For Maverick Entrepreneurs www.creatorscripts.com
USERS CANNOT ATTACH FILES - AGAIN AND AGAIN AND AGAIN AND AGAIN AND AGAIN AND AGAIN
USERS CANNOT ATTACH FILES - AGAIN AND AGAIN AND AGAIN AND AGAIN AND AGAIN AND AGAIN AGAIN - MY USERS ARE HAVING DIFFICULTY TO ATTACH FILES IT IS THE THIRD TIME THIS HAPPENS - I M REALLY GETTING SICK OF THESE PROBLEMS ZOHO IS SUPPOSED TO OFFER ME A PLATFORM FREE OF THESE PROBLEMS
Calendar sync with Google
I was wondering if there was a way to sync my Zoho Creator calendar with my google calendar?
searchRecordsByPDC and datatype mismatch
The following code gives me the following error Mismatch data type for function get at argument index 1 expected data type BIGINT found dataType STRING The error occurs when setting value of cfirst and clast. I don't see what this should be happening. These variables have not been set before and they should be string values. Why is zoho saying they should be BIGINT? CRMContactSearch = zoho.crm.searchRecordsByPDC("Contacts", "email", Client_Info.Email); cfirst = CRMContactSearch.get("First Name");
USERS CANNOT ATTACH FILES - AGAIN AND AGAIN
AGAIN - MY USERS ARE HAVING DIFFICULTY TO ATTACH FILES IT IS THE SECOND TIME THIS HAPPENS - I M REALLY GETTING SICK OF THESE PROBLEMS ZOHO IS SUPPOSED TO OFFER ME A PLATFORM FREE OF THESE PROBLEMS
Cannot attach files
This morning we started experiencing a problem when attaching files to our forms. The form has 2 spots for attachments. 1 is a basic upload field, the other is in a subform within the main form. Neither work. When pressing submit, we just get the "Please Wait" icon. Please advise on when this will be resolved. Thank You
ZOHO CREATOR ADD RECORD JUST SPINNING...15 MINUTES AND COUNTING
TRYING TO ADD A RECORD...WHEN I TRY TO SUBMIT, "PLEASE WAIT" IS ALL I GET....HELP!!!!!!!
Start Page or Default Page for Customer Portal
Where would I set-up a default page or the start page for after the user logs-in from the the customer portal. Once I figure that out I can create a generic page that depending on the permissions can forward them onto the correct page, but I have not idea what page/report/form it will show by default. Any help is greatly appreciated.
Returned input not inserting into a field
Hello, This morning I wrote a small script to look up the ID of the users selection and put the result into another field on an on click [create] button. My returned information will display in the alert box i added to check, but the returned value in not being placed into the field... at least not that a user can see. Any thoughts would be greatly appreciated. Here is the code. // Match the Customer Information with the users selection. // ThisSite = Customer_Info [ID = input.Select_Site]; //
Download attachement with WEBCLIENT()
Greetings Im trying to download an attachement from a survey made it on zoho Creator, im using webClient to download the file but it only download 42kb from the file, is there any restriction about it?
Do not send Report if empty
Hi, I would like to create a schedule to send a daily report as an attachment via e-mail but I would like to avoid sending a report/View a blank report with no data. any help will be greatly appreciated Thank you. .
How to downlad attachment From xml API
I have the link for the attachment for example this: https://creatorexport.zoho.com/NULL/claim- form/Aeroshop_Refund_Form_Report/2729692000000788007/Attachments.File_upload/download/1433869617150_Aut_credito_cuenta.pdf I know that in the url the word null needs to be replaced by the userName but when i want to download this file this path ask me for a user and password .. The question is any chance to send the userName and password into the URL by parameter and download the file? I will like to know
Next Page