Deluge map question
I'm creating a custom function that will create a record in zoho creator using payment record information from zoho books. I've been able to successfully create a record in ZC but I'm unable to get the invoice_id from the customer_payment map. Below is the code: paymentMap = Map(); //set order to payment invoice id - this is not working paymentMap.put("Order",customer_payment.get("invoices[0].invoice_id")); paymentMap.put("Description",customer_payment.get("card_type")); paymentMap.put("Payment_ZB_ID",customer_payment.get("payment_id"));
Adding a visible .PDF to a form
Good evening. I've created a form for my users to complete. Is there any way i can attache a .pdf to this form so that before users submit the from they are able to view/download this pdf and then agree that they've read the pdf. Thanks, Matt
New Form not in list on Looup field creation
Hi All, I am doing some mods to an app called Call Logs and I have created two new forms for data entry. I am trying to do a lookup from one to the other but when I drag the Lookup field onto the form and it pops up the available form options, my new form is not there. Searched all the settings but can't find anything like make visible or similar Can anyone help? Cheers, Greg.
subform popup
In my app I have a form that contains a subform. The subform contains a lookup field that selects inventory items that are stored in a separate form. Everything is working correctly so far, but what I'm wanting to do is thus: If the subform has a line item entered and I edit a field (could be a decision box), I need a popup window that opens the record of the inventory item which then can be edited and updated. I've gotten everything to work except for having the specific record open. Instead it
Doubt about iteration limit
Hi, I'm building a couple Apps and as of now I'm not having any iteration limits problems, however the lines are piling up steadily and fast... Hence the concern My question would be if a "for each" script counts iterations from the raw amount of lines of the table or if it counts the iterations per result in which it has to act. Ex: I have a form with 6000 lines and it contains a field "Color" and 100 lines have "Green" color, if i do a "for each (Green)" script, it will count a hundred iterations
HTML Pages Background - No Control
Am I able to create HTML pages with full screen HTML? The way that Creator has the panels, it always looks like an iFrame and unprofessional. As of now, I can only create a floating panel look. This may be Okay for some internal needs but if I am going to consider building apps to go to market with, I need to be able to have the app look like any other basic app. Anyone have any ideas regarding this? Creating a custom site and then connecting to Zoho Creator seems a little overboard and lots of
Display Latitude and Longitude in Address Field
In Zoho Creator 5, how do I change the address information? I've seen in the script that these fields exist, but I wasn't able to display them. I don't want to see the street or city, just latitude and longitude.
JSON list/array not able to parse
I am not able to parse json list in Zoho Creator. JSON starts with square bracket [ ] . I am not able to convert it to list for looping through it. [{"device_id":"297e79be208d1db191a7e2c0cdc3eb4413c939d9","device_type":"computer","device_url":"https://dashboard.panorama9.com/portal#assets/hardware/computers/297e79be208d1db191a7e2c0cdc3eb4413c939d9","manually_added":false,"name":"JOEPC","alias":"","manufacturer":"Lenovo","model":"20DH002TUS","serial_number":"PF0BEC36","cpu":{"manufacturer":"AMD","model":"AMD
Is there a way to circumference no CC in Creator email?
Hi peeps, Anyone have any luck with circumnavigating the problem with no CC in send email? My company have different departments and sending the email to one department and sending the email to the head of OTHER involved departments means I need to send two separate email instead of one. Which means communication is broken. This also would be a problem when the customer wants to be CCd when a report is done and they want a group of people be CCd. It actually grinds my gears because CC
Pivot Table malfunction
Two days ago our pivot tables crashed and not working correctly. It doesn't regenerate. We need urgent help. It might due to upgrade on backend in Zoho Creator and adding new features.
vendor_record.Application_Status = ”Scheduled for Meeting”;
Hello, I have a question. I just learning Zoho creator and reading "Build a Vendor Selection app in 60 minuets". But when I read to Page for workflow. I got a error it indicated that "Field "Vendor" does not exist in form '{1}" I have typed precisely as the book written. Could you give me some advise for this trouble?
API
First i am stone with this dev tool. Still i have some request Is there a way to access the database over an API XML RPC or SOAP ? from the outside world ? Im using PHP and JAVA. Best Regards Jacques aberstt
Adding records to subform problem
I am new to Zoho. Attempting to add records to a subform (Lab_Result_Details) after editng a field in the subform. Not getting ID from parent form (Lab_Results) to show up in child form. Here is my code: //Capture form ID number to insert into new subform record as linking field var_ID = input.ID; //Get ID of test name to enter in new record var_TestID = frmTests[Test_Name = "ANA"].ID; //Add record to Details subform and insert ID of parent form into child linking field and test code into test
Export Choices in Multiple Select Field
Hi, I've just moved a from from Zoho forms to Zoho Creator. I've just seen that I can't export the choices from a checkbox field in creator whereas you can in forms. Is this going to be updated at all? Matt
Months Between Dates
I am trying to create a function to calculate the number of months between two dates. I was using the getmonth function to calculate this based upon the month of the year; however this logic breaks down when the months cross years. For example: Start Date:November 2, 2009 End Date: January, 10, 2010 Number of months:3 Thanks!
Record template and page break
Hy, I need to develop a record template with ~ 10 to 20 pages. Anybody knows how to include break page ? Many thanks for your help. Bertrand
Interacting with small portions of a large form
Looking for ideas to approach this business need: I have a form that holds customer project details, and I want different departments to edit/update different portions of the form. Sales updates customer requirements, Production updates parts purchases, Install updates employee assignments, etc. Right now I have Sales seeing everything and just scrolling thru and ignoring what they don't need. I have Production set up on a separate small form with lots of workflow to update changes made in the
Calling a workflow from a custom function?
Is it possible to run a workflow using a custom function? if not is it possible to run a workflow with an action button? Any help would be great
Need Kanban board to manage tasks in a particular record of Zoho creator
Consider an engineering company who designs a car, pre-engineer (Checklist involved), Assemble the car parts and ship the product to Vendor. Between this, there are 70-80 tasks (may be more) involved for several teams. Currently, we do not have kanban view of tasks to manage the operations smoothly and in a quick way. This is much needed feature medium sized organizations.
Confirmation email from Zoho form goes to junk mail
Hello there, We subscribed to Zoho forms so we can manage the event registrations from there and to map it with our Zoho CRM. However, confirmation emails to the registrants go to their junk mail. Are you able to help please. Melinda
Text cutoff
The app I'm working with has a text input for client email history, but the text box can only hold so much data (about 50,000 characters) before the text gets cut off; some email histories are a lot longer than that, so data ends up being lost. We've implemented a system to create a Googledoc to hold text that doesn't fit, but the system is annoying to manage and we're thinking of phasing it out. We need some way to store large amounts of text (preferably in rich text format) without it getting cut
Report do not regenerate
am unable to regenerate data in my report. When I select regenerate it is desable and I see the message "Regeneration has been initiated for this report... but never end. Beside, the number showed are wrong I have allowed edit access. Our URL is https://app.zohocreator.com/lepanem/point-of-sale-2-0#Report:VENTAS_DEL_DIA
Record Template Summary as attached PDF in notifications / schedule
Hi, We'd like to set a notification everytime a new record is created or edited. Is it possible, is there a way to send the record summary as an attached file (PDF) instead of embeded html format? May be throught schedule options since there seems not possible through the form notification section? Thanks in advance and best regards. P.S. You can read on your documentation about the new application builder: You can even use this record summary in email notifications (send it as inline or as a PDF
How do we get the Report generated of the Forms which are submitted for the Apporval
How do we get the Report generated of the Forms which are submitted for the Apporval. I have created approval Process. i wanted to create a Report stating these approved and these are pending ...kindly let me know
How to specify the display of a number field to include the "1000 seperator"
I have a form with a currency field. I want to display this field in a html view in the correct currency format e.g. $1,000,000 for a million dollars, rather than the default $1000000 Is this possible? How? Ideas appreciated, :)
Filter setting is not getting saved in zoho creator
HI Team, I'm trying to configure conditional lookup using Zoho creator. Example: Form 1: Add Sponsor Form 2: Add Products (text field) by selecting the sponsor (lookup field from Form 1) Form 3: Add Details Select Sponsor (lookup field from Form 1) Select Product (lookup field from Form 2) Here when i select Sponsor A, all products related sponsor A should be listed in Product Drop down and similarly when i select Sponsor B, all products related to sponsor B. As
Login User Permision
I have question about Login_User permission I know, if I add the workflow for a module as a condition > work if added user is Login_user, it will work But, I have to do write a workflow for all of modules he can access and there are lots of modules. Is there ant easy way to put as workflow as: If Login_user access the application, he can access only his added values on each modules. Thanks a lot
Custom Action Button
Wondering if we can add a Custom Action Button to for each line to perform a calculation. For example, we have a number field in our form where we enter the quantity of 20. When we go to the report, we want to change the quantity to 25. Instead of editing the record and changing the value, is it possible to have a Custom Action Button on each line item that would execute a function to say +1. So in my example, I could click the +1 button five times and now the report will show the quantity as
how to get result String from Lookup?
i have problem get String value from data lookup is result bigInt, how to make result from lookup is String?
Custom Domain Name
Has custom domain mapping been added yet to Zoho Creator so that people can access an app by using www.customdomain.com instead of the zoho url? If not, has anyone messed with using domain forwarding options using an iframe/embedded forward such as many registrars offer? Dominic
Support for SQL Queries in Zoho Creator
When do you plan to support SQL queries in Zoho Creator?
Multiselect/Checkbox
I have three questions (A = checkbox, B = Text Box, C = Text Box), Question A have 5 options. The query I wanted to write is that, if user check option 5 along with any other options Question C should U Unhide(Show) else it should in Hide position AND if user check option 2 along with any option Question B should Unhide(Show) else it should in Hide position. What should be the Query like?
How to code auto numbering on certain criteria?
Could someone help, please? I'd like to have an auto number field based on certain criteria. I want to count a delivery note document. The delivery may happen in multiple actions. If I edit the record in the same action several times it should not influence counting. For example: In delivery1 action I open the report for editing and update two qty fields. It means +1 in counting. Later I open the record for another editing, but this is still delivery1 action, so there is no counting etc. Next time
Customer Portal - More user information and broader permissions
Hi, I'm investigating how to use the Customer Portal within an application. I understand the Sign-Up page (Name and Email address ) fields cannot be modified. However, in trying to capture additional information about user preferences and their company (which some of the information would also be contained within Zoho CRM. Is it possible to capture more information about the customer outside of the two key fields? And what is the best way of doing that? I have assumed it would be to create
Select which Admin email to use
Is there any way to choose which Admin email to use, in deluge, when emailing notifications?
Deluge commands used to duplicate records from reports?
Does anyone know the deluge commands that are used when you select one or more records in a report and use the duplicate function the the report menu? I need to build a workflow off of that to allow me to duplicate records with related records as template records. Thanks for any help with this Jason
Some Needed Functions
Follows from my post here: https://help.zoho.com/portal/en/community/topic/cryptography-function If we had these functions (from PHP), much would be possible URL encode a string: rawurlencode($var) see: http://us3.php.net/manual/en/function.rawurlencode.php Decode a url string: rawurldecode($var) see: http://us3.php.net/manual/en/function.rawurldecode.php Convert a string to base 64: base64_encode($var) see: http://us3.php.net/manual/en/function.base64-encode.php Decode a string from 64: base64_decode($var)
Create 1:N application from import
I am trying very basic 1:N (Member:Transactions) Import. Primary Key is Member ID. XLS spreadsheet has a Members sheet and a Transactions sheet. I created the relationship during the "Create Application with import" wizard. But no relationship gets created. All data got imported, but no relationship between the two. I followed instructions exactly. Help.
Import Phone Number
I'm importing data from a CSV. One column is a phone number and it's mapped to a Zoho phone number field. The import fails with the error on all rows with phone numbers: Row 3 Col 10 - The field value '262-1986' needs to start with the + symbol How do you resolve this? There is no way to add a + symbol in a spreadsheet cell, as it gets dropped. Thanks!
Deluge script after record duplicate action
Hi, I am searching how to add deluge script after a record duplicate action into a report form. I want to duplicate a record and just after that, change some fields values.
Next Page