Adding image via iphone
I have an image field. From the iphone, in edit mode, the user can click PHOTO or CAMERA. When the user clicks PHOTO, I have the error message: this app does not have access to your photos or videos You can enable access in Privacy Settings Where are Privacy Settings????
addYear function causing problems since last weeks zoho update
I have a formula that calculates an expiry date with this statement Last_Renewal_Date.addYear(1) It has worked fine for years but last week we got the error that says "Invalid field value" for this formula field. I think it is now generating a DateTime value instead of just Date --- which is not allowing us to edit the records. I have had a request into Zoho for over a week and they are not responding in a timely manner. Is anyone else having this issue?
Fetching wrong data
Hi, I have a Condo management app where I have two Condos with the same Unit Number but located in different properties and belonging to different Mngt_companies. I am using "Fetch Record" to auto fill in details such as Mng_Company and others. When I select the Property and unit number, the wrong Mngt_Company is Fetched. I have deleted the record in my master units form and recreating it but nothing seems to fix my issue. Thanks for your help. this is the script I am using: if(input.Unit_Number
Back up not working
I am trying to back up my application and I keep getting failed and null in the description. Is there something wrong? I only have one previous version.
name an excel csv on export.
Is it possible to create a name for an excel.csv export file on export? I've created an excel spread sheet with a vlookup function. When I open excel the *.csv file has to have the same name each time for the function to work properly.
Overhaul the SendMail Function to Allow for Easy HTML and Templates
I have been using Zoho creator for a while and it seems that the system to send email is VERY clunky. If I want to send HTML, I have to replace every " with a ' and other little tweaks. The Deluge and html do not work well together. Do you have any plans to overhaul this? I could envision an HTML template area where all you do is use your refer fields to add the dynamic content. This would be a GREAT and much appreciate upgrade. If not can I integrate with a transactional email program like Mandrill?
Attempting an Order Management application
Hello, I'm attempting to create an Order Management application and would appreciate any direction in helping me to think about this in the right way. This is what I'd like to do: 1) Import Order Number and related information via XLS file and automatically assign a "NEW" status to each of the records 2) Show "NEW" orders on a Home or Dashboard View with a click link to "Processing" Form that auto-fills the Order Number. The "Processing" Form would have the auto-filled Order Number field and fields
Assistance Needed With Developing an App
Hi, I'm still trying out the free version of Zoho Creator before I make the purchase and I need help with creating an app. Just a brief explanation of my business. We create and register private companies for individuals who want to start their own businesses. The process has two stages: - Name reservation - Incorporation Now these stages happen at different times (a few days apart). I want to be able to track the progress of each order from a client ie. when I enter a Job ID, I want to be able to
URL link for uploaded file is not accessible to general public
Hi Team I have a business where I upload a report for a client to my system, which then sends the report, in an email to the client. This is shown in the email as a URL link. The problem is the the client is presented with a Zoho Login page when he clicks on the link. Is there any way to remove security restrictions on uploaded file links at all so that my clients can download the report? Or simply attaching the file to the email? Thanks Jason
Help with Scripting
Hello, I am new to this type of workflow so I hope someone can help. I have a form that has 5 categories each with drop-down menus. Cat 1 has 3 variables, Cat 2 has 3 variables, Cat 3 has 26 variables, Cat 4 has 4 variables, and Cat 5 has 2 variables. Depending on what variables are selected for all 5 categories I would like a new form to open upon clicking the Submit button. Simply stated I would need to write a script for the Submit button: If cat1=variable, cat2=variable, cat3=variable, cat4=variable,
Date functions used in report criteria lost on re-edit
I have a number of reports set up using date functions such as 'Added_Time' ... Before ... today.subDay(7) to find records that are over a week old. These can be created OK, and work fine. However, when I go to edit the report criteria again, "today.subDay(7)" is always turned into just "subDay". In order to save the correct criteria, I have to retype "today.subDay(7)" into the text box before save. The same happens for other functions e.g. addDay, subMonth, etc. I've got this on a lots of reports,
Address field type
For mailing addresses, I use: 1 line for the addressee fields for city, state, country and postal code. and: 1 line (optional) for the c/o or company or to the attention of 1 line for the street or PO box My question is about the 2 lines.... I don't like how much room they take up in list view reports, and I'm wondering if I could switch to 1 multi-line field. Any opinions? Advice? Recommendations?
Send One Email for Several Records
Using the scheduler, is it possible to send one email instead of individual emails for records with the same criteria? i.e.: When three records have not been entered by the user yet by the due date, send one email for all those records.
Accidentally deleted a form button
I accidentally deleted the wrong button on a form - and therefore the code behind it. Is there any version history available or any other way to restore it?
Can I MOVE a Form from one application to another?
Hi, I am new to Creator and I ended up creating multiple applications instead of multiple forms within an application. Can I move forms or copy forms between applications? Thanks
Using the Date field
Hi, This is my first time working with Zoho creator (or any service of the kind, for that matter), your assistance will be highly appreciated. Some of my records have an exact date, and some only have a year. I can't seem to be able to use the "date" field, because it doesn't accept those with just a year as a proper date format. I would very much like to use the date to field for better search options, instead of just making it a one-line field (won't take numbers too, because then it says that
fetching records with multiple search criteria
I want to search my all the records in my Crew_DB for a name that I input. Then I want to input the data from a field in that record into the existing form. Can this be done? Example. crew = Crew_DB [(((((((((Crew_Member_1 == input.Employee1 || Crew_Member_2 == input.Employee1) || Crew_Member_3 == input.Employee1) || Crew_Member_4 == input.Employee1) || Crew_Member_5 == input.Employee1) || Crew_Member_6 == input.Employee1) || Crew_Member_7 == input.Employee1) || Crew_Member_8 == input.Employee1)
Send Reminder
Hello, I'm trying to trigger a function in which the program can automatically send an email to remind the user, who input some but not all of the data, that the deadline is approaching.
Archive Subform Data
Hello, I'm trying to archive data from both the parent form and its subform into another section, so that we can look back on old records. As a result, I created a function in which you can click a button on each record to archive it. However, only the fields in the parent form can be archived, NOT in the subform. Any advice? This is what I have so far: void deleteRecord(int ID) { fetch = Part_Information_Input [ID == input.ID]; insert into Archive [ Added_User = zoho.loginuser
href with View worked for me till a few days ago and suddenly stopped.
Hi - Till a few days ago this line worked well for me: htmlString = ((htmlString + "</br>" + "<a href=" + zoho.appuri + "'#view:customerRecordCompleteHtmlView?customerIDParam=" + custIDStringTemp + "' target='calendarIframe'>") + custRecTemp11.Formula2) + "</a>"; I noticed that in particularly any variations of the href-value that includes column " :" makes the url href value to be stripped when in display on the page. I think this seems to be relevant for Form's html fields .. So this is rendered
Pulling Data from Zoho Reports
Hi Guys, Have read a few forum posts and documentation trying to determine how to pull data into a Creator Form from Zoho Reports. I know how to store,update and delete records in Zoho Reports from the form, but am struglling to get it to pull data and populate a dropdown list. What I currently have is a form that is for inputting orders. The field I want to populate is "Supplier". In my database/reports, I have a Suppliers table. I want it to pull in the Suppliers Name for display in the dropdown
One of my forms is taking a very long time to submit....
This form used to save in a very short amount of time. I have made no modifications to the form and now it is taking forever to save a new record. Is there something i am missing? it is actually NOT submitting.
Creating a Relationship Between an App in Creator and CRM
How do I go about creating a relationship between a from created in Creator and Contacts in CRM? I want it so that when I submit a form for a customer, it will be listed under their name under contacts. Thanks
Export Permissions
Hi, When I set the export permissions in some profiles. In my mind, I have disabled the export permissions for one kind of specific employee such as "contractor", Unfortunately , I found the contractor still can see the "export" in the menu and it can work. What is problem? BTW, I both disabled the import and export permissions to contractor. The import disappear but export still be there. Please help... Hero
Using product module information as criteria.
When creating views and selecting criteria, I'm only offered to search through the criteria of the main account information but not the information of my checklist product information (The module is a list of products and a check if they are customers for that type of product). How would I ago about make this information accessible through the criteria functions when making a list. Thanks, Joe Ogoley
Import Data into Subform
Hello, I've already thoroughly researched this topic within the site, including https://help.zoho.com/portal/en/community/topic/importing-data-to-a-subform#2266000002822095, to no avail. Does no one have a simple solution to this problem yet? I cannot import data into my subform, only my main form. Note: The fields that are receiving the data in my subform are lookup fields
how to set popup window size
Hi, Can anyone tell me how can I set a popup window size? I tried to follow an example in the forum where they put the size in the parameter field: "height=500px, width=500px" but it does not work. Cheers
Novice & Need Assistance
anyone available to help me, i know exactly what i want my app to do but having trouble putting all together. nayaalacy@gmail.com; 9519992539
Type Required "Int", Type Found "Long" error
I am calling a function from within a function. They function that I am calling needs to receive and Integer, however when I I try to send an Integer (specifically an ID from a related drop-down) I get the attached Error expression type does not match: type required:int type found:long
Auto fill changed fields
Hi Lets say I have 1000 records I add a field 'Week of year' I have a field called Visit_date which has an on user input Script that reads ' Week_of_year = Visit_date.getWeekOfYear()' Script works fine My problem is how do I populate the 'Week of year field' without going into every record and activating the script in the field by changing the date. Thanks
Twilio configuration
Hi, I am just in the middle of designing a Zoho Creator app and note that you integrate with Twilio. Please could you enlighten me on the following: 1. How to specify the sender name? 2. How to configure Creator/Twilio so that replies can be sent to an email address? Thanks Shaheed
Zoho Creator Respose
I am using your Zoho creator form in my site. First I trying to test using API in my system. But problem is that in response i got download XML or JSON files from browser. Database entry is done successfully , but I need response in my site from which i can update different status in my system. don't want to download any file in Response. Can you please give me proper guide line for that.? I am using below code for add and submit form. ------------------------------------------------------------------------------------------------------------------
How do I grant admin rights to another Zoho Creator user?
How can I grant admin rights to another user of our zoho creator? There are two of us who use are currently using it, I am able to edit any of our applications while the other can not. The application is shared with the other user, and they can access it and enter data but they are unable to edit the app. We are currently using the free version of Zoho Creator. Do we need to upgrade, or is there a step I have missed? Thanks!
android
Is there a form of ZOHO Creator for Android ? If so, where may I find a download ?
interaction subform fields
Good afternoon, how to get the index of a row in a subform. is possible in a subform add a field having the conditional in another field. For example: row1 = field1 = 1.1; field2 = computer; field3 = 1000 row2 = field1 = 1.1; field2 = notebook; field3 = 1700 row3 = field1 = 1.2; field2 = brick; field3 = 50 to sum the values in the subform field3 if field1 = "1.1" another query could delete a row subform via script thank you
HTML View transfer inputted data between forms
I am working on an application in which I need to allow users to type in a passcode that is unique to specific groups to add or edit a record in a form, that passcode would be recorded in each record to show which group the person belongs to. I want the user to be able to type the passcode once and be able to add or edit multiple records, without typing the code multiple times. My idea was to create an HTML page with the embedded report and an embedded login form. Would it be possible to pass the
How can I add a table into a form?
Is it possible to add rows and columns into a form that looks like a table where people can enter text and numbers?
Forms have disappeared from Android app....
So...all of a sudden all my forms that have subforms have disappeared from the list on the Android app. They are still there on the mobile web browser. Anyone know what happened? Thanks
Popup Window v New Window on user input actions
I have an app whereas I created a function to add record that autofills a related form field and then script in that form (on user input) fetches the information and autofills additional fields. I set up the function to open as a popup window. This works to initiate the "on user input" actions when the lookup fields is autofilled via the function. I get an additional popup window that is blank when I submit the form. I then changed the function to open the new form in a new window, however,
Form - Failing to Publish
I just wanted to inform everyone that if you try to publish a form with a font size that is not a whole number (such as 11.5, 12.5, etc.) it will not work. For some reason Zoho developers did not add an alert that tells you why the form failed to publish. Anyways, as long as everything else is okay, it should publish if you use whole number for font sizes (such as 11, 12, etc.).
Next Page