Cycle 2: Time-only Input Field
Suggestion: Time-only Input Field Purpose: Allow a user to input a time (similar to the date-only input field), but just for time. Motivation: I simply do not like in current implementation of the date-time input filed. We have date-only, why not time also? It's in military time, and most western nations are more familiar to AM/PM notation I don't need seconds, or at least I'd like to have to option not to display seconds In some cases (browsers) the java app does not appear and manual entry is cumbersome
Automatically updating my opportunities everyday
I need to have a schedule or something which will either update my opportunities everyday so when i run a report it will calculate the correct age. Even better would be a way to have the crm update the opportunities every time i run a specific report
Creator Issue with App Since New App Uppgrade
Has anyone else experienced a issue with the Creator Mobile App since the App upgrade? It seems to get "stuck" if you have a process that needs to take place before moving on to the next field. IE. Capitalization to "Allup" letters, a math calculation or a lookup. This has become very UNPRODUCTIVE in the field. We get the "waiting spinning" icon. Sometimes its clears after several minutes, most of the time it doesn't. We have to close the app, force stop the app and try again (until it works).
How to add attachments/uploads to a different record?
We created a multi-page application that updates records in a 'master' record. Each form collects different information and adds it to the master record by passing an ID between the forms. One of those forms allows users to upload documents. How can we create a form that allows the user to upload attachments and add those attachments to the 'master' record by ID? Is this possible? Thanks, John
C# REST API File Upload
Hello, I am using C# and WebClient to add/edit/delete records in Creator and it has been working very well. Please see example below. This code adds a record, then I have been trying to upload a file to a file upload field. I am not having any success using WebClient to upload files and have tried a number of combinations based on the Zoho Creator API file upload documentation. If anyone can point me in the right direction here it will be a big help. -Wright var response = Http.Post("https://creator.zoho.com/api/myzohoapps/xml/ncportal/form/Documents/record/add/",
Duplicating records in a report from a custom button and changing the value of the exstg record.
Hi all, I've managed to successfully copy an existing record within a report by using a custom button (code below). I am struggling with changing the revision number of the new record. Currently the code below highlighted in yellow successfully copies the revision number of the existing record, but I would like to change the revision number to the next corresponding letter. e.g. if the existing revision number is 'A' I would like to change the new record revision number to 'B'. Any ideas how I can
I need to make a copy of my application
Hello everyone! I'm new to programming with zoho creator, and I'm going to maintain an app. I've seen the Sandbox option,in order to learn how to fix things without danger, but I push the link "Create SandBox" but nothing happens. there are 3 little circles on the screen, like it was working on it, but we leave it for hours and notthings happens. Can anyone tell me how can I activate the sandbox, or how can I start working on code without touch the application on producction? thaxs!
Subform : Delete subform rows when main row is deleted
Hi, How do I automatically delete subform rows when the row of the main form is deleted ? Many Thanks !
Conditional Dropdowns in Subforms
I created a form where the available values of some of the lookup fields were filtered based on selections made in other lookup fields. The filters work great if I access the form directly. But, the filters don't work at all when the form is used as a subform. Is it possible to filter lookup field values in subform dropdowns based on selections made in other lookup fields in the same row of a subform?
How to autofill a single line with a record from subform based on latest added time?
Hi all, so I have a main form call PO_Update. in the main form, i have a Subform called Update_Detail. Subform Update_Detail has Update_Detail_DateTime, Update_Status, Update_Note. on PO_Update form, I want to show Latest_Status that is a latest record from Update_Status sort by Update_Detail_DateTime. please help me what to do to autofill this Latest_Status automatically? Thank you in advance
How to duplicate a record
Hi All I am wanting to duplicate a record and not sure how to do this. I would like the entire record to be duplicated using old values when the user changes the revision number of the record. For example, if the user opens up an existing record and amends the revision number field from A to B, I would like the entire record to be duplicated using the old field values (revision A) before the amendments where made. During this event I would also like to change the 'superseded' field from the default
Schedule Report to send as excel file
Is it possible to set a schedule for the report to send a excel spreadsheet/ CSV file, at the moment its just a PDF.
Summary Report PopUp Width Setting?
Hi. I am using a summary report in conjunction with a normal list report. When you click on a row in the list, it popup displays the associated summary report (invoice). Is there a way to control the width of the popped up summary report. It seems to fixed at 50% width of screen. Has anyone found a workaround to display larger widths? Thanks in advance.
Sendmail Issues - Other Users Having Issues?
Any other users having sendmail issues frequently? Emails are currently not sending in our application and this has happened multiple times in the past few weeks.
Invalid Characters
Hi, I am trying to enter data in to a form via the report interface. When i try to submit I get invalid character error message but the error message doesn't report which character is the issue. The error message is below and the text from the file is attached. "1 . Failed to update data. ." Please could advise which characters are causing this issue so i can find and replace them and upload. Thanks
header within a report
Hi I use to print each record of a report as a "summary" and I want to insert a header - my name and address - on the top of each printed page. I have been told that this can't be done only creating an html page. I am not so good with html.... I tried to embed the report within a page but it is pasted as it is and can't be edited. How can I append this two rows before the report itself? Thank you!
Refresh the page (with a filtered report) when I click submit.
I created a page which consists of a form and a report (the report of the form). Lets say that I have filtered the report to find some records. When I add a new record and click submit is there any way to refresh the page and shows me the filtered records (which I have found them before the submit)? Without need to search them again. With other words with the refresh to return back to the filtered page view.
Error in CRM task - SearchRecrods
Hi, I am trying to fetch data from CRM to ZOHO Creator on User input of a fields like here "Accounts" using "SearchRecrods" task. It is working fine for when every respective fields have values in CRM response but what I notice that when any of the fields in CRM of any record is blank then I got the below error it seems the response can't handle null value or it doesn't include this field in JSON list even. so script can't iterate the list. I tried to use "ifnull" but not working so. for instance
Populating lookup based on another lookup
Hello, I have a form for new projects. I want to allow the user to select a contractor from a list of contractors to assign to the project. Each contractor also has multiple employees, one of which will be assigned to the project. What I hope to accomplish is a filtered list of contractor employees based on the selection of a contractor in a lookup field. Not sure how best to go about accomplishing this. Any help greatly appreciated. Best, Chris
Normalisation
Have a quite large database (around 500 records), need help with normalisation of the database and designing the Entity relationship diagram. Cannot attach the file as there is some error
Unable to add Alias Address when I config Email
I config email at step 1 Unable to add Alias Address https://phattoroi.top/
How to display line breaks in an html view for multi-line text?
If I put html line break code in the text then that br code shows up for people who view the field within Zoho's non-html views. But multiple lines of text show up as one line in an html view, although they show correctly in other types of views. Is there a simple way to make multi-line text show as multiple lines within an html view, without the html code showing up in other views?
Custom actions
Hi all, Can someone help me with the code for transfering "pendig orders" to "ready to deliver orders" ? With a custom action button "ready", and is it possible for the app to automatically add the date i pressed the "ready" button? Ex: I pressed "ready" today, the app automatically adds the date to a "ready date" field? Thanks all, i really need this!
Conditional dropdown - Set Filter Not working.
I have a lookup field and configured the condition in the set filter. The filtering condition shows in the box after the condition setup is done. I see the Set Filter is unchecked with no condition text if I navigate back to the field again.
Click to call in Form
Hi, I want to be able to click to call from a clients profile. This works from the Reports running off my Forms, but I want to be able to do this from within the Form itself so Data can be updated at the time of the call. However, unlike on the Reports screen, when I click a telephone number in the Form view it does not call the number as desired. Is there a any way to get this to work?
New form: how make visible only the report
Hi all, I'm creating my application with Zoho Creator. Every time I add a new form, I see in the section specified both the form and its report. What I want to is seeing only the report and adding new record with the usual "Add" button. Can someone help me? Thank you!
Subform Totaling of Invoice
I'm not the most skilled at coding, but I think something is wrong. I have created an order form that is similar to other templates I have seen online. I am having an issue getting Total amount of all the item subtotals entered into a subform. When I select the item, the subtotal of the item is populating, but the addition procedure to get the total is failing. I had this working before. I created a new application just to test this issue and make sure none of my other code was interfering. I
Calendar custom record summary does not show in HTML page
I have a calendar report embedded in an HTML page. I created a custom record summary, and it does not show. This is only for calendar reports embedded in HTML pages. I have tested this problem with list reports and the custom record summary shows.
How to get querystring value in stateless form?
I have written a custom function to show a stateless form. querystring = ""; for each Account in Accountinfo { querystring = (querystring + "accid=" + (Account.ID)) + "&"; } openUrl("#Form:Send_SMS?" + querystring, "Popup window", "height=400,width=400"); The forms opens correctly. But I am not able to access the query string passed in the form. l = input.accid; It throws error accid is undefined. What am I missing:
update a field in subform
HI Does any one knows how could i update a field in a subform ? The system refuses it it s very frustrating have a good week end
Editing subform within a subform
Hi, I've got three forms: - Parent registration form - Child registration form (subform within parent registration form) - and Program registration form (subform within child registration form) I've shown it pictorially below: I'm wondering whether I can get the child registration form to open as a popup dialog so that I can allow users to add program registration data to the child registration subform. Has anyone faced this issue before? Any ideas?
URL problem when sent to a gmail account
Hi, I new working with Zoho creator. Not a IT person. Just added 2 forms. When I add a employee in the first one I was able to send a mail to the employee with a URL link to the second form. When I try with my Office365 mail, it works just fine. When I try with my gmail adress, it's not working. Any ideas? Thanks Marie-Andrée
Prevent duplicate month/year form
The forms in my application are set up to record financial indicators by month and year. Currently I have a simple drop down box to select the month and a single line field to manually enter the year. The problem is that the month and year can easily be duplicated with a separate entry. How would I make the month and year fields exclusive so the same month and year combination can not be duplicated? Also, I assume a Look Up field would be needed to modify the data for a particular month.
Changing a dropdown list's content with a variable.
Thanks in advance for any help! Here is what I'm working with: Form A (created from a spreadsheet): Has 3 columns labelled: Fruit, Vegetable, Grain Each column has several related entries. Form B Contains: Dropdown List 1: Which displays the choices Fruit, Vegetables, Grain. Dropdown List 2: I would like this dropdown list to display choices from the appropriate column in Form A, depending on which which choice was selected in Dropdown List 1. I'm new to Zoho Creator so I know there's a way of
Embedding Report under Pages
Hi all, I am very new to Zoho Creator. I have created a page with six reports however they are all below each other, and for visual purposes, I would like to have them in two rows of three. Is this possible and if so, how? Any help would be greatly appreciated. David
Merging Unique ID to mail document
Here is the situation: I have a lot of members and I will ask them to update their records: name telephone etc. I can export all data to a spreadsheet. I want to merge the unique ID so they individually can correct the data. When I try to merge in MS Word I simply get the message: cannot open website. Here is an example of a URL I want a member to access: https://app.zohocreator.com/fluiddanmark/favrskovgym60plus/#Form:Kontakter?recLinkID=3069380000000373191&viewLinkName=Medlemmer What would be easy
Sendmail record template of another form
I'm aware this works in deluge sendmail ( To : email From : zoho.adminuserid Subject : input.Subject_field Message : input.Message Attachments : template:Invoice as PDF, file:input.Date_of_Event.Planning_Form )I would like to know if I can attach a record summary template from another form in this script. I am already attaching an uploaded file from another form with file:input.Date_of_Event.Planning_Form I have tried Attachments
iframe size dynamically?
Hello. I already see on the forum many similar questions but may be u fixed that. I would like to have the form's height change dynamically, as the content within the frame's height changes without scrolling iframe. Thanks!
Sharing my application with other users
Hi Zoho, I've created an application and would like to share it. I have added the user in Settings -> Share -> Shared details, but when he tries to enter the app he gets the following error message: "This application is not accessible. Sorry USERNAME, you are not allowed to access APPNAME. Please contact this application's administrator." When I try to invite the user through Settings -> Share -> Invite, both "Select Users" and "Select Groups" windows are stuck at "Loading", so I can never pick
Subform Display Issue Main Form
Currently my SubForm (in the MainForm) on ALL forms has this odd gap under the SubForm title. Any suggestions on how to fix this or what could be causing it?
Next Page