ZOHO Creator Developer
HI All, we are looking for Zoho Creator Developer (Permanent job) with the below : Website Integration - Integrated Zoho product (Zoho CRM, Zoho Books, Zoho Campaign, SalesIQ, Desk, etc ). - Created Reports and Dashboard in Zoho Report and CRM - Custom Function. - Zoho Creator. - Third Party API Integration. Location: Jordan if you are interested please email inbox me with your CV at: a.freij@e-megatech.com
Importing .xls / Column limit/ Subforms/ Converting radio buttons to numerics/
I had a form working well in Zoho Forms but decided to turn it into a Creator project because Creator allows you to use a camera on an iPad etc. The application is really just a form that allows me to go onsite and fill in a bunch of details- this in turn merges with a Zoho Writer doc and spits out a report for the client. But I have a couple of issues - my form was 148 columns but Creator won't take more than 70 via Excel. I got around this by creating each section as a different Excel Sheet, but
Find out if course register is already registered
Hello, I have a form for a course registration with a field of Delegate_ID. I want that field when entered to check whether the Delegate_ID is already registered against the Delegate Registration form (report). I have tried this but it doesn't work... Looking for some guidance: check_id = Delegate_Registration [ Delegate_ID == input.Delegate_ID ]; if (Delegate_ID.count == 0) { alert "Please register first "; }
How do you populate an address field using Deluge?
I can't see this documented anywhere. There is auto complete but it seems buggy. Would be great if you could create a documentation page for this. Same for Name fields (there appears to be no autocomplete at all for Name). For reference: input.Address.address_line_1 = address_line_1; input.Address.address_line_2 = address_Line_2; input.Address.district_city = address_city; input.Address.postal_Code = address_postal_Code;
Calculate the the CRC-16-CCITT in Zoho creator function
I need a custom function in Zoho creator to calculate CRC-16-CCITT with polynom (hex): 1021 Initial value (hex) :FFFF the function is use to calculate CRC-16 by returning a 4-digit Hex value with a string input. like input the string of "00020101021126270012hk.com.hkicl020782419455204000053033445802HK5902NA6002HK6304" it returns "6674" (hex) or "00020101021226430012hk.com.hkicl0418wsdinfo@wsd.gov.hk060115204000053033445406174.605802HK5902NA6002HK62150111979072028366304" returns "65CB" (hex)
Programmatically set the selected item in dropdown on form open ?
Hi all, I have a form in a Creator App with a dropdown of 15 items. On opening the form, I want the first item to be selected. After hitting submit, the same form is shown but this time I want the second item selected. And so on to item 15. How would I achieve this ? I see there is a pattern of field aliases discussed here https://www.zoho.com/forms/help/settings/field-alias.html . would I use this ? e.g. https://forms.zohopublic.com/.../?fieldalias_gc=Group1&fieldalias=option2 Thanks in advance,
Translate lookup field value into single line field
Hi All, I have two separate applications: app_one and app_two app_one contains a form with a single line text field "email_one" app_two contains a form with a lookup field "lookup_email" and a single line text field "translate" When a user selects a value from the lookup I would like the value to appear in "translate" I've attempted the following with no joy: hello= app_one[ID = input.email_one]; input.translate = hello.lookup_email; Can someone tell me what I'm doing wrong? Thank you in advance.
Send confirmation email using the default template on submit if the Status field == Submitted
Dear Zoho Creator Team, Is it possible to write in Deluge script to trigger the Send confirmation email using the default template on submit if the Status field == Submitted ? The currently default template is fine however can I trigger Creator to use this template to send an email conformation to several departments when a user updates our Status field for the form to equal "Submitted" Currently, the form sends the default template when the form is first submitted. However, I would like to only
Related dropdown fields
I have the following master table of States and Cities. How do I insert related fields in another form, so when the State is selected, only those cities in that particular state are displayed in the City field. Currently the lookup fields in separate forms show all states and cities. State City California LA California San Diego California San Francisco California Fresno Florida Jacksonville Florida Miami Florida Orlando
Limit some profiles to web and others to mobile portal
it would be great if we could control which profiles can access the web portal version and which can access the mobile version of the portal. that way we can give access for administration to the portal web user, and acceas for the regular user to the mobile app only.
Hide/Show section based on a subform entry
Hello Creator community, Question - can I hide/show a section based on whether or not a value exists within a subform? Example: A subform contains a picklist called "Tax Forms". If an item is added to the subform with a "W-2" in the "Tax Forms" field, can it then show a section elsewhere in the app called "Additional W-2 info"? Where I'm at: Here is the screen I would normally add the workflow to hide/show a section. But the "Select a field" drop-down doesn't allow me to set the condition to a value
Counter from 2 dates
Hi I am trying to create a formula where it gives me a number by subtracting difference from 2 dates Completion_Counter (result to go here) Reported_Date - Date_of_Completion = Completion_Counter Is this possible so for example if report by date is 20/11/2019 and Date of Completion is 21/11/2019 the result on Completion Counter will be 1 Thank you for help
Creator Change Title Housing Forms and Reports
How can I rename the portion highlighted in red in attached image
Add parent form fields to subforms pivot report?
Hi there! Is there a way to add the fields from a Form when creating a pivot table based on it's subform??
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 !!
Record Summary Template - can we use deluge script?
Hi, I have created a Record Summary Template using the template builder. While showing a record I would like to show other record from different table which do not have any link to the current record/table. I tried to look for a way to insert deluge script but could not find a way to do it (no script builder button or template definition section). Is there anyway to use deluge script in Record Summary Template? Thank you, Pambudi
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
What is Bidirectional Lookup? Why we use? and how to use?
can anyone explain me what is Bidirectional Lookup? Why we should use? and how to use? Thanks in advance
How to parse Json in Zoho Creator
I have a huge json which i get from crm sales order . I have to parse that json and upload that record into zoho reports. Is there any way in creator to parse json. { "response": { "result": { "SalesOrders": { "row": [ { "no": "1", "FL": [ { "content": "15 Taco Bar - Fabio 5/12", "val": "Subject" }, { "content": "Emily Fabio", "val": "Contact Name" }, { "content": "Confirmed for Delivery", "val": "Status" }, { "content": "Chaska Private Parties", "val": "Account Name" } ] } ] } }, "uri": "/crm/private/json/SalesOrders/getRecords"
configure list report
Hi, I need a list report where I have aggregated values. For example I can see the ordered qty of a product per rows, and I can get the total when I edit the report. I want to see the total only, and would like to hide the rows, the total comes from. Can it be solved? Thank you George
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
Webinar: an enhanced app development experience
Hello, where can I watch yesterday's webinar: an enhanced app development experience? 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
how to copy data from one field to another ?
With my data base at Zoho, how is it possible to copy data from one field into another ? Thank you
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
Auto populate a feild from another form
as above
Next Page