How do i add Deluge strings into an html snippet in a page??
Hi! I know nothing about html... I'm trying to add the current date to the html code, but i don't know how. If i put it like this it shows the text "zoho.currentdate" instead of the date. HTML SNippet Code: <%{ %> <table border="1" cellpadding="0" cellspacing="0" style="width: 20cm; height: 2cm;"> <tbody> <tr style="height: 1cm;"> <td align="center" rowspan="2" style="width: 3cm; height: 2cm;" valign="middle"> <p> <img src="https://i.ibb.co/1GbhqLd/Marca-Madre.jpg"
How to have a button that increments a field value
I'm wondering if there is a way on a form (or, I presume it needs to be on a page, actually) where I could have a button that every time it is triggered it increments a field. Basically, a manual counter. Can anyone point me in a good direction? Thanks! Best, Brady
text value in formula who use lookup
Hi, i would like to see the text value result ( and not the ID ) when i use lookup result in my formula. exemple ( client_name is the lookup field) input.client_name+ " " + input.adresse result : 10800000000 rue de la paix 75012 paris regards
Fetch and lookup fields
Hi all, I'm relatively new to Creator and am struggling to fetch a record from a linked form and return a field value as text. If anyone could advise where I'm going wrong below then it'd be greatly appreciated - I've tried to explain what I am hoping to achieve in the code. x = Role_link[Personality_email == zoho.loginuserid].Role_name; // go to Role_link form and find theentry where the Personality Email (single line of text, not lookup) matches the logged in user email. // N.B. 'Role_name' is
Using a user input field to auto-populate 2 over fields
I'm a new user to Creator and have stated using Deluge scripts - which are proving challenging! I'm migrating an old legacy system I created 10-15 years ago to Creator. The current system collects essential banking information account name, bank sort code, bank account number, bank name and amount to allow me to submit a flat file to the Banking Clearing System so that I can collect money from out clients bank account. I have imported all of the UK banking information into a Creator Form and List.
How to fetch data from one form to another ?
i cant pull data from my form !!
After recent ZC Update having issues with an image field on Cellular Phone
Guys I have a form that envolves taking a picture and submiting it, after the last ZC5 update that recently rolled out my app crashes when i submit the form i dont know if somebody else has reported this, but can you please look into it, this only happens on cell phones, i can do it on the computer and its working fine, but if i enter the information on the Cell as soon as submit the app closes and kicks me out, if I don't use the Image filed it does submits correctly All this was working perfectly
Insight or sugestion on multiple record edit
Hi Zoho Community I have an app to manage the logistic operation of a trucking company, the cargo is Automobiles and i have all my forms and reports to do it, from Customer new orders all the way to vehicle assignment to a specific truck, heres where i ran out of ideas. right now im using a report of unassigned cars im able to do multiple select of record and modify the record specific field for transporter and date of assignment. Lets say i have 25 available cars in northern CA and im sending out
Add already existing records to subform
Hi! I have an app with a Parent Form "Clients" and a child Form "buildings". Buildings it's a subform in clients, but also an independent form. There where records added to Buildings outside the Clients subform, so they do not apear there. How do i do to make does records in the subform? I allready tried creating a bidirectional relationship, but did't work...
Records not showing for Embed Code
Hi All, I'm having trouble with the embeded code (iframe) . The table is loaded but it doesn't show any records. It just continually shows that its loading at the bottom of the table. What would be the cause? http://www.bizify.com.au/testiframe.html The following is the permalink https://creator.zohopublic.com/accounts12/muslim-professionals/report-perma/Members_Public_List/P8P9kv6YOG818UmAAzSdAU2XOwVtKd5wt4Q7me29J1OB3Ms2wqJy1jsHzFBeFkWO28dnKz1100hvFAYZNvbFnfQuJaNO3pMV871F
Expanding subform
Hello, I created a form (called Orders) which contains 5 fields and a subform. (in fact this form is a customer sales order). I build another form (called Items) which will contains each items requested and linked to the Order form. Items Form contains about 20 fields. I insert the Items form in Order Form as subform. My visual problem is that adding a new items, the Items form displays the 20 fields on one row, which is not optimal to be worked... Ideally, I would like: - for each order, to display
Help me understand
Hi guys another question here Im following the CUSTOM-ACTION-EXAMPLE thats posted in here, heres the function thats passing the multiple values to the stateless form to be edited void employee.showPayHikeForm(Employee employees) { querystring = ""; for each employee in employees { querystring = querystring + "empid=" + employee.ID + "&"; } openUrl("#Form:Salary_HikeForm?" + querystring,"popup window","height=400,width=400"); } I noticed several problems with it as its is setup, I have a similar
Option for 12-hr time format?
Ok, I live in America and poor Americans generally don't use or understand the 24-hr time format unless they were in the military or had a specific reason to learn it. I know, I know... So, would it be possible (or is it already) for Creator to provide the option as to how the time format is selected in the widget and displayed in views? I know I can script the output to be 12-hr format, but it's the poor person entering the time in the form that has the biggest problem. Any help? Datazen1 datazen1@gmail.com
Select a group of items in a subform and sum the value of a field of these group of items.
Hi, I am very new to these deluge scripts, I am creating a system here in Zoho Creator. I have a group of items in a subform, In here I have a field called "Bill N°", that has the choices "1", "2", "3", "4". also there is a "Price" field for each item. What I want to do its take all the items in this subform that are in the "Bill N°" choice "1", and take all the prices in these group of items and then sum them all to get a total in another field outside the subform. I was following this guide: https://www.zoho.com/creator/help/tutorials/advanced-app-building.html#Subform-Actions.
Disable "Autocorrect' on mobile for specific text fields
Hello, It would be awesome if we could disable Autocorrect on specific text fields. For instance, we have a field in which we collect cars license plate… Unfortunately, in the mobile app, the Autocorrect often modifies the entry, without the user noticing... Same thing happens with first names and last names... Thank you in advance, Jonathan
Want to add an image button to open a ZOHO Creator Page
Hopefully, this will be a clear explanation of what I want to do. I have a home page (which is a Page, not a form or report) which has a standard Page Button embedded on it. The button is labelled "Calendar". The button is set up to perform the action "open a page", so when the user clicks on it, it opens a Page called "My_Calendar". I want to replace this Button with an image that looks like a calendar. I got the image to display just fine, but for the life of me I can't figure out the correct
Add semi-transparent layer and additional information when taking pictures
Hello, In the mobile app, we'd like to add a semi-transparent layer when a picture is taken, in order to help the user capture correctly the document/object. We'd also like to be able to add a caption when a picture is taken, to guide the user. Please find attached some examples from another app. It can also to be used to help users capture ID Document, Passport, etc. Thanks
Make Hide/Show, Enable/Disable fields work in offline mode
Hello, Is it possible to make Hide/Show, Enable/Disable onload actions work even when the app is offline ? Thank you in advance
Use a user's previously entered information to do calculations on current form
Hi! My premise is that a user will access the app, enter data in a form for example: amount of bananas: 1 banana. Next day they go in and enter the same form, while other users also update their own form data, stating the banana amount for that day. I would like to add logic so that if the bananas are a different amount from the previous day, it adds a question: "why are there less bananas today?" so that the user can say what happened to the banana.. So basically it's stock taking. How can I retrieve
Page break detection for table in Print Template
Hello, is there any option to stop table made of subform values, to be cut on end of page ? I mean it would be best if it will finish on row before end of page and continue table on next page with new header
Columns too far apart
I changed a field to be size: Large instead of Medium. After this I noticed that there was a wide gap between the two columns. I switched the field size back to Medium but the gap didn't go away. I also added a subform, perhaps that had an impact? I've opened the form up for Zoho to edit/help. Is there anyone who can look into this form width issue? Here's a screenshot of my form next to what a normal form would look like:
Zoho Customer portal
Hello It is OK to show portal log in user only his belong report by add condition to report to show only Email but what if user will use form to apply leave for example , look up field for employee list will show all employees, How to show log in email user only ? Thanks Fahad
Cannot find setting in report to define iCal url
Hi There, I have created a Calendar view, and can see in the old documentation that you can create an iCal feed from that. But in my view, I do not have such a setting. Has this changed? Or am I looking in the wrong area? I need this as we are building a planning app; I want to be able to see Creator's item's next to my calendar items in the iCloud environment. thanks a lot for helping out! Boudewijn
Subscription for Developer
Hi, I have been developing FileMaker application for last 10 years. I would like to become a Zoho Creator developer. What subscription should I purchase to create apps for customers? Is Zoho One good enough? If I have Zoho One subscription, can I develop applications for any number of customers and share the apps to them? Is there any help articles/blog posts regarding options for developers?
Record templates header size
Hi, in the Record templates, which is the best size of image to be put in the header and footer? I'm wasting a lot of time to find the right size without success. Please help me. Thanks.
Recurring events or appointments in zoho 5
Hi, i tried to look on the forum and such but can't seem to find it not for Zoho 5 at least. Is there a way to make an appointment in Zoho Creator to repeat each week or month or such. I made a form with a begin and enddate and would like this dates to repeat as upcoming appointments for say the next 52 weeks or something like that. Is this possible ? Could you help me out ? Thanks Bart
Query last entry
Hi, I have a sales form for a loyalty program with the following fields: Sales Date Membership Number Customer Name Last Sales Date Is there a way to query existing sales, when inputting the Membership Number, to populate the Last Sales Date field with the last unique entry date for that specific member?
encodeUrl Function Bug
The space character is being encoded incorrectly. It is being encoded as a + (plus character). It should be encoded as a percent sign 20 . I have not checked all the other characters, so I can't say if there are any other characters that are being encoded incorrectly. Test Case: alert(encodeUrl(" ")); This produces a plus sign instead of percent sign 20 . This bug causes all string parameters passed to subforms to fail if the strings contains a space character.
Portal link not working
I stupidly cancelled my Zoho Creator Portal add-on, so I re-subscribed. But when I try to add a user the email link goes to a page saying my app is down for maintenance.
Post, Open, Invoke URL issues on iOS and Android
I have an Epson TM-T88VI thermal POS receipt printer. It has an Android and iOS app, TM Assistant, that takes takes an XML string from an HTTP post and sends it to the printer. It works fine it I just type these commands into the web browser, Safari. But I am unable to automate the process with Deluge in Zoho Creator. I have tried postUrl, openUrl, and invokeUrl, but they all give different errors. Here is the command I type it into Safari: tmprintassistant://tmprintassistant.epson.com/print?ver=1&data-type=eposprintxml&data=<epos-print><text>HelloWorld</text><feed/><feed/><feed/><cut/></epos-print>
Invoke URL - does it exist?
@Support: I have come across this: https://www.zoho.com/creator/newhelp/script/deluge-invoke-url.html in the help documentation, however when I try to use it I get an error. Thanks, Damien bcCloudTech
Weather API function
Hi All, I am looking at creating a function for a historical weather api. I have not had much programming skills in relation to html, JSON, etc. I was looking to have a date and use the added location or IP address in a form from that date to then bring up a small weather report. (Temp, Wind Speed & Wind Direction) I have looked and can only find a previous topic from 6 years ago. Is there anything updated or has anyone got any experience in this that they can help? Dave
Deluge Script Syntax Problems
I am creating my first Zoho function (but I am not a programmer!). I've been trying to copy examples in the documentation. I've hit some problems with syntax. The function is triggered when a ticket is created in Desk from an incoming email with a certain subject. What I aim to do is to create an activity record, scheduling a call for the next day. The call is to be associated with the Lead and the owner of the lead. Issue 1 ---------- In order to get the Lead Id, I've been trying to get it using
Last 5 yeard addresses...
Hey community, We have to create a script to compleate the addresses the users had in the last 5 years and I wonder if there is any delug scrip premade for that.
Form Layout Options - Beyond "1 Columns or 2"?
I admire what you've achieved with Zoho Creator, and would like to become a regular developer on this platform. However, I'm finding the Form layout and design options far too limiting. I need to be able to create forms which: use more than 2 columns group fields into sections Here's an example of the kind of layout I want to get closer to creating. Is there a way to create multi-column layouts in Zoho Creator, beyond 2 columns? Is there a way to add lines, boxes and sections to forms, to
Comments / Notes section on a record - How would this be done? Is there any Easy way of doing it?
Hi guys, this is my first post on here so sorry if i miss out any crucial information. I have been learning creator while building a project management system of sorts for my design and print department. We currently use a custom module on CRM to make work order tickets but with Creator we can really refine the system and design it around our needs. One big feature I'm looking to add is something we currently use that is designed in CRM, this is the notes section at the bottom, as shown in the image
Excel Processing
Hi, I currently use Zoho creator along with Zoho Analytics to have an application that i can import sales data into. I import the data as CVS. Before I import the CVS file I need to process the data to have all my clients information in one file. To do this I download a report weekly for a 10 clients (the data is a CSV but I've been saving it to a XLSX). Then I run a macro which uses an append query to add the data to a master table. And there it fell over. Turns out the downloaded report is dynamic
Structured data field info not being returned by the REST API
I'm using the Zoho Creator REST api to get some data stored in a form which uses the Name and Address Fields, but these values are being returned as plain strings so there is no way to know which part of the string is the First Name, Last Name, Address Line 1, Address Line 2 etc.
.get() giving error: 'TEXT' can not be cast to '[BIGINT]' for the function 'get'
so_products = sales_order.get("Product_Details"); info so_products; prints: {"product":{"Product_Code":"VOT-700400-2","Currency":"TWD","name":"VOITAIR VA 400 BLACK no base (黑芳香機.無腳架) / VOT-700400-2","id":"1839893000000212252"},"quantity":1,"Discount":0,"total_after_discount":82000,"net_total":82000,"book":null,"Tax":0,"list_price":82000,"unit_price":82000,"quantity_in_stock":-1,"total":82000,"id":"1839893000009394337","product_description":"VOITAIR VA400 divers (黑芳香機.無腳架)","line_tax":[]},{"product":{"Product_Code":"VOT-122900-821","Currency":"TWD","name":"Scent
Attaching uploaded file in the email
Hi, I would like to know how to attach an uploaded file in the email notification.
Next Page