Best Way to Merge Offline App Forms with Regular Forms Data?
Hi, I have users who go out into the field without Internet. We need to enable them to enter data into our Forms. Given Zoho restrictions I can't cache Forms for offline access if they have any Deluge scripting anywhere in the Form but in On Validate and On Success (see: https://www.zoho.com/creator/help/application/offline-mobile-access.html)... As I have a lot of automation in my Form's Field Actions, I have to create a separate Form specifically to allow offline access. For example, let's say
How to make application available offline
I have created two application online, now I want them available offline on my ipad. I can access them online, but then once I goo off the app disappears (i.e. leaves me with "no apps" message. What am i doing wrong?
Sub-form filters in record templates
Is it possible to filter the records of a sub-form while adding it into the record templates? I want to add details of all the records separately in different places of the template. Regards
Positioning the pop-up date calendar
Hi Everyone, Is there a way to get the pop-up date calendar to position itself so it wouldn't get chopped off like in the attached screen shot? I also noticed the Submit and Reset buttons are centred. Is there a way to get the form centred as well? Here's how I'm calling the form. <iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/rleiman/tutorials/form-embed/OM_Orders/sZ4vqFqP4syrKQ22x2JmQrBbQeVORKUqHj6p88VSVxADJNGfhX7gRxe7jqbOsdREQR4QbjgwbsAeaz9hNpZQDZEKazHgwMg774nf'>
PROBLEM
I am unable to access my app its showing This application is not accessible. Sorry , you are not allowed to access payroll. Please contact this application's administrator.
Auto Stock Level with a Reorder report
I am starting to create an Auto Restock level based on Products Used, Current Inventory and Purchase orders. I have a form for Products Use, and Inventory, and a Purchase order. I am trying to determine if I use a "For Each Statement" or a "GetTotal Statement". Here would be the theory; when a product is used, it would count how many of that product were used in the Past (Selectable time, say 90, 120, 365 days), and put that number in the "Stock Level field" of the Inventory Field. Then auto create
Duplicate report function not savings duplicate reports
Good afternoon. When clicking on the "Duplicate" link under the report while in the Creator Application Dashboard, the system gives a "Saved" message, but does not return a duplicated report. This has worked as recently as an hour ago. Now, no reports are duplicating. Can someone assist with troubleshooting? Thank you!
App from G Suite - Spreadsheet
Hi, I converted by Google GSuite Spreadsheet - to zoho creater APP. My question is - once i have converted to APP, is the communication still there with spreadsheet. I mean any change i make in G Suite Spreadsheet - will it get updated to ZOHO app and vice versa. Any one with any experience on this
Image not appearing in html view to PDF
Hi Support, I have created html page which has image. I can view the image in html view. But when tried to convert to pdf, the image is not available. Kindly help with this issue. Regards, Riswan
HTML to PDF
I'm going to use a page to generate an HTML invoice. I will then use a webhook to send a URL to pdflayer to generate a PDF. pdflayer will respond with a URL where I can download this invoice in PDF format. Question: is it possible to take that URL , download the PDF and save it to a creator form?
Pull Date from CRM
Hi there, I'm having issues pulling date data and auto-populating my Creator fields with it. I'm successful in pulling other types of date. Here's the code I'm currently using to pull data: crmResponse = zoho.crm.getRelatedRecords("Contacts","Contacts",input.Customer_name_ID.toString()); c=crmResponse.get(0); Email=c.get("Email"); Account_number=c.get("Customer number"); Address=c.get("Address"); Address_cont_d=c.get("Address cont'd"); City=c.get("City"); State=c.get("State"); Mobile=c.get("Mobile");
Inserting data and lookup fields
First . I import a googlesheet named "Customers" in zoho creator. Second. I try to insert another goolesheet called "Files" in "Files" seett i had a field refers - lookup and fetch the name fo the customer Now i try to import the sheet called "Files" but i dont know how to tell the created form that the values in the field (customer) must be lookup fromthe other form. Is any solution for this???
Custom layouts for forms and pages
I have seen many posts where people indicate they are using custom layouts on their forms, but the Zoho Creator does not have custom layouts. I hope some of you will share how I can also do that. Since I'm still learning how to use Zoho Creator, it's very frustrating to find out there are no tutorials on the Zoho web site or even on Youtube showing how to do it. I have seen that many of you have used inline CSS to make the custom layouts. I can look for some inline CSS layout code generators, but
Stop Rounding Results in an Equation Until the Final Value
We have a formula where we calculate a daily rate down to the 6th decimal place. A precision calculation. For example: 1000 * 12 / 365 = 32.876712 Despite trying many alternatives, I can not figure out how to get this number, the result is always rounded to 2 decimal places. Like so... 1000 * 12 / 365 = 32.900000 I have the result going to a decimal field with 6 decimal places. But it still shows up as 32.90. I tried the round function..still 32.90. I have also tried toDecimal function too. (1000
Changing a radio button to a check box?
I recently took over administration of an already created form. There are many instances where there is a radio button but I need it to be a check box so multiple answers can be chosen. Is there a simple way to change a radio button to a check box? Thanks!
Update email notification added user
I am the administrator, when a user asks me to update the information in the database that the user entered, how can I send an email notification, that I make the change? I try whit it, but not work (added picture)
API
what is the difference between REST API and XML RPC?
Integration with otp
Does zoho creator support OTP integration?
Inventory Management
I am trying to use custome action on a report to transfer data from one form to another and make the new form editable is the possible
How to sort results of CRM API response
I'm requesting records from CRM API inside a custom Creator Page using code like this: apiUrl = "https://crm.zoho.com/crm/private/json/CustomModule3/searchRecords?newFormat=1&authtoken=XXXXXXXXXXXX&scope=crmapi&criteria=(Device_ID:99999999999)&sortColumnString=ID&sortOrderString=desc"; apiResponse = getUrl(apiUrl); I need the records to be listed in DESC ID order. So the most recently entered record will show up first in the list. How can I accomplish this as the searchRecords method does not seem
Problem in sharing application
Hi, I have tried sharing my application with the other user, but unfortunately it is opening with the other section instead of opening with my section which I shared. I don know from where it is taking that url. Whichever the section I share it is opening for the user only with the particular same section. It is urgent. Please help me out of this issue. Thanks, ITKES
Insert sub-form records individually in record template
Hi, I need to add the fields of my sub-form record individually in my template and the hard part is that i need to do it individually for each record. Is it possible? Regards
Function - passing current (sub)form data to function impossible?
Hello, I am trying to make a function, that would as parameter get the current subform data, and based on that make calcualtion. But it seems impossible, I get an error: Error details: Error in executing On User Input script of the field, Štev. obiskovalcev Error. Error in executing Set Variable task. Unable to update template variable tot. Error evaluating NUMERIC expression : Error evaluating COLLECTION expression : New Collection row cannot be passed as argument to function. It seems like Zoho
Lookup fields stopped working today
I have been running my app for almost a year now, no changes on my end. Today my lookup field to lookup field stopped working. I have a Category and a Product lookup field Category is selected first I have about 7 categories (flour, sugars, spices.....) I select flour and the next field should limit the Products to just the Category of flour, but today it saying "No Matches Found" I havent changed anything on my end. I look at the FILTER section on the Products field and it has SET FILTER checked
Missing display fields in a lookup field
Hi Everyone, I have a lookup field that has a filter set based on a previous lookups selection. Similar to the country and state scenario. My scenario is a vehicle make, model and variant scenario though. I have a form for each - one for make, one for model, one for variant. Make just contains a single line for vehicle make Model contains a lookup to the make field and a single line for model Variant contains a lookup to make, model and a single line for variant but also a dropdown for year from,
"Error occurred while duplicating records" without reason
Hello. As the title says, my app started throwing the "Error occurred while duplicating records" error. It even doesn't allow me to add new records. And it doesn't inform the reason, so I don't know what to do to fix it. What can I do to solve this? Thanks in advance.
multi select lookup with reports
i want to create a report for that selected lookup field entries how can i do that can you please send any sample code ? for each item in input.Students1 { ins = insert into filtering_students [ Added_User = zoho.loginuser Add_Academic_Year = item.Academic_Year Manage_Course = item.Manage_Course Manage_Batch = item.Batch Date_field = item.Date_field Add_Subject = item.Subject_field Students =item.Students1 empname = item.empname ]; } its my code . students1 is a multi select look up. but it throws
Acceso de info a clientes
Hola. Existe la posibilidad en zoho de dar algún tipo de acceso a mis clientes donde únicamente puedan ver su información sin necesidad de que tengan un usuario o rol???
image are not getting fixed size in pop up window
hello zc, In a form i add a notefield where that note field is used for showing image.when the form opens in main window the image size getting fixed when the image opens in pop up window it is not getting fixed.can anyone tell how to make a fixed size even in pop up window? input.plain = "<img src='https://www.smashingmagazine.com/wp-content/uploads/2015/06/07-functions-opt.jpg' height='300' width='1000'>";
Sub-form templates
Is it possible to combine multiple templates(templates of a subform) into a single template(template of main form)? I want to show all the subform templates together in the main form.. is it possible?
Background images
can i have a background image or change the background color in forms?
Deluge Script: filtering a view based on user input
Hi- Upon login, I want to be able to have a user select from a list of projects and then display a filtered view based on that project selection. I want to be able to do this in a script. Any ideas? Thanks.
Grouping Drop Down Values
Hi All, I'm trying to get a Parts Selection sub form working in my Repair ticket form. I have 4 fields in my sub form: Model Parts Catagory (Base Plastics, MotherBoard, Screen PLastics, Screen etc..) Parts Description (this would list say Screen Fascia, Palm Rest, Screen Lid etc..) Part No. What I want to be able to do is Choose a category, which then lists the descriptions under that category but only category once. So for example, I choose "Screen Plastics" as my category and I want 2 options,
Calculating the median by using percentile
Hi, I try to calculate the median with the suggestions made by one of your blogposts. https://help.zoho.com/portal/en/community/topic/how-to-get-median-to-work. I use a pivot chart in which I have the number of patients that had a fall per month listed. I added the formula as suggested by the answer to calculate the median: Percentile("Autoview_1498650252695_Clinical_Quality_indicato Table"."Number of patients that had a fall",50) but that does not work. Can you provide me with some suggestions
Retrieving actual text from a Lookup Dropdown
Hi Everyone, I'm following Zoholics videos on Deluge and used this statement to lookup the pizza price from the Inventory: colPizzaDetails = Inventory[Pizza == input.Pizza && Size == input.Pizza_Size]; This error is displayed when trying to save the script: In Criteria left expression is of type STRING and right expression is of type BIGINT and the operator == is not valid In the video, he was able to save the script. Looks like a BIGINT is stored in the Lookup Dropdown now instead of text as shown
My app stopped working - Lookup fields
I've tried 3 browsers, MS Edge, Chrome and Chrome on a Chromebook. And my App stopped working over night. I have two lookup fields, The first lookup field never sets up the second lookup field. It was working fine yesterday and today its not working. I've not touched my code or changed anything as its a production program, so I'm at a loss as how to fix it. Thanks Andy
my account is inactive
my account hello@sexysexdoll.com is inactive without any pre-reminder. I have tons of customer requests there, now I can't access to my business, it makes me lose a lot of money now! this is ridiculous. Please reactivate my account ASAP.
Computation of Age
How do I automatically show the age of an employee based on his birthday input and today's date? what field would I use - number or formula field to show such automatic computation? Thank you. frsaiop
How to Cache Lookup Fields for Offline App Access?
Hi, In the Offline App access section it says that my Form will be cached for offline access if it meets the conditions here: https://www.zoho.com/creator/help/application/offline-mobile-access.html My app meets these conditions and is available offline, however, I notice that the lookup fields are blank. Obviously this surprised me, shouldn't the lookup fields be cached so they have all existing choices in them when offline? I noticed that if I load the Form online, go through all lookup values
Simple search interface with a Lookup Field instead of Single Line
Hi, I want to apologize if my question seems too trivial - I am just getting started with Zoho, and I figured almost everything I need except for the search function. I want people to be able to search my records using their email. I used the Search Interface in Zoho Creator tutorial available on this page - https://www.zoho.com/creator/help/application/search-interface.html. Search works when I am querying a form that uses Single Line to store data. However, the problem arises when I search the
Next Page