Dynamic Drop down list based on import from Zoho Reports
Hi all, Any help would be appreciated! I have this app connected to my database in Zoho Reports. I want to create a dynamic drop down list in my stateless form which fetches all the value from one column in a Zoho Reports table. I found the 5 years old post with similar topic. https://help.zoho.com/portal/en/community/topic/desparate-help-please-reporter-and-creator I tried to use Zoho Reports Export API with the following codes ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=<email>&PASSWORD=<password>"));
Pages Script Editor - formatting feature request
Hi, Would be possible to prevent the script editors from automatically reformatting my code please - particularly the pages editor! I'm sure there may be valid technical reasons for this auto-formatting, but free form on the Pages script editor is only free form until you save and then re edit. With complex interactions between deluge and HTML, the code quickly becomes a visual mess and makes it impossible to do anything other than the simplest of tasks. The syntax is already visually quite messy
Update formula in a subform with a value in the form
Hi, I am looking to update some values in a subform with changes in the forms... I created the formula that multiplies a value in the form with one in the subform. But if I change the value in the form, the calculation is not redone. I am looking something to write in the Action update , but I can't seam to write it correctly Can somebody help me Thanks
ZCRM TO ZCREATOR
hi, i create a record in zcreator from zoho crm trought webhook. Now i need update this record trought webhook, but i cant make this. Help please. Thanks you.
New App Builder: Serious Oversight
Setting Report Criteria in the New App Builder I cant believe we're back to this!!!! I posted this months ago and a fix was implemented. Now creating graphs is even more confusing than it was before. Clicking on creating a chart and it takes you to the interface for creating a pivot table. The worst part is that I desperately need to restrict user access to charts using the criteria established in the view which used to drive chart and pivot creation. Using the filter on the chart doesn't do
Can do some other task when cancel button was clicked.
Hi, I've two forms form1 & form2. When cancel button in form2 was clicked, record inserted by form1 should also be deleted. I tried with stateless form. But both forms should contain 'file upload' field which was not provided for stateless form. Please suggest me how can I do this? Regards, Appadmin
Use URL to filter a view (report) with criteria for form field not in the view
I would like to call a view via URL with criteria for field "Customer." Works great, except I don't need the "Customer" column to show in the view. Unfortunately, if it's not in the view, the URL criteria does not work. Am I missing something? Work around? Way to hide the column when displaying the report? https://creator.zoho.com/egutshall/task-manager/#View:Client_Report?Customer=16085000007371003
Auto populate Text field with a lookup field
I've been looking all over for a solution and can't figure out why this is happening... I want to populate a text field with the value of a lookup field on the same form. I've been using the same fetch script that I've seen everywhere but no luck. I've placed it on the lookup field 'Company' - 'On User Input' within the Real_Estate_Brokerage form in hopes of populating the 'Company_Name' text field. data = Real_Estate_Brokerage [ID == input.Company]; input.Company_Name = data.Company_Name;
Locale in Decimal Separator ?
Hi, notice that the currency can be changed, however the decimal separator remains the same. In the EUR Zone the Numbers have comma as decimal separator 100,00 EUR instaed of 100.00 USD. Displaying is not a big deal, but when exporting data for import to other application it produces considerable trouble. Any plans to fix that ? Google Docs and Excel do an excellent job here. Thanks Alex
Insert record to a specific location
Hi, I want to know if it's possible to insert a record to a specific location. For example, I have 4 records with order like this 1 Book 2 Movie 3 Car 4 Laptop Now, I want to insert a record called Mobile between Movie and Car and it will have order number 3. And the Car and Laptop records will be pushed down and the number will be updated automatically to 4 and 5. It will be 1 Book 2 Movie 3 Mobile 4 Car 5 Laptop I want to know if it's possible to accomplish this. Thanks
relate lookup field with total amount in report.
Hi, I have report where all the requested items are. This report is grouped by Description and I set it to show the total quantity of each Item in the report. I have a Purchase Order form. In this form there is a subform where users add the items to be purchased. The users select the items from a lookup field in the subform. I would like the lookup field in the Purchase Order subform to show only the items that are in the requested items report and to link the total quantity. is this possible?
How to automatically set value for one filed based on value of other filed when data was imported from Excel file
Hi everyone, I need your help on this. I imported data from excel file. One of the filed is Analyst Name, I want to add "Department" based on the name found in "Analyst Name". For example: If the analyst name is Mark or Peter or Marie, The Department filed would be "Research", if name is Jubin, Relji,... the Department field would be "IT support". Thank you
You have reached maximum number of rows. You can not add further.
Good morning, One of my employees has been receiving this message and I cannot work out why. We are on the enterprise edition of Zoho Creator, so I believe we have no restrictions. Please see the attachment. I am aware that I have not given a lot of information, I don't really know what would be helpful so if there's anything I can find out or provide, please let me know. Kind Regards, Mike
Clearing "Signature Field" when duplicating a record
Hi, When duplicating a record with a signature field how can I clear the field? Thanks, Damien Cregan Hire an Expert
Dear Sir
how my new Domain name dufmeducationaltrust.in not be Publish why????
ExecuteXPath - Cannot fill out Specify xml/string variable
To fill out "Specify xml/string variable" is required, but not possible to write or choose anything from dropdown ? I can just fine select from the xpath builder and generate the code and execute and apply, thats fine, but still no way to specify this ?
Displaying the form title in the default record template
How would you display the form title in the default template for printing records?
HELP
HELP Hello I need some help to edit one of my flight plan app's , for some reason I can't get into it to change some of the fields? I could really use some help this is a safety sensitive app and any help would be much appreciated. https://creator.zoho.com/coldstreamhelicopters/electronic-flight-plan/#Form:Operational_Flight_Plan_Itinerary
Formula Fields - How to get the Text from a Lookup Field to be saved
I am trying to use a formula field to put together the values of some of the fields on my form: Example: Accounts + "-" + "Project" + "Products" On my form the Accounts and Products fields are Lookup Fields - Links to other forms that display the Account Name and Product PN. When this field executes I am left with the Record ID for Accounts and Products captured in this field. What I want is the Name of the Account and the PN of the Product. How do I get the text values of these fields to be saved
Added User field
All of a sudden the field AddedUser is being populated by "Public" for all records added to my ap by all users. My ap is not published but is for internal use only. I rely on the added user field to create reports and track which of my employees are entering their time cards. How has this happened (has been working fine for 8 months) and how do i fix it?
Cancel button in Subform - Creator App
Hello, We have a mainform and within that a subform. We don't see a "Cancel" button on top-left corner of the screen within the subform. Kindly refer to the attached screen. Do we have to write a special script to get it or is it a bug in the app? Thanks!
How to automate tickets in ServiceDesk via ZC?
The ManageEngine Service Desk Plus promotion states this: "Automate creation, updating, and closure of tickets in ServiceDesk Plus On-Demand every time a record is submitted or updated in your custom app." So how is this done? I've looked all through the ZC documentation and can't find any way to get ZC app form data to post to a new ticket in ServiceDesk. Any help is appreciated. Steve
How to OPEN rather than DOWNLOAD (??)
Hello from faraway New Zealand I am trying to add a link to a PDF document from a Notes field on a form. It is a print version of the form in PDF format. This is something the client has asked for. Unfortunately, the file downloads rather than opening. This is the URL format I am using for the link: https://creatorexport.zoho.com/workingwise/pacrad/KeyDocEdit/654604000011936102/File_upload/download/1473212208812_PRG_Induction.pdf Can somebody please tell me how I can amend this URL so that the document
Odd responses shown in text field
Hi I have an application with an external facing stateless form which updates fields in a normal form. In one record of the normal form, the text entered in the stateless form has not been transferred to the normal form successfully. Instead the text is being displayed as two buttons side by side with "Alt + M" and "Alt + N" on the buttons. In fact all the longer text fields in this record have been changed to show these buttons. Does anyone know why this has happened? Thanks Craig
Logo/Image insert in the form
Can some body tell me how to insert or add image / logo inside a form thru Add Note. if somebody can tell me in detail, it would be greateful.
Is there any options for the 'file upload' field to upload more than one file?
Hi, I have 'file_upload' field in myform. I want to select & upload more than one file at a time. Don't want to use more than one file_upload field. Is there any option to set in file_upload field. Thanks for your help, Appadmin
Sending Emails with Attachments
Has anyone written a general purpose send email function that can send emails with attachments using the ability of schedules to send emails with attachments?
How is the search button working when we have a blank subform in a main form?
I have a main form which has a Subform (blank form) like the following image (Hotels is a multiselect field) In the report I would like to show the Hotels and Category (from the Subform) so I did the following (using a comma separator): So my final report is like: Well my problem is with the search in Remarks.. When I write 'Remarks Contains Promotions' then it returns me only the first record which is correct When I write 'Remarks Contains Issues' then it returns me only the second record which
Executing...
When I try to execute my code on the learn deluge website, the button just remains in the "executing..." position, without any output. I've tried restarting my browser, but this hasn't helped. What should I do?
Open form to edit a specific record with page header
I'm trying to open a specific record to edit, following this guide: https://www.zoho.com/creator/help/views/editing-records-via-record-id.html Link example: #Form:Parent?recLinkID=3032879000000050091&viewLinkName=Parent_Report But I can't make it open with the header on the edit page. This is the header I'm talking about (appears when using the add record form): When I open from the link there's no header: Is there a specific parameter to make the edit page display the header?
postURL and getURL not working for Delete -> On Validate
Hello The deluge code for Delete -> On Validate on the form actions in the form builder is headers = map(); result = getUrl("https://www.zoho.com/creator/", headers,false); info result; cancel delete; And "result" variable is always {}. Should it at least have "responseCode" and "responseText" ? The "cancel delete;" is present on the script to prevent delete during the test phase, since I need to delete (or not delete) depending on the response from a 3rd party service, and the responses are not
Making the Customer Portal Look Great in Zoho Creator
Hi All I am new to Zoho and I want to see if Zoho can be customised for portal user. The portal will need to follow the design of an existing website. How would you do this? and are there any examples I can look at on the Web Thanks for any help. Tony
Summing up total price in the Order management tutorial
Good day. I am new to Zoho creator and I have been following the Order management Tutorial. I got stuck at the Advanced scripting Tutorial 3 I have copied the code as it is, following the tutorial step by step but the code is not working at calculating the total price of the items. The "Total" field is disabled so user can't edit but the default value "0.0" is not showing and the total products price is not showing. I tried walking-through but I think it might relate to the variable "itemID" used
Fetch Lead Owner Email and pass into Lead Record
I'm trying to fetch a lead owner's email address and pass it into a custom field that I created whenever a Lead Owner is created/updated. So far, here's what I've come up with: I've been able to grab the lead owners name and lead Owners ID but I'm still not sure how to associate the ID/Name with the Users Email address and then pass it into the lead map. Please help! lead = zoho.crm.getRecordById("Leads",input.leadID); leadMap=map(lead); leadOwnerName=leadMap.get("Lead Owner"); info leadOwnerName;
Limiting Class Size/Available Seats For Scheduling Sign-Up App
Doing some planning for a simple application and wanted to make sure I'm going about this the easiest way possible. Purpose of the Application: Allowing people to sign up for seats in our workshops (classes) Information Displayed for Workshops: Date, Time, Location, Name/Topic of Workshop Average Number of Workshops Listed Per Month: 10-15 workshops Number of Seats Per Workshop: 12 Ideally, the display I have set up would allow clients to filter their search results by location (two different locations)
why was "null = zoho.loginuser" statement inserted?
Hi, Below is my insert statement. But the line "null = zoho.loginuser" was inserted when I access the application. Moreover I'm getting error when this statement was executed. Please help me to resolve this issue insert into SelfAssessment_Report_Form [ assessmentNo_SelfAssessmentReport = input.assessment_SelfAssessment_State category_SelfAssessmentReport = "Category1" noofYes_SelfAssessmentReport = 0 noofNo_SelfAssessmentReport = 0 noofNA_SelfAssessmentReport = 0 noofUnanswered_SelfAssessmentReport
Question about the file uploader
Right now I have a form that acts as a file uploader.. The result of uploading a file is stored in a report. Is there any way to view that report so that I don't have to download the file? The file uploader is mostly used to host images.
Why are some forms limited in the types of fields I can implement into them?
For instance.. Between two similar forms on my app on the left side there are almost twice as many field types I can choose from.. I am editing a form and want to implement a 'file upload' field into it but there isn't even an option of the left-hand side to drag a file uploader onto the form. How do I get around this?
Issue when trying to create app
Hi, After enabling Zoho creator in Zoho CRM Plus, I am unable to go on the the app creation process due to what I believe is a technical issue. I keep getting this message when trying to proceed when I clearly am not using any of the characters they mention (please see below screenshot). Would anyone be able to identify the problem and help me out? Thanks!
Date Validation
I added a validation for a date field to check whether user is selecting a past date. I used below script in On_user_input field action: if (input.Date_field < zoho.currentdate) { alert("Not Allowed!"); input.Date_field = zoho.currentdate; } It works the first time I select a past date but after closing the alert box, I am able to select a past date. I tried this several times and found it to be an intermittent problem.
Next Page