ZC and ZS integration issue
res = zoho.support.create("Requests", "test", "test", { "Name" : input.Name, "Contact Name" : input.Name, "Subject" : input.Request_Category }); Trying something like above, but got this error {"message":"Invalid Ticket Id","code":"1000"}
Problem with the function for each
I have this code and I need you "for each i in input.R" run Only with Certain records, but when i keep the record is saved as "R" is not input. Then when i select That box Belonging to a subform, I changed all the fields INSTEAD OF only of the subform Those That are inside. (Including the data That Already Been HAD registered Earlier) I have the same code and another field and in this if the input is saved. I do not get it. if (input.Clientes1 != null) { if (input.Correo_Electronico != null)
Record Summary Public
Is there anyway to make a record summary viewable to the public. I have a report on my website showing available inventory with a custom action to show more info by opening the record summary in a pop up. However, it just redirects my visitors to login to zoho and says they do not have permission to view it.
showing the rent amount as weekly or monthly option
I am trying to create a tenant reference form and in the form i need user to enter the rent amount as a weekly or monthly option. After user input the amount in rent amount field, i would like to achieve that user can specify the rent amount as weekly or monthly How do i achieve thanks in advance
field rule for if a field is empty or not
I'm setting up a DB for keeping track of product photos. One of the fields is "Date received", meaning the date we received a photograph back from the photographer. I have another field which is to be a "Do we have the photo, Y/N". This field will be used on another related DB so we can see if a photograph exists for a product or not. I'd like to set the "Do we have the photo" field with a rule that says "If Date received is NOT blank", then set this field to Yes. Is there a way to do something like
Deleting Records before import
When importing data from a CSV/Excel file inside of a Report (using the little gear icon), is it possible to write a script that removes all records from the database prior to importing? Each time we import data this way, we want to completely empty the existing data set automatically and replace it with the data we're importing. Any help would be greatly appreciated! Thanks
Lookup
Can a Look Up field view more than one field? For example, if a Look Up field is to select a Device Code field from the Devices table . But the Code field is meaningless. I would like to view multiple fields from the Device list, say a friendly "Name" field and perhaps a "Room" field when we select a device, we want to store only the Code field in the Look Up field. Hopefully that makes sense?
Functions does not work at Linked View from another Application PLEASE HELP!
Dear All Please help me About this issue. This is first view from Orginal APP lets say App name APP A Here all Functions work as you see "Sevkiyat Planla" "Boyahane Planla" ------------------------------------------------------------------------- This is lets Say APP B and here you can see Talepleri is Linked to APP A (lookup). After Click This as expected view from APP A opens. ----------------------------------------------------------------------- We are still in APP B here and we have view from
12 Hour Time: Simple Solution
EDIT 07-FEB-2012: I made a free marketplace app for you all to test https://creator.zoho.com/public/showAppInfo?canvasurl=kqpjzaljg There are a number of posts here about TIME in ZOHO Creator. Many have requested ZOHO supporting a 12 hour format. With some help from Gave a while back, I have been using a rather long function to verify if a user typed in proper 12 hour format (i.e. 12:15 am or 05:00 pm but NOT 1:15 or 07:00 PM). I found a better way to do this that only uses a few lines of code.
Changing the Date-Time format
How do I change the format of a Date-Time field? I don't want it to be 13:00:00 -- instead, I want it to show 1:00 PM. Also, is there a way that I can have the date also show the day -- so ideally it would read: Mon Nov 3 2008 1:00 PM Thanks. Ellen kidspace
Rich text editor for mobile phones
Hi Zoho, Just wondering whether rich text data input/editing capability for mobile phones is on the road map any time soon? Thanks,
Show user filter criteria of pivot chart on pdf export
How can the 'User filter criteria' of a pivot chart be shown on a pdf export? Ideally, I'd like the criteria to be the subtitle of the report. I have many assessments that users can create themselves. They see a chart of the results by choosing the assessment name from the User filter criteria on a pivot chart. Thanks!
How do I save column order and visible columns for the drill down of a pivot chart?
After clicking on a data point in a pivot chart, I can see the underlying data. By clicking on a button on the upper right of the grid, I can hide a reorder columns. How do I save this layout so users don't get confused with extra columns? When designing the pivot chart, if I click on a data point, the x and y access labels are helpfully summarized at top. How do I get the same thing in live mode? This way, those columns don't need to be shown since the values are the same for every record related
API HELP
I am trying to intragrate a creator form with Hello Sign so i can capture the signature. I have a sample POST request that they proviuded. I just dont know how to apply it to zoho... Can someone help me out please this is kiling me Example request / response POST https://[username]:[password]@api.hellosign.com/v3/signature_request/send_with_reusable_form reusable_form_id=c26b8a16784a872da37ea946b9ddec7c1e11dff6 subject=Purchase Order message=Glad we could come to an agreement. signers[Client][name]=George
Fetch record Issue
Having trouble fetching a record. In Short: I have Form 1 - Material Type Field - Material_Type Field - Material_Type_Code Form 2 - Material 0.2 Field - Material_Type - (Look up to form 1) In-Line Sub Form - Material in in-Line Sub Form - Material out Field - Available - Calc of ((Material in*n) - (Material out*n)) Form 3 - Order Tickets Field - Material_Type (Look up to Form 1) Field - Available - (Material available from form 2) some
Auto populate field from other form
How do I populate mileage_log_mileage in mileage_log using a value from sites_distance_from_office from sites table IF value off mileage_log_purpose_of_journey (drop down box) in mileage_log table equals "Office <> Site"
Time Zones
Is there a way of adding a Summer Time option to the Timezone settings?
Zoho Creator view: define security around view
I'd like to restrict edit-rights for a certain view. A view/report could have 20 fields, but I want the user to edit only 5 fields. I know this can be configured at the Form level, but I need to control each report/view individually. Can you guys add this feature? Thanks!
Change dropdown options based on day of week?
I am making a member sign-in app with a field for class check in. I would like to change the available fields based on the day of the week. Has someone already solved this problem? I have created a class schedule form with class names in rows, and decisions boxes for each day of the week. I would like be able to list class names in a dropdown on the sign-in form where day offered = true on the class schedule form, with the column reference changing based on the present day of the week. Is this
Fetch Data
Absolute beginner but I've spent hours trying to get Fetch Records when selecting a field in Form B. I simply want other fields in Form B to be populated based on selection of data in Form A. The example in the Zoho help is clear but doesn't seem to work when I transpose the fields to mine. Form A so far is a basic Product List (Manufacturer, Model Number, Warranty). Form B are Devices we actually have installed (so potentialy multiple Products of the same type), so want the Form B to reduce double
Prompt for parameter for a header-level custom action?
I've got a header-level custom action that works on all the selected records in the view. Is there any way to prompt once for a parameter that should be used for all the selected records? From what I've read in the forum, it sounds like I could use a pop-up stateless form for the input parameter but it would appear for each selected record. Thanks. - Craig
Data Entry from Different Sources. Conceptual Layout.
Hi, I've been playing with Zoho Creator for several days now, trying to figure out if its the right tool to help me set up an online database. I can't seem to get a handle on how I should lay the data out in the application, so I was hoping someone might help me with the correct data structure concept. The problem is that the data was previously stored in three or four separate spreadsheets, which need to be linked together. If this was a traditional database, we'd add foreign keys to the subsidiary
Duplicate record - problem with relations
I cannot use the duplicate function because duplicate records are 100% identical (except ID) -> other app users cannot see difference between old and new record. This is problem with some forms that have lookup/relations. The relation records are attached to the old/original record (as it should be), but users might mix up new and old record. Solution: A duplicate record should have added some text in key text field (e.g. ....Copy or ..... 2)
Set a rule
If I have two date-time fields in a table say mileage_log_start and mileage_log_finish. How do I ensure the entry in the finish is greater than the start field?
Wordpress User ingeration
Is it possible to integrate Zoho Creator into wordpress and manage the users access their rather than having to purchase the user portal in zoho.
Image issues
New to Zoho , but I am having difficulty using the Image fields. I can not get a report to show images at any other size than small, I have applied different sizes to the form, different sizes to the report, made sure they were the same. What I really want to do is use the record summary option to customize the layout and size of my images on the report but they don't even render when I go this route. Am I missing something simple somewhere in my configuration
Add CRM Event from Creator Form
I am trying to add an event in my CRM calendar based on the field Bid_Due from my Creator form. The creator form is not relative to any account or lead in our CRM nor does it need to be. Maybe this is an issue? So On Add -> On Success I drag and drop CALL FUNCTION from deluge tasks and select CRM integration and Create Record. Module Name is "Events" and I have mapped the field like so. crm_Resp = zoho.crm.create("Events", { "Subject" : input.Title, "Start DateTime" : input.Bid_Due, "End DateTime"
Video From Cellphone
The functionality to add a photo from a cellphone is really great, but can this be tweaked to include a video too? Thanks
BIG PROBLEM: Can't access my own Zoho Creator projects
Hi Zoho Support/Community, I'm testing out the free version of Creator which should allow up to 3 users. I've been working a lot in the last few days to finish a new application, and finally yesterday night I've done the first usable version. So, I was began to test the access the users access possibilities (3 at maximum at free version), and I've introduced a gmail address from a personal account. But I've found that gmail address is linked with my main zoho email (as secondary email), and now I
Pushing information into lookup via custom action
I have a form called Account in which we're tracking Accounts we do business with. I also have a form called Order in which we create orders. The Account and Order forms are linked via a lookup on the Order form that links to the Account name. On the Account report I have a custom action that will create a new order, the action does the following - void Order.Create() { openUrl("#Form:Order", "Same window"); } I was wondering if I can then populate the Account lookup field on the Order form
Subform images in report only showing first two images
I have a main form with a sub form which is used to attach images to the main form. I am try to create a report showing the details of the main form and then display all the images from the sub form. I can get everything to work as it should for the first two images but after those the third is displayed as an image icon and not the image itself. AM I missing something that is limiting the number of images displayed?
is the parameter of pageSize available in rest api view record ？
hi zoho ： is the parameter of pageSize available in rest api view record ？
Deluge statement execution limit exceeded the maximum limit.
Hi I have a schedule performing a daily routine using a "FOR" and I get this error in the schedule log: Error Executing the workflow Vencimiento Cotizaciones script(Custom Schedule). The number of deluge statement execution limit exceeded the maximum limit. Why is that? I need a solution or turnaround to accomplish the routine Thanks!
Security: Customer Portal & Users & Permissions in Creator
Hi, I'm confused about the Customer Portal & Creators Users's and permissions links. I have the "new" account setup So under Application Settings i have links to the following: Users & Permissions: Which has Users, Roles, Profiles and Field Permissions Customer Portal: which also has has Users and Profiles etc So when a customer registers for access i can see him in the Customer Portal and he gets assigned a profile from the Customer Portal. So what is the purpose of the Users/Roles/Profiles under
How can I set date to date-day?
How can I set the date format as: 'Apr 05, 2016, Tuesday' ?
Embed view without html head and body
Hi -- Is it possible to embed only the content div (id="zc-component") of a view without html head and body?
Best approach to convert numbers to text in a pivot chart; if(minimum(field) == 0, 'No', 'Yes')?
I would like to show what a number means instead of the number itself. I have a survey with groups of questions. If all questions are answered 'Yes', then the answer for that group is 'Yes', otherwise the answer for that group is 'No'. Right now, each item has a score (No == 0, Yes == 1). I am taking the minimum of the score and placing that in the Color field in the pivot chart. The data is properly plotted on the chart, but the legend on the chart shows '0 and below' and 'above 0'. I would like
is there .notContains function?
hi try to check for variable - is it contain value when save script - system write that there is no such function why?
Deleting subform data with "Delete Record" task...
Hi All! I have used the "delete record" task many times by now and everything seems to be working fine. But I have encountered a problem on this spot: When this form is successfully submitted with an ID, I need to delete the record with that ID from a specific form. So far so good. But this form has subforms, so I need to manually delete their records too. I have tried the following: if (input.Form_Name == "Insurance01") { delete from Insurance_Sub[ ID == input.Rec_ID ]; Project_Name_Here
OpenURL during OnDelete -> OnSuccess being ignored
I have the following code in the On Success section of the On Delete action in a form: openUrl("#View:AQ_Report?ParentID=3007035000000362036", "same window"); It doesn't work there but the same code in the On Success section of On Add does work. Is there some way I can open a report after a record is deleted? My use case is that when the last record that matches a particular filter is deleted, I'd like to take users to the same report with a different filter. Thanks!
Next Page