HTML in a formula field being displayed in a view as text
Hello, I have been using HTML in formula fields for some time and no problem at all. Today I was developing an application where the HTML code in the field resulted in plain text shown in the view. Is there anything I am missing? I am talking about a code of this sort: (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_View?MOB_idstr=") + MOBID) + "\">View Details</a>" below you can see what I am talking about, the field Titulo is a formula
HTML Page - iterate rows for each record
Hi everyone, I logged a call with support a few days ago, but have had no response and need to get a report finished for tomorrow, so am struggling. Herb has been fantastic assisting me with resolving some other issues but I hope someone on here might be able to help on this point. I have a database of student data. I have created an html page to display the data held on 15 tables, all of which are linked to the student personal information through a FullName lookup. Some of the tables contain multiple
Create HTML+Deluge Script button in a Formula field???
A Zoho Creator developer recommended that I add a Formula field to my form that contains the following HTML+Deluge script in order to create a 'View Details' button. (("<a style='white-space:nowrap;background:#3A5999;border:1px solid #4165C5;color:#ffffff' href=\"#View:Detailed_View?MOB_idstr=") + MOBID) + "\">View Details</a>"What the code produces is seen below. Since this is put in a formula field it is displayed on any of the views in which I choose to view this field. The Deluge script pulls
Return the last two digits of the current year. For example return "14" in 2014
I wish to have it returned as a string value that i can concatenate into a file name. I guess that it is an index value truncation but I cannot remember.....
custom action html view
Can I build a custom action button and open in a pop up an html view? When I try this i get a popup that just says "loading view" and after awhile it closes but the html view never actually opens or shows. Is this a bug? I found another post from years ago talking about this problem. Has this still not been fixed? Please help I would prefer not to screw around on this for hours if its just plan old broken. My custom action forumla button has the following code: "<a class='zc-formbutton' href=#View:RFQ_Send_Production_Order?zc_LoadIn=dialog&Request_ID="
Refresh the Captcha
Is there any way that a user can refresh the Captcha? I have a couple of forms that require the user to correctly fill in the captcha before submitting data. During testing, I've on occasion had to either guess 4-5 times, substituting 0 for O, I for l, Z for 2 (you know what I mean), and have a few times had to resort to resetting the entire form and adding all the information in a second time, hoping the new captcha will be more obvious. Am I missing the tool that ZOHO provides to accomplish this?
Error inserting value to linked field
Hello, I have a stateless form that is uses "insert into" command to populate two tables, "Contacts" and "Contact_History" in the "On Click" script of the "Submit" button. First I insert data into the "Contacts" table. The "Contacts" table automatically adds a 'Contact_ID' value via an auto-numbering field. Next I fetch that Contact_ID value (assigned to 'r') and use it to add linked data into the "Contact_History" table, attempting to populate the 'Contact_ID' field which is a look-up to the Contacts
input. removed from formula fields
I have a custom action in a formula field using the following code: "<a class='zc-formbutton' href='#Form:Approve?zc_LoadIn=dialog &Vendor_ID=" + Vendor_ID + "&Request_ID=" + Request_ID + "&RFQ_Response=" + input.RFQ_Response + "' >Select as Winner</a>" Immediately after saving this code the input value of RFQ_Response is working and the form that opens up has the proper value in the RFQ_Response field. Trouble is, if i edit the button or save the form later the code on the custom action seems to
When creating a form is their a way to duplicate fields?
I am building a Materials Tracking application which has both shipping and receiving forms. On those forms we have 24 pallet and weight fields. Each Pallet field would be a drop-down to select the type of commodity being shipped or received. I would like to add them without having to manually input all options for each field. Also, as an add on question, is there a way to show the next pallet and weight fields only if the previous have been filled out? Thanks, Chris
You have reached maximum number of rows. You can not add further
When I try to use a subform and add an entry I am getting the following pop up message that prevents me from adding new items in any of my sub forms across all creator applications: "You have reached maximum number of rows. You can not add further" Seems pretty self explanatory except we are no where near our record limit so this doesn't make sense. Is there a way to increase the number of rows allowed? Clearly either i do not understand what this message means or there is something wrong with
Update formula field with schedule
Is there any way to update a formula field that calculates the number of days between the current date and a future date using a daily schedule? I know you can't get a formula field to automatically recalculate (totally ridiculous but let's ignore that now). Is there a way to use schedules to update the formula field or another field that contains a number? I'm thinking pass the difference between the current date and a future date to a numeric field. Then on a daily basis use a schedule to subtract
Anyone else having issues posting a requirement on Marketplace?
I have reached the limit of my capabilities and was looking to post a requirement for developer assistance having a new html page populated with fields from my database, but every time I attempt to post, I just get a posting error. Anyone else having trouble with this?
Setting criteria for execute script with .getDayOfWeek()
Good Morning, I'd like to create criteria for execute a schedule. My intention is to have an alert with differencial text based on the days missing for the event and also according to the day of week in which the event will be occured. The first step is done, how you can see from the image. I used DATE.FIELD= zoho.currentdate.addDay(2), in this way the mail will be sent when missing two days, but I had problem with second criteria. When I try to differentiate the days of week to have a different
Linking a subform after data import
Hi, Im trying to import my data and structure from an access database into Creator. While the import works, after I have edited the forms i want to add subforms based on their relationship. I can set this up but there is no way I can see that links the 2 records. Please can you show me how to link a subform to its parent after data import? Thanks Amy
Currency field not formatted in HTML View
I don't know if this is a bug or expected. A currency field that is appropriately formatted for a normal view, is not formatted when using the <%=field%> tag in an HTML View. I am having to hard code format it. Please advise if this behavior is expected (and why)...or is it a bug? Thanks! Robert P.S. By formatted, I mean it is not rounded to two decimals, there is no currency sign, and there is no comma insertion.
Double floating header in custom action button glitch
I have a custom action button that seems to have a strange glitch attached to it. The custom action button opens up a view and the header seems to be duplicated. I cant get rid of it with out navigating to another page and back again. This is very frustrating. What is going on and why is this happening. Someone started to look into this but I have not got any response yet and its been a while. THis happens in the following view: https://creator.zoho.com/precisionsailloft/prod/#View:Sent_for_RFQ
Switch Display Type for embedded view
Is there a way to display the cogwheel to change the display type when a view is embedded in a website? When the view is seen in the Zoho Application the cogwheel gives choices for View As List, Summary, Grid, Spreadsheet. When embedded this option is gone.
Creator not getting CRM data using Zoho CRM field
I am new to Zoho Creator and have searched the help, support, this forum, and the web for a solution. I am having a problem getting the Zoho CRM field to work. I upgraded my CRM account to Enterprise to get the Creator integration and am paying for the Standard version of Creator to get CRM sync. (I'm still not sure if I needed to upgrade from CRM Proffessional to Enterprise to get Creator to pull data from CRM. But, because I'm having this issue, I upgraded to see if it would solve the problem.)
Possible bug
Hi All, Apologies if someone else has spotted this but when duplicating a form by copying the With Action definition from the original and pasting it into the new form, if the word "unique" is in the script, an "null" error message will be shown. If you remove the existence of the word "unique" from the xml, the script will then save correctly. Perversely, once the script has been saved, you can put the "unique" word back and the script will still save ok.
Connect applications in the sections of a main application
My company needs a huge application with a combination of subapplications. So I would like your opinions for the structure of the application. Let's say that I have a main application (Extranet) with sections Inventory, Managing, Trading. It's section is a separately application. For example Inventory has forms for hotel details, type of rooms, room prices etc, Managing has another 4-5 forms etc. The same with Trading. My question is how can I connect these 3 subapplications in the main Extranet
And If
Is there a way to perform an "And If" I have work orders being sent to my office when they are completed by the tech. I also want to be able to send some of my customers a copy of the completed order when complete. But not all of them, just certain ones. Example; Work Order If input.Billable = yes then email else If input.Billable = No then email and if Customer = Joe send email to Joe's boss "I only want to send email if the customer is listed"
Create HTML view of records
Hello I would like to know if its possible to create a HTML view which shows a summary of two forms that are related. My situation is as thus: I have two forms Clients and Commissions. In the Clients form I have an agent and client. In the Commissions form I input the commission for each client. [This is the related link]. I would like to know if its possible to have a HTML view which allows me to show the total received by each agent, and I can also choose the month. The HTML view should show all
Cancel button not working when I open record in a new window for editing
I've created a field that displays a link in my view allowing users to open the form in a new window for editing (to avoid the popup/floating window, which creates problems for us in certain situations). The problem is, the "Cancel" button no longer works in this window. "Update" works fine, and the user can close the window to avoid updating, but I'm afraid that if the cancel button doesn't work, they will feel forced to click "update", which could lead to data loss or input errors. Is this a bug
Function tolong()
What's wrong with the following that I keep getting the error message below? temp_list=List(); for each selection in Team_Members { e = Team_Members[ID == selection.tolong()].Email_ID; temp_list.add(e); } Team_Members_Text_List=temp_list.tostring(); Error at line number : 4 Not able to find 'tolong' function
function page error
Hi, When I'm trying to click on define a function in Custom Actions it gives the following error
Android native app for Zoho Creator
Team, What is the latest update on the availability of a Zoho Creator native app for Android & iOS? Thanks
IOS App Suggestions for Offline Front-end Using ZC as Back-end
I need to be able to collect data offline. Does anyone have experience with or a suggested app that is available on the market? I don't want to waste my time with junk as there are many apps out there. Thanks for any suggestions!
Expanding field in zoho creator
I'm working on a project which includes showing created leads from zoho crm into zoho creator form. i.e if there are 2 leads, 2 lead names should be visible on the form . Which field can we use for this purpose in "form builder" to build this application in zoho creator which gets expanded in accordance no. of leads names available to be shown ?
.toLong() not working
I have a user defined function that calls .toLong() built in function I have added it to one line and it works fine. I tried adding it to another line of code but I get the following error. Is anyone else experiencing this issue? How can I overcome it? Not able to find 'toLong' function
Subform picklist problem
I mailed support about his problem a few days ago, but have had no response other than "we will respond soon". So I thought I'd try my luck here. I was running the script below on the On Edit > On Load action of a parent form to populate dynamic picklists on a subform with the data that was saved previously. This has been working fine until a few days ago. When I made a change to a different line in the script totally unrelated to this code I got an error message saying "variable record not defined"
Button on a form to run a script?
I have a series of data input fields, visible calculated fields and fields that show as set variable results. I want the script to run after the user has completed inputting the data and this is of course easy to do as an 'on user input' on the last field. However in many instances the user will see the results and wish to recalculate after modifying one of the input fields. I need something like a RECALCULATE button at the bottom of the page. Any ideas?
Label colour: change background or text?
It would be useful to be able to differentiate fields on a form by colour, either the text or the background. For example I have visible calculated fields and financial summary fields where this would be handy. Any ideas? Right now all that I can think of is running a red line in a notes field.
Make a form field mandatory based on response in another form field
For reference, see my Creator form at http://www.jaxareagolf.org/index.php/meeting-notice%E2%80%8E. In the Attendance Options, if a user chooses "Meeting, lunch, and golf", I want it to be mandatory that the user also put a response in 'Tee choice:' and 'Handicap INDEX'. I am not quite sure how to go about doing that. I would appreciate any help. Barney
Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3
Populate field in form1 with Data from form2 based on a lookup in form1 that looks up from form3 I have 3 forms Patriot_Time_Entry Client_Rate_Table Work_Type I am working in the Patriot Time Entry form When I select a Work TypeLookup that matches a Company Name in the Client Rate Table, I want to populate fields in the Patriot Time Entry Form.
Alternate to subforms
Let me start by saying I'm frustrated and losing faith in Zoho. Zoho pitches their service as easy to use and mobile compatible....but they neglect to make it clear that certain features do not work well on mobile devices. And the new Android Creator app does not handle subforms with image uploads. So I invested a lot of time and money creating and app that allows us to create work order tickets for our field service tech. Everything we do is documented by photos. It can be 5 photos or 20 depending
Another window type for openUrl
Hello! Can you add a new window type in openUrl function? Type "New Tab". "New window" is not easy to tabbed browsers. Thank you, Ulia
I can't get a condition for a Report to work
I have a report that lists all companies grouped by territory. I want to open that report restricted to companies in the territory in which the current user resides. The user's territory is PersonForm[Email_fld==zoho.loginuserid].Territory_fld In the report definition I want to say show all rows from CompanyForm[Territory_fld == this user's territory] But if I code it thus show all rows from CompanyForm[Territory_fld == PersonForm[Email_fld==zoho.loginuserid].Territory_fld] the
Is there a field limit?
I searched but could not find the answer. I have a zoho creator application that needs over a hundred fields on a single form. I get 99 added, but when I drag the 100th field onto the form, I just get a spinning "adding". Have I reached a limit?
Need unique case ID field
If I use the auto number field, it is hidden and the user cannot see the field to use that as a case id. Due to confidentiality requirements, using the victim name is not an option. I am assuming I will have to use a single text with no duplicate entries. But, this means the users will have to generate their own case ids. Is there a better way to insure compliance and consistency? I would really like to keep my current method, ##-####-#### first two digits, member program service provider id
Creating a composite report
Hi everyone, I need to produce a composite report for my database. The database contains student information. The first table contains the "front page" information, consisting: Name, DOB, Class, Residential House. Then there are other tables all with a lookup selection box in each pointing to Name+DOB from this front page. These tables contain: Home Information Family Contact Information Emergency Medical Information Daily Requirements etc etc I need to produce a final report using the majority
Next Page