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?
Bug with embed report in HTML page
I embedded a report in an HTML page and the height sometimes doesn't show all the records. This problem only happens when I open the app for the first time and click on the page link, or if I refresh my window, and click on the page link. The report shows all of the records when I click on the link for the 2nd time. But I wanted to try something. Below is a picture of two reports that contain the same exact script. These 2 reports contain the EXACT same script, but one shows all of the records,
Dyanmic Subform
Hi, I have created travel form for Employee travel management. I want to create conditional form. Condition is here. employee may have either international travel or domestic travel. employee may have international travel as well as domestic travel. First, Employee will fill the international travel form. if he needs domestic ticket he can apply for it. Here i want conditional form. if employee says " YES" he needs domestic ticket then this form will appear down side to the international Form, If
Time Field
Hi, I want to manipulate a time field without displaying the date but there seems to be no time field available, just a time date field. Is there a way to hide the drop down calendar in a date-time field and just make it display time? Why isn't there a time field?
Create a report with calculated column and filter by calculated column.
I have a invoice form with invoice date, duedate. I need to generate a overdue invoices report where duedate is past current date. Also, I need to show the number of days between duedate and current date.
How to call a field name from another form ?
I have two forms in my application . I want to get value/data form one form to another one . How can i can get value/data form one form to another one and How to call a field name from another form ?
Filter a Report based on a date
Hi, I am building a club membership app. Each member has an expiry date. I would like to generate a report that displays a list of anyone expiring within, say, 45 days. On a the report, I am trying to use a Criteria condition. Expiry Date >> Before >> (now + 45 days) How do I code the "now/today + 45 days"? Best regards,
Restricting View For Calendar
Hello, I have created a calendar report that is based upon a CUSTOMER form that contains information such as... Assessment Date Assessment Time Support 1 (dropdown reserved for ADMIN to assign the call center to call customer to confirm appointment) Support 2 (dropdown reserved for ADMIN to assign the call center to call customer to confirm appointment) Rep 1 (once confirmed, ADMIN then assigns the lead to a representative) Rep 2 (once confirmed, ADMIN then assigns the lead to a second representative
Column Creation
I've searched all over and cannot find where I created a multi column view. I created this view and cannot find where to edit it, it changed the behavior of the fields on entry and I would like to delete it. Sorry for the vague reference, I'm new to the product and not quite familiar. Thanks!
Open url after deleting a record
How to OpenURL after deleting a record? I put the script in On Delete -> On successs and also on Delete -> Validate but its still not working
Search field in the dropdown
Hi, It looks like there is no search field in the new android version of the zoho creator app. How can I fix this? Regards, Gianfranco m
"You are not authorized to view this record"
This has never happened before. I am the one who is creating the application. How can I take this off? Any linked record within this specific record summary gets this error. If i work my way around the application, I can view the linked records, but if I try to view them via record summary from another linked record, I get this.
Auto populate fields in same form
On User Input I would like Curr_Version_Name and Curr_Notes to auto populate into a field (while remaining in their current fields) called Notes_History and to add a date/time stamp + a single line space In that same form I would like any changes On Update of the Curr_Version_Name and Curr_Notes to add an entry below the last one in Notes_History Been stuck on this one for a while. Would appreciate some help. Thanks, guys.
Lookup field question.... using the If statement to refer to the user input
Hi I have a lookup field named 'country' in a form which is looking up country names in another form. I am trying to write the code below to say something like "if the country = Singapore then make the 'project sell cost' field visible, which is currently hidden. My dilemma is how do I refer to the actual country name? Currently I am using the code below which is using the ID of the country. What am I doing wrong? Regards Martin
displaying a Signature field on another form
Is there a way to display the contents of the new signature field on a different form? With an image field I can display the contents in a note field on the second form. But I have been unable to get the signature to format and show. Thanks for your help. Herb
Cannot adjust width of custom action column in report
I have already managed to adjust the width of columns that aren't custom actions. But when I try to adjust the width of a custom action and then click "save changes" it goes back to how it was. I also tried adjusting the width via report definition but this also does not work. This is what I want This is what I keep getting even after I click "save changes"
crm create quote - why are price not calculated automatic?
The quote and product price are not automaticly calculated when adding a quote and product with deluge scripting. Screenshot in Swedish language: If unit price and quantity is given, it should calculate the product total, right? If I edit the offer, the product total is automaticly calculated and added as soon as I enter edit mode. The total amout isn't either calculated automaticly. If I am in edit mode and edit tax, then the total amount is calculated. If I manually create a quote with the very
Upload to Google Drive
Hi Zoho, I know its been discussed before but I could not find a solution: I have a form that is uploading files to the Zoho system, I need to store that file on the Google Drive as well, automatically. Can I use Google Drive API in a postURL script in order to add the file? or can I send the file as an attachment to email? Thanks a lot Ravid
Linked record does not view in HTML
I have an HTML page that has text and is hyperlinked to a report. When I click on the hyperlink and the report pops up, I try to click on a linked record in the record summary but nothing happens. The report simply closes. What's going on? Below is a picture of the report that pops up. (this happens with any report, by the way). When I click on Event Date, the report closes. Also, it closes if I simply click on the record to view it.
days360 function return incorect result for March month
I try to use the days360 function to get the number of days between the first day and last day of March and it returns incorrect result: 29 instead of 30. For all other months with 31 days the days360 function will return correct result: 30 between the first day and last day of the month, only for March is shows 29. The strange thing is that until year 2007 it will show correct information: 30 days between 1st of March and 31th of March but starting with year 2007 it will show 29 days between the
Triggering a Zoho Creator Function from a Custom Button
Can I create a custom button, placed in another application, such as Zoho Inventory or CRM to trigger the execution of a function defined in Zoho Creator? John Legg Owner: The Debug Store
Zoho Creator Access to other Zoho Applications
Hi I want to be able to use Creator to read and write to data used in other Zoho Applications, such as Zoho Inventory and Zoho Books. Can someone please direct me to information that will assist me do this? I assume that it will be necessary to access each application's API. Many thanks John Legg Owner: The Debug Store
Limit data displayed in field in report
Hi - I have a report with a comments field that sometimes gets quite lengthy. I don't want to limit the input on that field, but when I display it in a report, that field can make the row for the record take up most of the page. Is there anyway to truncate the amount of information displayed for a given field in a report? Basically want to keep my reports crisp looking without limiting the underlying data in the form. Thanks.
Can I use a custom action to open a form and populate a lookup field?
I'm using a report with a custom action, trying to open up a form and populate a lookup field with a project code but having issues. My custom action function is as follows: void display.BookAppt(int id, Add_Project proj) { openUrl("#Form:Book_Appointment?Project=" + proj.Project_Code, "same window"); } On the Book_Appointment form, I have a lookup field called "Project" and I'm trying to pass the "Project Code" value from the Add_Project form, but it isn't working. if I change the function to
Transfer data from dropdown to a new form on submit
Hello, On submit I transfer data to another form which is working. However when I transfer data from a dropdown it reveals the ID of the dropdown and not the text. How do I code to transfer data from a dropdown into a dropdown on another form on submit? insert into Paraplanning [ Added_User = zoho.loginuser Case_Details = input.Brief_Details_of_Advice_Given Case_Status = "New Submission" Client_Full_Name = input.Client_Name_to_be_Used_within_the_report Date_Received = input.Date_Submitted
Basic Subform Behavior
I'm scratching my head trying to figure out the basic subform behavior. What I expecting was the subform (based on a form linked to parent) would act similarly as a list report. Where you could click on the row and the actual form would popup with all the fields available for editing the subform information. However, what it does is all editing of only "shown" fields in the row of the subform, With no way to get to the actual form, that I've found. I building a contact list. Parent form is Customer
Zoho Creator Basic (25000 records) vs Standard (1000 records)
Hi, I have a Standard subscription that offers only 1000 records per user and 10 apps. Is it possible to move to Basic subscription that offers 25000 records and 3 apps? What other differences are between these two plans? Best regards, Juan
Embedding images in record summary
Hi, I am having trouble trying to design the template for record summary. For each event_report record that I have, there is a list of customers for this event, and a list of images that has been uploaded for the event. When I try to design the record summary template, I could find this field for event images (Around 6 to 8) with its related description. After this is added in the template, instead of displaying as [Description1][Image1] [Description2][Image2] [Description3][Image3] [Description4][Image4]
API Response Javascript Function
Hi, the problem is that a creator api call return a variable or javascript function and no valid json response. Can you please add a valid json response. Thank You, Daniel
Next Page