Publish Deluge script on own server
Is it possible to host the deluge scripts on my own server? Oliver
Who is the best partner in the south of the UK who really knows Creator?
I am considering a project that I think needs to involve creator so I would like to talk to somebody who really knows its capabilities
Subform field details in email
How do I include subform details in an email? When I create a record summary to attach to an email (using senmail function) to display details of both the form and subform, the subform fields appear to be empty. Please help!
Form Automation not working on script update of decision box!
I'm trying to dynamically limit the number of subform rows allowed based on number field in form. I have setup form automation to hideAddEntry in subform on a decision box. This works when I manually click on the decision box. However when I use scripting to update the decision box, form automation does not work. Is this default behavior? Damien Cregan Hire an Expert
HTML image view issue
Good day I have an HTML output where I need to display a image for a signature, I already have the link for the signature but when I display with the HTML img src I can't show correctly. for each x in FetchRegistro { link = x.Firma_Url; LinkFirma = "<img src='" + link + "' alt = 'test' height='30%'/>"; output = output + "<tr class='rowVal'><td>" + LinkFirma + "</td></tr>"; } If I replace link with a sample value of the Firma_Url it works LinkFirma = "<img src=" + "https://creator.zoho.com/czambrano1/recursohumano/Firma_Diaria_Report/2357982000002871223/Firma/image-download/1426707525078_signature.png"
Wrong Language Dates
Good day, I setup my application in Spanish and in settings I set the following date format (spanish tag) The problem is that in my reports date appear in English (all the app is in Spanish), I already check if there is any wrong translation but everything is Ok,
Want to make a public form
Why cant i make the form i made public? It will only allow me access to private sharing. I'm not sure what to do.
BUG: "Users" type field cannot be referenced
Hello, It seems "Users" type field sometimes can and other times cannot be referenced. My app contains a form called Users, having one field of being type "Users" and named Username 1/ "User" type field cannot be used in list The code below create error UsersList_SelfLookup = Users[Organization == LoginUser.Organization].distinct( Username); UsersList_SelfLookup.sort(true); Trips_Approver:ui.add(UsersList_SelfLookup); 2/ "User" type field can be used while fetching record "On User Input" but
Passing values in the URL
I've done this before in PHP but just can't seem to work out how to do it in Deluge. I have a form called FormA. It contains a field called ID_name. When submitted, I want this form to send the user to another form called FormB, with the value of ID_name written into the URL. THAT MUCH I can do. It's working fine. I use a questionmark between the URL and the ID-name value. However, I now need the second form to read this value (ie what follows after the question mark) and to use this as input
more than 5 records per page for mobile applications
Hi, is there a way to show more than 5 records per page in a summary view when oppened in a mobile device? I saw a post about this with a negative answer but that was a few years ago. Perhaps something can be done now? Mobile usage is key these days. another question, the "next" page button shows in the header of the view. Is it possible for it to show also at the bottom? Thanks Luis
Populate subform from unsaved parent form
Hello, I'm getting my feet wet with Zoho creator. I want to create a rudimentary parts management system that will have records for manufacture, testing, orders, RMA, etc. I am trying to create a form for orders, consisting of a PO#, date, and customer (which is a lookup from the customer form). I have an order item subform that includes PO lookup from the parent form, a lookup for the item part number from the 'item' form, and quantity. The problem is, the PO# can't be looked up until the parent
errors running zoho creator native app on iphone6
We have written an app that required users offsite to use, and therefore need to implement a robust mobile platform. Problem so far is we are having different errors appear over various platforms. Is there a known issue with the zoho creator native app running on iphone vs android vs mobile browser ? Also, what is the most reliable mobile browser to use on either apple/android if we wanted to run the application via mobile browser rather than the zoho app ? Getting very frustrated with inconsistencies
hide print option
Hi, I am trying to hide print option in the view. I was trying with below code but it seems it is not working <div elname="zc-component" viewlinkname="MVPD_Channel_Form_Report" params="zc_Header=true&zc_AddRec=false&zc_EditRec=true&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Print=true&zc_Export=true">Loading View...</div>< See below output result: Can anyone please help me Arfater
HTML Close Table Borders
Good day could you please tell me how do I close the borders for this table, (bottom and right border) HTML output = output + "<table class='tableSize' align='center' frame='border'><tr><td style='width:20%;vertical-align: top;'>"; output = output + "<table border='1' align='center' cellspacing='0' style='border-color:#EEE;width:95%;margin:0px 0px 0px 0px' id='billingAdd'>"; output = output + "<td class='rowHead'>Consecutivo</td><td class='rowVal'>" + AvanceDiario.Auto_IDStr + "</td></tr>"; output
REST API Response
Hi I got the following response from REST API call. var zohochandrasekhar.kview54 = {"Welcome":[{"ID":"1205836000000077129","Image_Url":"https://pbs.twimg.com/profile_images/459764305567576064/ILQOFcfh.png"}]}; Can you please let me know why the string "var zohochandrasekhar.kview54" is added before the JSON response. Thank you
Open Form with Lookup Value as a Parameter
Hello - I'm working on solution that will send email notifications on a scheduled basis to customers to fill out a survey via a link to a Zoho creator form. The survey form data needs to be related back to the customer form, so I've placed a lookup field on the survey form to accomplish this. I need a way to include the customer ID (the value of the lookup field) in the link so that the survey form can be related to the customer without prompting for that information. Using the standard "?customer_lookup=000000000"
zoho.loginuserid in criteria
list Team_Events { displayname = "Team Events" show all rows from events [team == members[email == zoho.loginuserid].team] ( ... ) } team == members[email == zoho.loginuserid].team returns the correct BIGINT. If I set team to that number statically, it filters the correct data. Why then does this not work?
overriding report permissions
If I set the permissions for a report to allow add, edit & delete the following code in an openurl will cancel these options. "/view-perma/Board_Minutes?zc_EditRec=false&zc_AddRec=false&zc_DelRec=false" However if I set the permissions to NOT allow add, edit & delete the following does not allow these features. "/view-perma/Board_Minutes?zc_EditRec=true&zc_AddRec=true&zc_DelRec=true" Is this the way it should work or do I have a problem with my syntax. Note this is for a Customer Portal user.
Digit Grouping for Zoho number fields
we'd like to see digit grouping feature for Zoho fields like Numbers, Decimals and currency. We have an application that generates bills and printed on invoice, but ZOho currency fields are not able to display digit grouping for the values. eg: we'd like a feature that would make USD 8346073.66 appear like: USD 8,346,073.66 Any help will be appreciated
Using checkbox as workflow automation
Hi, I am using a checkbox as a means to automate the process. As of now, I have 7 different selections in the checkbox. Each will have its own email sent out after it has been marked as checked. As of now, I am using IF statements to attempt this but i get an improper statement error. For example, the 7 checkbox choices are: (1) Awaiting Approval (2) Approved/Denied (3) PO placed (4) PO confirmed (5) Receipt received (6) Shipment received (7) Payment issued If I want to send an email after "(1)
Is't possible to move Form to another app
It will be very useful to have ability to move form and all assosiated views to another app. Now I have 4 app, which are full of different data, and they are using all, but sometimes it's nessesary to change architectury of whole application and I need to move some forms from one app to another. By hand it's very difficult to do. I understand that there may be some problems with openUrl function, which are using "#Form:.." or "#View:" navigation, but may be you can do something. I think it's possible
How to NOT display "null" in empty fields
I have a form called "New Request" and a stateless form called "Update Request Status". In Update Request Status, I have a field called "Task Pending Notes" - here, the user will fill in the notes and upon submission, this will save the notes into "Task Pending Notes" in New Request, along with a timestamp. This happens every time new notes are submitted, and they are saved, collectively with each note and timestamp in "Task Pending Notes" in New Request. This is also auto-populated into Update Request
Sendmail - Email sent to multiple persons
Hi, I have used similar code on a related form and it worked, but it doesn't seem to be working here. So, what I want to do is say, there are two email address fields - one is called Email Address, the 2nd is Email to CC. I want the form to send out a certain email and cc the 2nd email address IF IT IS NOT NULL. This is what I have: if (((input.Task_Completed.toString() == "Completed") && (input.Request_Type == "Create new SKU")) && (input.Email_to_CC == "")) { sendmail (
Embed web form
What are the steps to embed the web form on my website? Thanks
Cannot share forms or reports
I am trying to share an application with one other user. I've shared several sections and forms with the user. The user sees the application on the home page, but when clicked on it says the user doesn't have access to the application. Please help, Joe
Left Expression is of type string in lookup
After reading a number of posts, I understand the issue that my lookup is returning an integer and my initial data is a string. I've tried following the advice in the one of the forums and creating a variable to convert my lookup iD to the correct field. But I get an error message now on the variable. If the two elements were strings my code would look like: Email == input.Employee meaning that the field from form Ticket_Entry would perform a look on the field employee in form Employee. Of course
Using Deluge variables in data stored inside zoho creator forms
Hi I am building an error handling mechanism for an application. i want to store the error codes, error names and error messages in a creator table and send back the data requested according to the error code called for. in some errors, for example when a variable sent has an illegal content - Example: Document type can be: 10,11,12 user sent the value 13 for a Document type. In addition to the hard coded message stored in the table, i want to include some dynamic value, in this case the value the
Creator Background Image
How can i change the background like this?
Ordering Sections in Android App
The Sections (Tabs) are ordered alphabetically in the Android App, while the Sections are ordered as defined in Settings -> Sections. Seems to me the Android App should also order Sections as defined. Can we either change the Android App to respect the defined order or have the option to go either way? Thanks, Joe
Sort rows in a subform with display numbers
Dear All, Lets say that I have a subform with two fields like Description and Display Number. I would like when I click submit to sort the list with the Display numbers which I gave. example The first will be Guide Excursion... The second Bus transfer...Land People The third Bus Transfer...Thessaloniki Each time when I give the display Number then to sort them. How can i do that?
Printing on View Record page not working properly
I have embedded a published report table on my website and created a template for "View Record." On the "View Record" page when I click the print button it redirects me to a zoho login page for my app. This is unacceptable for my workflow. Please let me know if there is something I can do.
Email Notification Multi-Step
I have a multiple step form, that requires email notifications at different steps in the process. How do I do this? Example: In my Human Resources Time Off Request form, the employee must first fill out a time off request. After the employee completes his section, the form should notify the employee's manager via email (with the record). The manager goes in and approves or rejects the request. The form should then notify the office manager via email (with the record), that a request for time
Dynamic Picklist
I was wondering what I have to do to my dynamic picklist so that if value "a" is present multiple times for it to only show in the pick list once script: Product = Add_Product [ID != input.ID]sort by product_type; select_product:ui.add(Product.product_type.getall());
adding form data via sms
is it yet possible to add form data via sms?
Populate Checklist with fields from different form
Not sure if this or possible but would make life so much easier. Form A has 100 different fields. 1 Field ( lead_type) will be a lookup field to form B Form B has just a few with one of them being a check box listing all the fields from form A. In form B we will check the fields we want to appear for the different lead types ( based upon the look up) Then show or hide them accordingly . Now can i do this as an array of some type or will i have to do code for each leadtype i add I want to be able
Please Wait problem came back
Previously working code is now hanging with the Please Wait screen that never goes away. I submitted the problem to Support but maybe someone has experienced the same issue. Some words of wisdom would be greatly appreciated. Thanks in advance, Henry
Picking up openurl parameters from the stateless form I have opened
Not sure if I have phrased that correctly so apologies if I have. I have a report for a Call Centre which list outstanding referrals to follow up. The referrals are entered via a comprehensive form previous to the Call Centre seeing them. The Call Centre Report only shows limited details of the referral (due to confidentiality) but they do need to update certain fields in the referral record. So I have create the report for the CC and a custom action which now successfully opens the correct record
Multiple reports. one big one sending information to smaller ones
When i import an xlsx table it only goes into the table im importing to. what i want to be able to da is import to the main report and from there the information is linked to smaller reports big report contains: Item nr Product Name Active ingredient ATC Code Formulation Strength Type of pack Pack size MA holder License (EMA or National) Country Price (Native currency) Price (Euro) where the smaller ones only contains one of each element for the lookup field option. and maybe the option
Trying to sign up for : Zoho Creator Developer Program
I tried signing up for the Zoho Creator Developer Program. I got an email instantly with a payment link . But the link does not work. Is the program still active?
Changing report window size in a pivot report
When I generate a pivot report in Zoho creator and then click on a value I get a new zoho reports window of a fixed size. Is it possible to make this window larger or smaller? Chris
Next Page